I need Gridview Update Query by single button click

This may be a solution:

Bind your data to gridview so one of not nullable field you can find if record from database or will be added to database so you can decide what you should do!


DataTable dt=your table result

for (int i=0;i<(record count able to be inserted);i++)
{

DataRow dr=dt.NewRow();
dt.Rows.Add(dr);
}


protected void Button1_Click(object sender, EventArgs e)
{
foreach (GridViewRow g1 in GridView1.Rows)
{
string connStr = ConfigurationManager.ConnectionStrings["demoConStr"].ConnectionString;
SqlConnection con = new SqlConnection(connStr);

if (((TextBox)g1.findControl ("txtId").Text=="") //txtId is control which binds not nullable field on your data
{
com = new SqlCommand("Insert into prodata (ID,sl,cpoints,spec,actual,remark,status,fil) Values ('" + txtsystemid.Text + "','" + g1.Cells[0].Text + "','" + g1.Cells[1].Text + "','" + ((TextBox)g1.Cells[2].FindControl("txtspecbind")).Text + "','" + ((TextBox)g1.Cells[3].FindControl("txtactbind")).Text + "','" + ((TextBox)g1.Cells[4].FindControl("txtrembind")).Text + "','" + ((DropDownList)g1.Cells[5].FindControl("checkbind")).Text + "','" + 0 + "' )", con);
con.Open();
com.ExecuteNonQuery();
con.Close();
}
else
{

//your update query
}

}
lblm.Text = "Records inserted successfully";

}