private void btnRemove_Click(object sender, EventArgs e) { if (MessageBox.Show("Do you really want to delete this student?", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { tblStudent st = new tblStudent(); st.studentId = ID; if (bllST.DeleteStudent(st)) { ShowAllStudent(); } } }
public void GETVALUEedit(string v1, string v2, string v3, string v4) { txtID.Text = v1; txtName.Text = v2; txtClass.Text = v3; txtScore.Text = v4; tblStudent st = new tblStudent(); st.studentId = ID; st.studentName = txtName.Text.Trim(); st.studentClass = txtClass.Text.Trim(); st.studentScore = txtScore.Text.Trim(); if (bllST.UpdateStudent(st)) { ShowAllStudent(); } }
public bool DeleteStudent(tblStudent st) { string sql = "DELETE tblStudent WHERE studentId = @studentId"; SqlConnection con = dc.getConnect(); try { cmd = new SqlCommand(sql, con); con.Open(); cmd.Parameters.Add("@studentID", SqlDbType.NVarChar).Value = st.studentId; cmd.ExecuteNonQuery(); con.Close(); } catch (Exception e) { return(false); } return(true); }
public bool UpdateStudent(tblStudent st) { string sql = "UPDATE tblStudent SET studentName = @studentName, studentClass = @studentClass, studentScore = @studentScore WHERE studentId = @studentId"; SqlConnection con = dc.getConnect(); try { cmd = new SqlCommand(sql, con); con.Open(); cmd.Parameters.Add("@studentID", SqlDbType.NVarChar).Value = st.studentId; cmd.Parameters.Add("@studentName", SqlDbType.NVarChar).Value = st.studentName; cmd.Parameters.Add("@studentClass", SqlDbType.NVarChar).Value = st.studentClass; cmd.Parameters.Add("@studentScore", SqlDbType.NVarChar).Value = st.studentScore; cmd.ExecuteNonQuery(); con.Close(); } catch (Exception e) { return(false); } return(true); }
public bool InsertStudent(tblStudent st) { string sql = "INSERT INTO tblStudent(studentID, studentName, studentClass, studentScore) VALUES(@studentID, @studentName, @studentClass, @studentScore)"; SqlConnection con = dc.getConnect(); try { cmd = new SqlCommand(sql, con); con.Open(); cmd.Parameters.Add("@studentID", SqlDbType.NVarChar).Value = st.studentId; cmd.Parameters.Add("@studentName", SqlDbType.NVarChar).Value = st.studentName; cmd.Parameters.Add("@studentClass", SqlDbType.NVarChar).Value = st.studentClass; cmd.Parameters.Add("@studentScore", SqlDbType.NVarChar).Value = st.studentScore; cmd.ExecuteNonQuery(); con.Close(); } catch (Exception e) { return(false); } return(true); }
public bool DeleteStudent(tblStudent st) { return(dalST.DeleteStudent(st)); }
public bool UpdateStudent(tblStudent st) { return(dalST.UpdateStudent(st)); }
public bool InsertStudent(tblStudent st) { return(dalST.InsertStudent(st)); }