private void Back_Button_Click(object sender, EventArgs e) { this.Hide(); Student_Profile_Form spf = new Student_Profile_Form(); spf.ShowDialog(); }
private void Sign_In_Click(object sender, EventArgs e) { SqlConnection sqlconn = new SqlConnection(@"Data Source=DESKTOP-R54EQ4I;Initial Catalog=Student_Profile;Integrated Security=True"); String queary = "Select * from Student_Login where Student_ID = '" + text_StudentID.Text.Trim() + "' and Student_Passwrd = '" + text_StudentPassword.Text.Trim() + "'"; SqlDataAdapter sda = new SqlDataAdapter(queary, sqlconn); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows.Count == 1 && text_StudentID.Text.Length > 1 && text_StudentPassword.Text.Length > 1) { SqlConnection sqlcon = new SqlConnection(@"Data Source=DESKTOP-R54EQ4I;Initial Catalog=Student_Profile;Integrated Security=True"); sqlcon.Open(); SqlCommand cmd = new SqlCommand("Update Student_updateloginId set Student_ID = '" + text_StudentID.Text + "'", sqlcon); cmd.ExecuteNonQuery(); sqlcon.Close(); this.Hide(); Student_Profile_Form spf = new Student_Profile_Form(); spf.ShowDialog(); } else { MessageBox.Show("Wrong ID / Password"); } }