Guest User

Untitled

a guest
Feb 20th, 2018
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. public static Boolean Login(string number, string name)
  2. {
  3. string connString = ConfigurationManager.ConnectionStrings["sqlconnectionstring"].ConnectionString;
  4.  
  5. using (SqlConnection conn = new SqlConnection(connString))
  6. {
  7. SqlCommand cmd = new SqlCommand("SELECT Holders.number, Holders.name from Holders where (Holders.number = @number AND Holders.name = @name)", conn);
  8. cmd.Parameters.Add("number", SqlDbType.Char).Value = number;
  9. cmd.Parameters.Add("name", SqlDbType.Char).Value = name;
  10. conn.Open();
  11. using (SqlDataReader reader = cmd.ExecuteReader())
  12. {
  13. while (reader.Read())
  14. {
  15. return true;
  16. }
  17. } // Dispose Reader
  18. } // Dispose connection
  19. return false;
  20. }
  21. }
Add Comment
Please, Sign In to add comment