private void btnHome_Click(object sender, EventArgs e)
{
frmIndexPage m = new frmIndexPage();
m.Show();
this.Close();
}
private void homeToolStripMenuItem_Click(object sender, EventArgs e)
{
frmIndexPage m = new frmIndexPage();
m.Show();
this.Close();
}
private void btnSubmit_Click(object sender, EventArgs e)
{
{
if (txtUserName.Text == "" || txtPassword.Text == "")
{
MessageBox.Show("Please provide UserName and Password");
return;
}
try
{
SqlConnection sqlcon = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=G:\Maintenance\Gas Logger\LoginDB.mdf;Integrated Security=True;Connect Timeout=30");
//Create SqlConnection
string query = "Select * from [Table] Where username= '******' and password = '******'";
//Creates an object which will send the query through the connection to the sql server
SqlDataAdapter sda = new SqlDataAdapter(query, sqlcon);
//Creates a dataTable in which we will input the login information that matches
DataTable dtbl = new DataTable();
//Fill the table with whatever entery in the DB fits the criteria of : having the username put in the txtUserName.txt and password from the txtPassword.txt
sda.Fill(dtbl);
//if there is a match found, allow access
if (dtbl.Rows.Count == 1)
{
MessageBox.Show("Login Successful! Welcome, " + txtUserName.Text);
this.Hide();
frmIndexPage fm = new frmIndexPage();
fm.Show();
}
else
{
MessageBox.Show("Login Failed!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
