private void button1_Click(object sender, EventArgs e) { this.Hide(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "select * from library_person where username='******' and password='******'"; cmd.ExecuteNonQuery(); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); count = Convert.ToInt32(dt.Rows.Count.ToString()); if (count == 0) { MessageBox.Show("Invalid Username or Password"); Form1 f1 = new Form1(); f1.Show(); } else { this.Hide(); mdi_user mu = new mdi_user(); mu.Show(); } }
private void button1_Click(object sender, EventArgs e) { //SqlCommand cmd = con.CreateCommand(); //cmd.CommandType = CommandType.Text; // con.Open(); string str = "select *from library_person where username='******' and password='******'"; cmd = new SqlCommand(str, con); SqlDataReader dr = cmd.ExecuteReader(); // DataTable dt = new DataTable(); // SqlDataAdapter da = new SqlDataAdapter(cmd); //da.Fill(dt); // count = Convert.ToInt32(dt.Rows.Count.ToString()); if (dr.Read()) { this.Hide(); mdi_user md = new mdi_user(); md.Show(); dr.Close(); } else { MessageBox.Show("Username and password does not match"); } }
private void CheckPasswordAndLogin(int AccountId) { if (AccountId == 0) { MessageBox.Show("Username and Password doesn't match!"); } else { this.Hide(); mdi_user mdiUser = new mdi_user(); mdiUser.Show(); } }