Add a new Column Template Field
<asp:TemplateField>
<ItemTemplate>
<asp:CheckBox ID="CheckBox1" runat="server" OnCheckedChanged = "OnCheckedChanged" AutoPostBack = "true"/>
</ItemTemplate>
</asp:TemplateField>
Then on the checked changed event do as following
protected void OnCheckedChanged(object sender, EventArgs e)
{
GridViewRow row = ((sender as CheckBox).NamingContainer as GridViewRow);
row.Cells[8].Text = "Success";
string client_trans_id = row.cells[2].Text;
//Update Database here
}