Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private LogIn GetDetails(string UserName)
- {
- SqlConnectionStringBuilder connectionString = new SqlConnectionStringBuilder();
- connectionString.DataSource = "IP,Port";
- connectionString.InitialCatalog = "Database Name";
- connectionString.UserID = "sa";
- connectionString.Password = "Password";
- var logIn = new LogIn();
- try
- {
- using (SqlConnection conn = new SqlConnection(connectionString.ConnectionString))
- {
- conn.Open();
- if (conn.State == System.Data.ConnectionState.Open)
- {
- using (SqlCommand cmd = conn.CreateCommand())
- {
- cmd.CommandText = $"SELECT * FROM Login where UserName = '{UserName}'";
- using (SqlDataReader reader = cmd.ExecuteReader())
- {
- while (reader.Read())
- {
- logIn.UserName = reader.GetString(0);
- logIn.Password = reader.GetString(1);
- logIn.Type = reader.GetString(2);
- }
- }
- }
- }
- }
- return logIn;
- }
- catch (Exception)
- {
- return null;
- }
- }
Add Comment
Please, Sign In to add comment