protected void btnupdate_Click(object sender, EventArgs e) { clspassinggrade objpass = new clspassinggrade(); objpass.ID = Convert.ToInt32(Label9.Text); objpass.Name = txtname.Text; objpass.EquivallentGPA = txtequiGpa.Text; objpass.Active = Convert.ToInt32(chkstatus.Checked); objpass.executenonupdate_pass(); //cmd = new SqlCommand("update PassingGrade set Name='"+txtname.Text+"' , EquivallentGPA='"+txtequiGpa.Text+"' , Active='"+chkstatus.Checked+"' where ID='"+Label9.Text+"' " ,con); //if (cmd.Connection.State.ToString() != "Open") //{ // con.Open(); //} //cmd.ExecuteNonQuery(); //con.Close(); fillgrid(); clear(); btnupdate.Visible = false; btnsubmit.Visible = true; lblmessage.Text = "Record updated successfully."; lblmessage.Visible = true; lbllegend.Text = ""; Panel1.Visible = false; Button1.Visible = true; }
protected void btnsubmit_Click(object sender, EventArgs e) { clspassinggrade objpass = new clspassinggrade(); objpass.Name = txtname.Text; objpass.EquivallentGPA = txtequiGpa.Text; objpass.Active = Convert.ToInt32(chkstatus.Checked); objpass.executenoninsert_pass(); //cmd = new SqlCommand("insert into PassingGrade(Name,EquivallentGPA,Active) values('"+txtname.Text+"' , '"+txtequiGpa.Text+"' , '"+chkstatus.Checked+"')",con); //if (cmd.Connection.State.ToString() != "Open") //{ // con.Open(); //} //cmd.ExecuteNonQuery(); //con.Close(); fillgrid(); clear(); lblmessage.Text = "Record inserted successfully."; lblmessage.Visible = true; Panel1.Visible = false; Button1.Visible = true; lbllegend.Text = ""; }
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."; } }