private void Btnlogin_Click(object sender, RoutedEventArgs e)
{
//Dashboard d = new Dashboard();
//d.Show();
try
{
string myConnection = "datasource=localhost;port=3306;username=root;password=;database=pharmacy";
MySqlConnection mySqlConnection = new MySqlConnection(myConnection);
MySqlCommand SelectCommand = new MySqlCommand("select * from login where ID='" + this.user_name.Text + "' and Password='******' ;", mySqlConnection);
MySqlDataReader myReader;
mySqlConnection.Open();
myReader = SelectCommand.ExecuteReader();
//int count = 0;
//while(myReader.Read())
//{
// count = count + 1;
//}
if (myReader.Read())
{
MessageBox.Show("Username and Password is correct!");
Dashboard d = new Dashboard();
d.Show();
this.Hide();
}
else
{
MessageBox.Show("invalid username or password!");
}
mySqlConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Back_Click(object sender, RoutedEventArgs e)
{
Dashboard d = new Dashboard();
d.Show();
}
