How to update gridview row with unqiue values

See more:

C#3.5

In gridview record as follows

Selectdata ID Transactionid Qty Price Status

checkbox 1 1245 2 50 New
checkbox 2 1245 1 25 New
checkbox 3 4568 1 10 New
checkbox 4 2345 1 25 New
checkbox 5 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.

in the above update query how to get ID which is unique for Transaction id 1245


what is the mistake in my above code.


in the database ouput i get as follows

ID Transactionid Qty Price Status

1 1245 2 50 New
2 1245 1 25 New

What I have tried:

In gridview record as follows

Selectdata ID Transactionid Qty Price Status

checkbox 1 1245 2 50 New
checkbox 2 1245 1 25 New
checkbox 3 4568 1 10 New
checkbox 4 2345 1 25 New
checkbox 5 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.

in the above update query how to get ID which is unique for Transaction id 1245


what is the mistake in my above code.


in the database ouput i get as follows

ID Transactionid Qty Price Status

1 1245 2 50 New
2 1245 1 25 New
3 4568 1 10 New
4 2345 1 25 New
5 4568 1 10 New