protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { clspassinggrade objpass = new clspassinggrade(); if (e.CommandName == "Edit") { lbllegend.Text = "Edit Passing Grade"; Panel1.Visible = true; Button1.Visible = false; int i = Convert.ToInt32(e.CommandArgument); Label9.Text = i.ToString(); objpass.ID = i; // da = new SqlDataAdapter("select * from PassingGrade where ID="+i,con); dt = new DataTable(); dt = objpass.filgrid_pas2(); // da.Fill(dt); txtname.Text = dt.Rows[0]["Name"].ToString(); txtequiGpa.Text = dt.Rows[0]["EquivallentGPA"].ToString(); chkstatus.Checked = Convert.ToBoolean(dt.Rows[0]["Active"]); txtname.Focus(); } if (e.CommandName == "Delete") { int i = Convert.ToInt32(e.CommandArgument); cmd = new SqlCommand("delete from PassingGrade where ID=" + i, con); if (cmd.Connection.State.ToString() != "Open") { con.Open(); } cmd.ExecuteNonQuery(); con.Close(); fillgrid(); lblmessage.Visible = true; lblmessage.Text = "Record deleted successfully."; } }