Guest User

Untitled

a guest
Sep 9th, 2018
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. show/hide label according to DataReader Results?
  2. SqlCommand selectuser = new SqlCommand("select username,password from users where username = '" + TextBox1.Text + "' and password = '" + TextBox2.Text + "'", badersql);
  3. badersql.Open();
  4. SqlDataReader dr = selectuser.ExecuteReader();
  5.  
  6.  
  7.  
  8. while (dr.Read())
  9. {
  10. if (dr["username"].ToString() == TextBox1.Text && dr["password"].ToString() == TextBox2.Text)
  11. {
  12.  
  13.  
  14. }
  15. else
  16. {
  17. Label1.Visible = true;
  18.  
  19. }
  20.  
  21. }
  22.  
  23. dr.Close();
  24.  
  25. SqlCommand selectuser = new SqlCommand("select username,password from users where username = '" + TextBox1.Text + "' and password = '" + TextBox2.Text + "'", badersql);
  26. SqlDataReader dr = null;
  27.  
  28. try
  29. {
  30. dr = selectuser.ExecuteReader();
  31. Label1.Visible = !dr.Read();
  32. }
  33. finally
  34. {
  35. if (dr != null)
  36. dr.Close();
  37. }
Add Comment
Please, Sign In to add comment