Dear Friend,
Try this:-
protected void GVDetails_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Approved")
{
GridViewRow row = (GridViewRow)((Control)e.CommandSource).NamingContainer;
int Id = Convert.ToInt32(GVDetails.DataKeys[row.RowIndex].Value.ToString());
Response.Write("the doc_id is = "+Id);
cn.Open();
cmd.Parameters.Add("@STAT", SqlDbType.VarChar,15,"APPROVED");
SqlCommand cmd = new SqlCommand("update tdocument set STAT=@STAT where doc_id="+Id+"",cn);
cmd.ExecuteNonQuery();
cn.Close();
}
else if (e.CommandName == "Reject")
{
Response.Write("Reject");
}
}