public string UpdateStudentInfoTable(AddStudentClass addStOb) { string ID = null; connection.Open(); string insertString = "UPDATE Student_Info_Table SET Student_ID='" + addStOb.StudentId + "', St_Name='" + addStOb.StudentName + "',Dept_ID='" + Call_DeptID(addStOb.StudentDept) + "',Year='" + addStOb.StudentYear + "',Semester='" + addStOb.StudentSemester + "', Mobile='" + addStOb.StudentMobile + "',Email='" + addStOb.StudentEmail + "',Password='******' WHERE Student_ID='" + addStOb.StudentId + "'"; SqlCommand command = new SqlCommand(insertString, connection); command.ExecuteNonQuery(); connection.Close(); connection.Open(); string queryString = "SELECT Student_ID FROM Student_Info_Table WHERE Student_ID='" + addStOb.StudentId + "'"; SqlCommand cmd = new SqlCommand(queryString, connection); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { ID = reader["Student_ID"].ToString(); } connection.Close(); return(ID); }
public int InserIntoStudentInfoTable(AddStudentClass addStudentObj) { string ID = null; connection.Open(); string queryString = "SELECT Student_ID FROM Student_Info_Table WHERE Student_ID=('" + addStudentObj.StudentId + "') "; SqlCommand cmd = new SqlCommand(queryString, connection); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { ID = reader["Student_ID"].ToString(); } connection.Close(); if (ID == addStudentObj.StudentId) { return(0); } else { connection.Open(); string insertString = "INSERT INTO Student_Info_Table VALUES('" + addStudentObj.StudentId + "', '" + addStudentObj.StudentName + "', '" + Call_DeptID(addStudentObj.StudentDept) + "', '" + addStudentObj.StudentYear + "','" + addStudentObj.StudentSemester + "','" + addStudentObj.StudentMobile + "','" + addStudentObj.StudentEmail + "','" + addStudentObj.StudentPassword + "')"; SqlCommand command = new SqlCommand(insertString, connection); command.ExecuteNonQuery(); connection.Close(); return(1); } }
private void stAddButton_Click(object sender, EventArgs e) { addStudentObj = new AddStudentClass(); addStudentObj.StudentId = stIdTextBox.Text; addStudentObj.StudentName = stNameTextBox.Text; addStudentObj.StudentDept = stDeptComboBox.Text; addStudentObj.StudentYear = stYearComboBox.Text; addStudentObj.StudentSemester = stSemesterComboBox.Text; addStudentObj.StudentMobile = stMobileTextBox.Text; addStudentObj.StudentEmail = stEmailTextBox.Text; addStudentObj.StudentPassword = stPassTextBox.Text; if ((stIdTextBox.Text == "") || (stNameTextBox.Text == "") || (stDeptComboBox.Text == "") || (stYearComboBox.Text == "") || (stSemesterComboBox.Text == " ")) { MessageBox.Show("Please fill-up all field"); this.Update(); } else { ob = new Gateway(); if (ob.InserIntoStudentInfoTable(addStudentObj) == 1) { MessageBox.Show("Information Added Successfully!!!"); stResetButton_Click(sender, e); } else { MessageBox.Show("Already Added \"" + stNameTextBox.Text + "\""); } } }
private void stUpdateButton_Click(object sender, EventArgs e) { addStudentObj = new AddStudentClass(); addStudentObj.StudentId = stIdTextBox.Text; addStudentObj.StudentName = stNameTextBox.Text; addStudentObj.StudentDept = stDeptComboBox.Text; addStudentObj.StudentYear = stYearComboBox.Text; addStudentObj.StudentSemester = stSemesterComboBox.Text; addStudentObj.StudentMobile = stMobileTextBox.Text; addStudentObj.StudentEmail = stEmailTextBox.Text; addStudentObj.StudentPassword = stPassTextBox.Text; if (ob.UpdateStudentInfoTable(addStudentObj) == stIdTextBox.Text) { MessageBox.Show("Information Updated Successfully!"); ViewStudentProfile_Reset(); } else { MessageBox.Show("Could not Update !"); } }