private void Registration_Click(object sender, EventArgs e) { this.Hide(); Registration_form rf = new Registration_form(); rf.ShowDialog(); }
private void Submit_button_Click(object sender, EventArgs e) { String DateOfBirth = combo_Day.Text + " " + combo_Month.Text + " " + combo_Year.Text; String Student_CGPA = "0"; if (Text_Student_Name.Text.Length > 1 && Text_Father_Name.Text.Length > 1 && Text_Mother_Name.Text.Length > 1 && Text_Address.Text.Length > 1 && combo_Department.Text.Length > 1 && combo_Program.Text.Length > 1 && DateOfBirth.Length > 1 && combo_Gender.Text.Length > 1 && Text_StudentID.Text.Length > 1 && Text_Studentpass.Text.Length > 1 && Text_StudentConPass.Text.Length > 1) { SqlConnection sqlconn = new SqlConnection(@"Data Source=DESKTOP-R54EQ4I;Initial Catalog=Student_Profile;Integrated Security=True"); String queary = "Select * from Student_Registration where Student_ID = '" + Text_StudentID.Text.Trim() + "'"; SqlDataAdapter sda = new SqlDataAdapter(queary, sqlconn); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows.Count == 1) { MessageBox.Show("This Student ID Already Exist"); } else { if (Text_Studentpass.Text == Text_StudentConPass.Text) { SqlConnection sqlcon = new SqlConnection(@"Data Source=DESKTOP-R54EQ4I;Initial Catalog=Student_Profile;Integrated Security=True"); sqlcon.Open(); SqlCommand cmd = new SqlCommand("insert into Student_Registration(Student_Name,Father_Name,Mother_Name,Student_address,Department,Program,Birthday,Gender,cgpa,Student_ID) values('" + Text_Student_Name.Text + "','" + Text_Father_Name.Text + "','" + Text_Mother_Name.Text + "','" + Text_Address.Text + "','" + combo_Department.Text + "','" + combo_Program.Text + "','" + DateOfBirth + "','" + combo_Gender.Text + "','" + Student_CGPA + "','" + Text_StudentID.Text + "')", sqlcon); SqlCommand cmd2 = new SqlCommand("insert into Student_Login values('" + Text_StudentID.Text + "','" + Text_Studentpass.Text + "')", sqlcon); cmd.ExecuteNonQuery(); cmd2.ExecuteNonQuery(); sqlcon.Close(); MessageBox.Show("Registration Successfull"); this.Hide(); Registration_form rf = new Registration_form(); rf.ShowDialog(); } else { MessageBox.Show("Password and Confirm don't Match"); } } } else { MessageBox.Show("Fill In The All Information"); } }