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.";
        }
    }