private void btnexit_Click(object sender, EventArgs e)
{
studes sd = new studes();
sd.Show();
this.Hide();
}
private void btnOK_Click(object sender, EventArgs e)
{
string query = "SELECT userid,password FROM studentregister WHERE userid= '" + txtuserid.Text + "' AND password = '******'";
if ((txtuserid.Text.Length > 0) && (txtpass.Text.Length > 0))
{
try
{
if (this.OpenConnection() == true)
{
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
MessageBox.Show("Login details confirmed!. Click OK to proceed. Thank you.", "LOGIN CONFIRMED!!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
rd.Close();
this.closeConnection();
txtuserid.Text = "";
txtpass.Text = "";
studes rs = new studes();
rs.Show();
this.Hide();
}
else
{
MessageBox.Show("login details not found.Register and try again.", "NOT REGISTERED", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.closeConnection();
rd.Close();
}
}
else
{
MessageBox.Show("Check the connection and try again.", "CONNECTION ERROR", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
this.closeConnection();
}
}
else
{
MessageBox.Show("Make your entries valid!");
}
}