how to store data from datagridview to database

Hello,

Using stored procedure, you can store the data of datagridview.

like;

INSERT INTO table2(ID,NAME)//for particular columns
  SELECT ID,NAME
    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"

 DataGridView - Insert, Update, Delete and Retrieve records using stored procedure