how can I compare dates in a sqlserver database to

ysfkay · November 30th, 2009, 08:28 AM

Please how can I compare dates in a sqlserver database to dates on a calendar in order to determine the dates that a particalar room is free for booking.

I am trying to create a room reservation system, however I am having some strains.
here is what I am trying to do:
a customer should be able to view available dates for a particular room.I mean dates on which this room is free, so that he does not book a room that has already been taken on the time period he specifies he will be staying in the hotel.
please can anyone give me some help on this?

. Or is there another way I can do this. Thanks

jbenson001 · December 3rd, 2009, 04:19 PM

This is what I have done in the past. I created a datatable with all the info I needed, including the date(s) needed. Then, in the DayRender event of the calendar, I looped through all the rows in the datatable and compared the dates:

Code:

ForEach dr As DataRow In dt.Rows
  IfDirectCast(dr("YourDateColumn"), DateTime).Date = e.Day.Date Then
     .. DO STUFF HERE
End If

ysfkay · December 4th, 2009, 07:02 AM

Thanks alot, lot, will try the code, but could U help convert the code to c#, am kind of a rookie programmer and have little experience with vb...

thanks .

jbenson001 · December 4th, 2009, 11:00 AM

There are code converters on-line. Just use Google.