Guest User

Untitled

a guest
Oct 27th, 2017
131
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.23 KB | None | 0 0
  1. private LogIn GetDetails(string UserName)
  2. {
  3. SqlConnectionStringBuilder connectionString = new SqlConnectionStringBuilder();
  4. connectionString.DataSource = "IP,Port";
  5. connectionString.InitialCatalog = "Database Name";
  6. connectionString.UserID = "sa";
  7. connectionString.Password = "Password";
  8. var logIn = new LogIn();
  9. try
  10. {
  11. using (SqlConnection conn = new SqlConnection(connectionString.ConnectionString))
  12. {
  13. conn.Open();
  14. if (conn.State == System.Data.ConnectionState.Open)
  15. {
  16. using (SqlCommand cmd = conn.CreateCommand())
  17. {
  18. cmd.CommandText = $"SELECT * FROM Login where UserName = '{UserName}'";
  19. using (SqlDataReader reader = cmd.ExecuteReader())
  20. {
  21. while (reader.Read())
  22. {
  23. logIn.UserName = reader.GetString(0);
  24. logIn.Password = reader.GetString(1);
  25. logIn.Type = reader.GetString(2);
  26. }
  27. }
  28. }
  29. }
  30. }
  31. return logIn;
  32. }
  33. catch (Exception)
  34. {
  35. return null;
  36. }
  37. }
Add Comment
Please, Sign In to add comment