private void btnExit_Click(object sender, EventArgs e) { StaffHome home = new StaffHome(); home.Show(); this.Close(); }
public void checkStaff() { //Create SqlConnection SqlConnection con = new SqlConnection(@"Data Source=KAVEER-PC\MSSQL;Initial Catalog=petcare;Integrated Security=True"); SqlCommand cmd = new SqlCommand("select * from userTable where userStatus = 'active' and userType = 'staff' and username = @username and userPassword = @password ", con); cmd.Parameters.AddWithValue("@username", txtUsername.Text); cmd.Parameters.AddWithValue("@password", MD5Hash(txtPwd.Text)); con.Open(); SqlDataAdapter adapt = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); adapt.Fill(ds); con.Close(); int count = ds.Tables[0].Rows.Count; //If count is equal to 1, than show frmMain form if (count == 1) { MessageBox.Show("Login Successful!"); StaffHome staff = new StaffHome(); this.Hide(); staff.Show(); } else { MessageBox.Show("Login Failed"); } }