Sir I have problems in executing my pages with sqlserver 2008 while saving and updating the data i got an error as below in the code of line:
a= cm.ExecuteNonQuery();
The error is String or binary data would be truncated.
The statement has been terminated.
How can I resolve it. I am sending you the whole project with backup file of database.In it to logged in with the login page ,the loginname =SHESH and password =123 .Please sir give me the proper solution to the error
Loading
Jignesh TrivediPosted Apr 23, 2012, 2:19 AM
Can plese provide data which your enter (fill) from the page?
Kunal VaishyaPosted Apr 23, 2012, 1:49 AM
I have seen you code please check your Query String you are passing data in more than actual length
like this
CREATE TABLE #t
(
CL varchar(1)
);
Insert into #t (CL)values('A')
It is Ok
Insert into #t (CL)values('ABB')
it Will give you error