ASP.NET - not able to insert multiple records into database

Asked By Dikshan Shah on 12-Sep-12 10:40 PM

i WANT TO STORE VALUES WHICH ARE IN LABELS. i HAVE A REGISTRATION PAGE AND I AM NOT ABLE TO INSERT ALL THE VALUES INTO DATABASE. THERE ARE SOME CONFLICTS. ERROR IS SOMETHING LIKE "STRING TRUNCATED ..." I AM USING EXECUTENONQUERY.
GUIDE ME SOME STEP OR CODING BECAUSE I HAVE TRIED ALL USING DIRECT QUERY OR BY PASSING PARAMETER ALSO.
SAME PROBLEM....

Jitendra Faye replied to Dikshan Shah on 13-Sep-12 01:12 AM

First check that what is the length of the values which you want to insert into table because if it is crossing limit then data will be truncated.

Dikshan Shah replied to Jitendra Faye on 13-Sep-12 02:48 AM

size of all fields is varchar(50) and still the same error i got...

Anandh Ramanujam replied to Dikshan Shah on 17-Sep-12 02:29 AM

Check the length of all the values greater than 50... that might be the issue...