c# for dummies

string or binary would be truncated:

the solution is to check the columns of the table you are trying to insert into and make sure it there is
a match between the datatype you are using to insert from you User interface and the one on the database table.


for example:
  if you are using string say  .text

on the database table use nvarchar(50).