Guest User

Untitled

a guest
Jan 30th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. private void btn_login_Click(object sender, EventArgs e)
  2. {
  3.  
  4. string conn = ("datasource=localhost;Initial Catalog='MyDb';username=root;password=blahblah");
  5.  
  6. MySqlConnection con = new MySqlConnection(conn);
  7. MySqlCommand cmd = new MySqlCommand("select * from employees where BINARY usr_name=@name And BINARY usr_pwd=@pass", con);
  8. cmd.Parameters.AddWithValue("@name", txtUser.Text);
  9. cmd.Parameters.AddWithValue("@pass", txtPass.Text);
  10.  
  11. con.Open();
  12. MySqlDataAdapter adpt = new MySqlDataAdapter(cmd);
  13. DataSet ds = new DataSet();
  14. adpt.Fill(ds);
  15. con.Close();
  16.  
  17. if (ds.Tables[0].Rows.Count > 0)
  18. {
  19. MessageBox.Show(" Login Successful.nn Welcome back " + txtUser.Text + "!");
  20. }
  21. else
  22. {
  23. MessageBox.Show(txtUser.Text + ", you entered an invalid username and/or password!nnPlease try again...");
  24. }
  25. }
Add Comment
Please, Sign In to add comment