Thursday, 16 April 2015

SQL Error String or binary data would be truncated. The statement has been terminated.

message =" String or binary data would be truncated. The statement has been terminated. " type =" System.Data.SqlClient.SqlException "

Root Cause:
Some if your input data is exceeding the length of the column.
In My came, i was having one column with name and length as 100, but i was sending 110 length name to database.

Solution: Increase the column size or trim input value..