private void buttonLogin_Click(object sender, EventArgs e)
{
MY_DB db = new MY_DB();
SqlDataAdapter adapter = new SqlDataAdapter();
DataTable table = new DataTable();
SqlCommand command = new SqlCommand("SELECT * FROM login WHERE username = @User AND password = @Pass", db.getConnection);
command.Parameters.Add("@User", SqlDbType.VarChar).Value = textBoxUsername.Text;
command.Parameters.Add("@Pass", SqlDbType.VarChar).Value = textBoxPassword.Text;
adapter.SelectCommand = command;
adapter.Fill(table);
if ((table.Rows.Count > 0))
{
this.DialogResult = DialogResult.OK;
MessageBox.Show("Login Success");
FormDashBoard dashBoard = new FormDashBoard();
dashBoard.Show(this);
}
else
{
MessageBox.Show("Invalid Username or Password", "Login Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}