Advertisement
Guest User

Untitled

a guest
Apr 5th, 2018
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. SqlConnection sql = new SqlConnection(sqlConString);
  2. using (SqlCommand loginCmd = new SqlCommand())
  3. {
  4. loginCmd.Connection = sql;
  5. sql.Open();
  6. loginCmd.CommandType = System.Data.CommandType.Text;
  7. loginCmd.CommandText = "SELECT UserName, UserPassword from OfficeEmployees where UserName = @UserName AND UserPassword = @UserPassword";
  8. loginCmd.Parameters.AddWithValue("@UserName", Login_Box.Text);
  9. loginCmd.Parameters.AddWithValue("@UserPassword", usrPassword.Text);
  10. loginCmd.ExecuteNonQuery();
  11. SqlDataReader dr = loginCmd.ExecuteReader();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement