Hey guys! can you please help me.... I need my user to login to the application, My program must detect to wich depearment to user belongs to, for example if the sales person logs into the application the sales form should be called.... and so on! Having a little problem with that... This is what i have so far... but when, say the manager logs in it still goes to the administrator form....thx guys
private void btnLogin_Click(object sender, EventArgs e)
{
try
{
Conn.Open();
String SelectStr = "SELECT Name, EmpPassword, DepNo FROM Employees WHERE Name='" + txtUName.Text + "' and EmpPassword= '" + txtPassword.Text + "' and DepNo= '" + cbDep.Text + "'";
SqlCommand myComm = new SqlCommand(SelectStr, Conn);
SqlDataAdapter dap = new SqlDataAdapter(myComm);
DataSet dst = new DataSet();
dap.Fill(dst);
if (dst.Tables[0].Rows.Count > 0)
{
myComm.ExecuteNonQuery();
MessageBox.Show("Logged in");
String SelectStr2 = "SELECT DepNo FROM Employees WHERE DepNo='" + cbDep.Text + "'";
if (dst.Tables[0].Rows.Count > 0)
{
myComm.ExecuteNonQuery();
this.Hide();
Administrator Ad = new Administrator();
Ad.Show();
}
else
{
MessageBox.Show("Incorrect department ");
}
}
else
{
MessageBox.Show("Data Entered is incorrect");
}
Conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
{
}
}
}
}
}