Coding Error

Question

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

Answer 1

Thanks Feras...

Answer 2

you should check out the analytical and grouping functions provided by orcale 8i or more i mean the cube and rollup functions ... it contains a perfect solution for your problems ... but they are available only with oracle 8i or more .... read about it in oracle documentation, it is so helpfull functions for summerizing your SQL code and eliminating complexity and SAVING the query time Feras