How to update record in database using grdiview paging in C#

See more:

C#3.5

My code as follows


protected void btnsubmit_Click(object sender, EventArgs e)
{
try
{
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 transaction_id=" + key.ToString(), con);
cmd.ExecuteNonQuery();

}
}
con.Close();
}
catch (Exception ex)
{

}
}


in Gridview record as follows


selectdata ID Transacteedid Qty Price Status

Checkbox 1 12345 1 20 NEW
1 2 Paging in gridview

when i click 2 page in gridview below record will display
Chekbox 2 12345 2 30 NEW


i am selecting the gridview from page1 and page2 .

i am updating both record from page1 and page2 record from the gridview.

i have to one submit button called "Update".

when i update page2 record from the gridview only update in the database i am also selecting the record from page1 also.

But page1 record is not update in the database.

What is the mistake in my above code.

In update button i written for loop for the gridview. but it is not working.

What I have tried:

My code as follows


protected void btnsubmit_Click(object sender, EventArgs e)
{
try
{
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 transaction_id=" + key.ToString(), con);
cmd.ExecuteNonQuery();

}
}
con.Close();
}
catch (Exception ex)
{

}
}


in Gridview record as follows


selectdata ID Transacteedid Qty Price Status

Checkbox 1 12345 1 20 NEW
1 2 Paging in gridview

when i click 2 page in gridview below record will display
Chekbox 2 12345 2 30 NEW


i am selecting the gridview from page1 and page2 .

i am updating both record from page1 and page2 record from the gridview.

i have to one submit button called "Update".

when i update page2 record from the gridview only update in the database i am also selecting the record from page1 also.

But page1 record is not update in the database.

What is the mistake in my above code.

In update button i written for loop for the gridview. but it is not working.