How to Save Datagrid values on Button Click Event

On the save button event just put the below it will work.

foreach (DataGridItem dgi in gv.Items)   
{   
    string id = dgi.Cells[0].Text;   
    string name = dgi.Cells[1].Text;   
    SqlConnection conn = new SqlConnection(Common.GetConnectionString("SqlConnectionString"));   
    conn.Open();   
    SqlCommand comm = new SqlCommand("insert into table1 values (" + id + ",'" + qty+ "')", conn);   
    comm.ExecuteNonQuery();   
    conn.Close();   
}

hi murali, my datasource for gridview is on aspx page and i am using in .cs file like below GridView1.DataSourceID= "dsInvMast; GridView1.DataBind();

What is the datasource of the grid or its plain textboxes you have placed ?


You can iterate all the items in the grid and send it to database.
The database insertion operation may be for each records or you can bulk insert using sqldataadapter also.

foreach (DataGridItem dgi in gv.Items)  
{  
    string id = dgi.Cells[0].Text;  
    string name = dgi.Cells[1].Text;  
    SqlConnection conn = new SqlConnection(Common.GetConnectionString("SqlConnectionString"));  
    conn.Open();  
    SqlCommand comm = new SqlCommand("insert into table1 values (" + id + ",'" + qty+ "')", conn);  
    comm.ExecuteNonQuery();  
    conn.Close();  
}