private void button6_Click(object sender, EventArgs e)
{
this.Hide();
mainMenu MM = new mainMenu();
MM.ShowDialog();
}
/// <summary>
/// Login button
/// Checks user entered username and password against table data
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void loginButton_Click(object sender, EventArgs e)
{
SqlConnection loginConnection = new SqlConnection(@"Data Source = (LocalDB)\MSSQLLocalDB; AttachDbFilename = F:\bugTrackingDatabase.mdf; Integrated Security = True; Connect Timeout = 30");
SqlDataAdapter loginAdapter = new SqlDataAdapter("SELECT count(*) FROM loginTable WHERE username = '******' AND password = '******'", loginConnection);
DataTable dt = new DataTable();
loginAdapter.Fill(dt);
if (dt.Rows[0][0].ToString() == "1")
{
this.Hide();
mainMenu MM = new mainMenu();
MM.ShowDialog();
}
else
{
MessageBox.Show("Invalid Username or Password.", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
