how to store data from datagridview to database

Question

hello can anybody tell me how to store data from datagridview to sal server database.

Sam Hobbs · Answer

There are many articles in this web site to help you. Please look at the database articles and also look for database samples in the Windows Forms section.

Sahil Jani · Answer

Hello Using stored procedure you can store the data of datagridview. like; INSERT INTO table2(IDNAME)//for particular columns SELECT IDNAME FROM table1 or u need to write a STORED PROCEDURE like CREATE PROCEDURE Update1 { @name varchar(10) } AS update[table] set name=@name where ur condition this name uneed to pass from the front end. here im updating name. this will update ur DB IF MY ANSWER WILL HELP YOU IN YOUR CODE THEN CHECK THE BOX AS MARKED AS CORRECT ANSWER

Suthish Nair · Answer

DataGridView - Insert Update Delete and Retrieve records using stored procedure