Guest User

Untitled

a guest
Jul 18th, 2018
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. public static Boolean updateRequest(String _VUserName, DateTime newToDate)
  2. {
  3. SqlConnection conn = getConnection();
  4. SqlCommand command = new SqlCommand();
  5. command.CommandText = "UPDATE Requests SET [To] = @ToDate FROM Requests INNER JOIN "+
  6. "VUsers ON Requests.UserRef = VUsers.VUserID WHERE (VUsers.VUserName = @VUserName)";
  7.  
  8. command.Parameters.AddWithValue("@ToDate", newToDate);
  9. command.Parameters.AddWithValue("@VUserName", _VUserName);
  10.  
  11. conn.Open();
  12. try
  13. {
  14. command.ExecuteNonQuery();
  15. return true;
  16.  
  17. }
  18. catch (Exception)
  19. {
  20. return false;
  21.  
  22. }
  23. conn.Close();
  24. }
Add Comment
Please, Sign In to add comment