i have a simple form which inserts data into database. now when user enters large data and the sql datatable datacoulm is defined to take less data it always throws an exception
System.Data.SqlClient.SqlException: String or binary data would be truncated.
The statement has been terminated.
so what is the best way to handle the exception. i know i ca set the max length of textbox to match with the datacoumn size..is their any other way to do it..
hmm like catch teh exception and tell the user exactly which field is waytoo bigger than it needs to be..
or how do peple handle such an exception