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

The error

String or binary data would be truncated. The statement has been terminated.
 
occurs when we try to insert or update data which is passed having length greater than which is specified in the database.
For Example
Column Name      Data Type
Description              varchar(50)
But we given more than 50 characters its will be truncated.


happy coding!!
 

Comments

Popular posts from this blog

Add Serial no in crystal report without coding

Working with Oracle's BLOB and Microsoft's C#

File operations in C# (.net)