private void MainMenuButton_Click(object sender, EventArgs e) { StudentMainMenu smm = new StudentMainMenu(); this.Hide(); smm.Show(); }
private void Conformbutton_Click(object sender, EventArgs e) { Connection obj = new Connection(); obj.con.ConnectionString = obj.locate; obj.con.Open(); SqlCommand cmd = obj.con.CreateCommand(); cmd.CommandType = CommandType.Text; if (EnterOldUsernamStudentetextBox.Text.Length > 0) { cmd.CommandText = "UPDATE Students SET Username ='******',Passward ='" + StudentsEditPasswardtextBox.Text + "',Email ='" + StudentsEditEmailtextBox.Text + "',Department ='" + StudentsEditDepartmenttextBox.Text + "'WHERE Username='******'"; cmd.ExecuteNonQuery(); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); MessageBox.Show("Successfully Updated!"); StudentsEditUsernametextBox.Text = ""; StudentsEditPasswardtextBox.Text = ""; StudentsEditEmailtextBox.Text = ""; StudentsEditDepartmenttextBox.Text = ""; } else { MessageBox.Show("Not Updated!"); } StudentMainMenu mainMenu = new StudentMainMenu(); this.Hide(); mainMenu.Show(); obj.con.Close(); }
private void SignInbutton_Click(object sender, EventArgs e) { if (StudentLoginradioButton.Checked) { if (UsernametextBox.Text != null && PasswardtextBox.Text != null) { try { Connection obj = new Connection(); obj.con.ConnectionString = obj.locate; obj.con.Open(); SqlDataAdapter adapter = new SqlDataAdapter("Select COUNT (*) FROM Students where Username ='******' and Passward ='" + PasswardtextBox.Text + "'", obj.con); DataTable dt = new DataTable(); adapter.Fill(dt); if (dt.Rows[0][0].ToString() == "1") { StudentMainMenu smm = new StudentMainMenu(); this.Hide(); smm.Show(); } else { MessageBox.Show("Username or Passward is incorrect"); } obj.con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } if (TeacherLoginradioButton.Checked) { if (UsernametextBox.Text != null && PasswardtextBox.Text != null) { try { Connection obj = new Connection(); obj.con.ConnectionString = obj.locate; obj.con.Open(); SqlDataAdapter adapter = new SqlDataAdapter("Select COUNT (*) FROM Teachers where Username ='******' and Passward ='" + PasswardtextBox.Text + "'", obj.con); DataTable dt = new DataTable(); adapter.Fill(dt); if (dt.Rows[0][0].ToString() == "1") { TeacherMainMenu tmm = new TeacherMainMenu(); this.Hide(); tmm.Show(); } else { MessageBox.Show("Username or Passward is incorrect"); } obj.con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }