private void button3_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Server=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\Database1.mdf");
SqlDataAdapter da = new SqlDataAdapter("select count(*) from login where user ='" + textBox1.Text + "' and pass='" + textBox2.Text + "'", con);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows[0][0].ToString() == "1")
{
Form2 f2 = new Form2();
f2.Show();
}
else
{
MessageBox.Show("Username or Password is not correct!", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
textBox1.Clear();
textBox2.Clear();
textBox1.Focus();
}
private void button3_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Server=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\Database1.mdf");
SqlDataAdapter da = new SqlDataAdapter("select count(*) from login where user ='" + textBox1.Text + "' and pass='" + textBox2.Text + "'", con);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count>0)
{
Form2 f2 = new Form2();
f2.Show();
}
else
{
MessageBox.Show("Username or Password is not correct!", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
textBox1.Clear();
textBox2.Clear();
textBox1.Focus();
}