Click here to Skip to main content
15,907,231 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have gridview binded with datatable. Now I want to insert data into sql-server database. If any column of gridview or datatable contain wrong datatype value(not matching the database column defination) that time I can modified the value inside gridview. After that I want to continue to inserting data to database.

Please help me how I can handle this activity.If there is any different way to checking and inserting data from datatable or gridview to database, then please give me how i can handle this.
Posted
Updated 23-May-13 18:46pm
v2
Comments
Dilan Shaminda 23-May-13 10:15am    
hi..if you have the database tables already created then you can define datagridview columns which match with the database table..isn't it?
Raju2049 27-May-13 0:13am    
yes
Sunasara Imdadhusen 24-May-13 0:35am    
Verifying with datatype of database column

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900