Guest User

Untitled

a guest
Jun 27th, 2018
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.90 KB | None | 0 0
  1.             var authResult = new DataTable();
  2.             using (var sqlConnection = new SqlConnection(connectionString))
  3.             {
  4.                 sqlConnection.Open();
  5.  
  6.                 using (var sqlCommand = new SqlCommand("SELECT Password FROM Users WHERE Username = @user", sqlConnection))
  7.                 {
  8.                     sqlCommand.Parameters.Add("@user", SqlDbType.VarChar).Value = user;
  9.  
  10.                     using (var sqlReader = sqlCommand.ExecuteReader())
  11.                     {
  12.                         authResult.Load(sqlReader);
  13.                     }
  14.                 }
  15.  
  16.             }
  17.  
  18.             if (authResult.Rows.Count == 0) return;
  19.  
  20.             //Username did Exist!
  21.             var dbPassword = Convert.ToString(authResult.Rows[0]["Password"]);
  22.             if (string.CompareOrdinal(dbPassword, pass) == 0)
  23.             {
  24.                 //ADD DATA HERE
  25.             }
Add Comment
Please, Sign In to add comment