Guest User

Untitled

a guest
Jan 20th, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. var date = TxtDate.Text;
  2. var room_name = DrpRoom.Text;
  3. var attendees_pax = DrpPax.SelectedValue;
  4. var start_time = GetSelectedTimeIn;
  5. var end_time = GetSelectedTimeOut;
  6. string sql = $@"UPDATE Meeting SET date = '{date}', attendees_pax ={attendees_pax},start_time = '{start_time}', end_time = '{end_time}' where meeting_id = {0}";
  7.  
  8.  
  9. enter code here
  10. int rowsAffected = DBUtl.ExecSQL(sql, TxtMeetingID.Text);
  11. if (rowsAffected == 1)
  12. {
  13. Response.Redirect("CurrentBooking.aspx");
  14. }
  15. else
  16. {
  17. LtlMsg.Text = "Error " + DBUtl.DB_Message;
  18. }
  19. }
Add Comment
Please, Sign In to add comment