How to update gridview selected checkbox row in database using C#

See more:

C#3.5

In gridview record as follows

Selectdata ID Qty Price Status

checkbox 1245 2 50 New
checkbox 1245 1 25 New
checkbox 4568 1 10 New
checkbox 2345 1 25 New
checkbox 4568 1 10 New

From the above gridview i am updating i am selecting first two rows from the gridview and upate in the database

String strConnString = ConfigurationManager.ConnectionStrings["ConnectionStrings"].ConnectionString;
SqlConnection con = new SqlConnection(strConnString);
con.Open();
foreach (GridViewRow row in grdRpt.Rows)
{
CheckBox cb = (CheckBox)row.FindControl("chkselecdata");
if (cb.Checked == true)
{
int key = Convert.ToInt32(grdRpt.DataKeys[row.RowIndex].Value);
SqlCommand cmd = new SqlCommand("UPDATE [transact].[transaction_item] SET Status = 'Ready' Where transactee_id=" + key.ToString(), con);
cmd.ExecuteNonQuery();
}
}
con.Close();

i am updating gridview selected row to database using c#

in the run mode i am selecting first row in the gridview for the id 1245 but in the database 1245 for the two rows updated in the database.

i am not selecting second row in the gridview
in the run mode i am selecting first row only in the gridview to update in the database. but in the database two rows 1245 are updating.

what is the mistake in my above code.


in the database ouput i get as follows

ID Qty Price Status

1245 2 50 Ready
1245 1 25 Ready

i am selecting only one first row in the gridview. but in database two rows updated for that selectd id 1245

what is the mistake in above code.

What I have tried:

In gridview record as follows

Selectdata ID Qty Price Status

checkbox 1245 2 50 New
checkbox 1245 1 25 New
checkbox 4568 1 10 New
checkbox 2345 1 25 New
checkbox 4568 1 10 New

From the above gridview i am updating i am selecting first two rows from the gridview and upate in the database

String strConnString = ConfigurationManager.ConnectionStrings["ConnectionStrings"].ConnectionString;
SqlConnection con = new SqlConnection(strConnString);
con.Open();
foreach (GridViewRow row in grdRpt.Rows)
{
CheckBox cb = (CheckBox)row.FindControl("chkselecdata");
if (cb.Checked == true)
{
int key = Convert.ToInt32(grdRpt.DataKeys[row.RowIndex].Value);
SqlCommand cmd = new SqlCommand("UPDATE [transact].[transaction_item] SET Status = 'Ready' Where transactee_id=" + key.ToString(), con);
cmd.ExecuteNonQuery();
}
}
con.Close();

i am updating gridview selected row to database using c#

in the run mode i am selecting first row in the gridview for the id 1245 but in the database 1245 for the two rows updated in the database.

i am not selecting second row in the gridview
in the run mode i am selecting first row only in the gridview to update in the database. but in the database two rows 1245 are updating.

what is the mistake in my above code.


in the database ouput i get as follows

ID Qty Price Status

1245 2 50 Ready
1245 1 25 Ready

i am selecting only one first row in the gridview. but in database two rows updated for that selectd id 1245.


what is the mistake in above code.