private void back_Click(object sender, EventArgs e)
{
this.Hide();
Menu mn = new Mobiles.Menu();
mn.Show();
}
private void label2_Click(object sender, EventArgs e)
{
try
{
conn = new MySqlConnection(connString);
string username = textBox1.Text;
string password = textBox2.Text;
conn.Open();
/*string query = "insert into login(username,password) values('" + username + "','" + password + "')";
* SqlCommand cmd = new SqlCommand(query, conn);
* int result = cmd.ExecuteNonQuery();
* string text = textBox1.Text + textBox2.Text;
* MessageBox.Show(result.ToString());*/
userType = "";
string query = "select type from login where username='******' and password='******'";
MySqlCommand cmd = new MySqlCommand(query, conn);
MySqlDataReader red = cmd.ExecuteReader();
while (red.Read())
{
userType = red[0].ToString();
}
//int cnt = int.Parse(cmd.ExecuteScalar().ToString());
if (userType != "")
{
Menu mn = new Mobiles.Menu();
mn.Show();
this.Hide();
}
else
{
MessageBox.Show("Invalid Credentials.", "Credentials", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
textBox1.Text = "username";
textBox2.Text = "password";
conn.Close();
}
}
