Solved String or Binary Data Would Be Truncated in C# SQL Server

This is very easy to solve exception String or Binary Data Would Be Truncated in c# sql.
First of all, you should understand the reason of this exception,
This exception String or Binary Data Would Be Truncated the Statement Has Been Terminated occurs due to the nvarchar or varchar limits in SQL.
Suppose you create a table with a column and datatype is nvarchar(8). It means
this column allowed up to 8 characters. But if you want to insert more than 8 characters then you will see this error How to Solve String or Binary Data Would Be Truncated in C# or SQL

- To solve this error just increase the nvarchar(8) to nvarchar(20) or nvarchar(200) as required.
- Save.
Thanks

Visit my page in Facebook
  / programminggeek7  
------
More Tags
#HowToSolveStringOrBinaryDataWouldBeTruncated #Fixed #SolvedStringOrBinaryDataWouldBeTruncated
programminggeek,solve string or binary data would be truncated, how to solve string or binary data would be truncated,string or binary data would be truncated in c# sql server,string or binary data would be truncated in c#,string or binary data would be truncated error,string or binary data would be truncated error in sql,how to fix string or binary data would be truncated in sql,string or binary data would be truncated