private void btnCancel_Click(object sender, EventArgs e)
{
var result = MessageBox.Show("Are you sure you want to leave?", "Exit", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
this.Close();
frmCars cars = new frmCars();
cars.Show();
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
string Username = txtUsername.Text;
string Password = txtPassword.Text;
if (Username != "" || Password != "")
{
Username = Username.ToLower();
using (SqlConnection con = new SqlConnection(myConString))
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT * FROM Staff WHERE Username = '******' AND Password = '******'";
SqlDataAdapter sda = new SqlDataAdapter(cmd);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error Loading data", MessageBoxButtons.OK, MessageBoxIcon.Error);
}finally
{
con.Close();
frmCars cars = new frmCars();
cars.Show();
this.Hide();
}
}
}
else
{
MessageBox.Show("Enter missing text fields");
}
}