private void btnadd_Click(object sender, EventArgs e) { addstudent add = new addstudent(); add.Show(); this.Hide(); }
private void btnsubmit_Click(object sender, EventArgs e) { string query = "INSERT INTO addstudent(firstname, othername, regno, idno, yearofstudy, course, email, phoneno, address, gender) VALUES('" + txtfname.Text + "','" + txtoname.Text + "','" + txtreg.Text + "','" + txtidno.Text + "','" + txtyear.Text + "','" + cmbcourse.SelectedItem + "','" + txtemail.Text + "','" + txtphone.Text + "','" + txtaddress.Text + "','" + gender + "')"; if ((txtfname.Text.Length > 0) && (txtoname.Text.Length > 0) && (txtreg.Text.Length >= 4) && (txtemail.Text.Contains("@")) && (txtyear.Text.Length > 0) && (txtphone.Text.Length >= 8) && (txtidno.Text.Length >= 7) && (txtaddress.Text.Length >= 4) && (txtfname.Text.Length > 0)) { try { if (this.OpenConnection() == true) { MySqlCommand cmd = new MySqlCommand(query, connection); cmd.ExecuteNonQuery(); MessageBox.Show("Your details added successfully!!. Thank you.", "STUDENT DETAILS ADDED SUCCESSFULLY!!!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); this.closeConnection(); txtaddress.Text = ""; txtemail.Text = ""; txtfname.Text = ""; txtidno.Text = ""; txtoname.Text = ""; txtphone.Text = ""; txtreg.Text = ""; txtyear.Text = ""; cmbcourse.Text = ""; addstudent add = new addstudent(); add.Show(); this.Hide(); } else { MessageBox.Show("Details not added. Check the connection and try again."); } } catch (Exception ex) { MessageBox.Show(ex.Message); this.closeConnection(); } } else { MessageBox.Show("Make your entries valid!"); } }