private void btnLogin_Click(object sender, EventArgs e)
{
string connectionString = @"server = SHAWON\SQLEXPRESS;database = bus; integrated security = sspi;";
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
SqlDataAdapter sda = new SqlDataAdapter("Select count(*) From Login where Username='******' and Password = '******'", connection);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows[0][0].ToString() == "1")
{
MessageBox.Show("Successfully Logged In");
this.Hide();
MDIParent1 ss = new MDIParent1();
ss.Show();
}
else
{
MessageBox.Show("Please Check your Username and password");
}
}
