private void btnLogin_Click(object sender, EventArgs e)
{
ConnectServer sr = new ConnectServer();
try
{
string qry = "select * from login where Designation='" + comLog.Text.Trim() + "' and UserName='******' and Password='******'";
MySqlDataAdapter adp = new MySqlDataAdapter(qry, sr.ConPass());
DataTable dt = new DataTable();
adp.Fill(dt);
if (dt.Rows.Count == 1)
{
MessageBox.Show("Access Granted..!\n\n Welcome" + " " + txtUser.Text.Trim() + " " + "to the System");
this.Hide();
Home hom = new Home();
hom.Show();
}
else
{
MessageBox.Show("Access Denied..\n Please Try Again..!");
}
comLog.ResetText();
txtPass.Clear();
txtUser.Clear();
}
catch (Exception ex)
{
MessageBox.Show("Oops: Something went wrong with the DB Connection Please try again\n" + ex.Message);
}
sr.ConnClose();
}