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

Hi there,

Can you please not double-post your messages (in the Basic and the Pro forums)? Once is enough as your message will be read anyway.

That said, you may want to take a look at the book ASP.NET 2.0 Instant Results (http://www.wrox.com/WileyCDA/WroxTit...471749516.html) It features a whole chapter discussing an appointment booking system.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Thanks for the link,the codes appear to be in vb, I am writing in csharp, never written much vb codes so I guess I will have to give it try converting the codes to c#.

I am trying to retrieve data from sqlser table, using linq to sql stored proc.
However the code encounters one error,it says " ; expected ". on the following line "hdc.CheckRoomAvailability();". Part of the code with the problem is below.If I cooment this part, the application runs fine. I cannot seem to trace the error, the same method works fine on other applications, any hint?

public List<CheckRoomAvailability> CheckRooms()
{
HotelDataContext hdc= new HotelDataContext();
List<CheckRoomAvailability> Rooms = newList<CheckRoomAvailability>();

ISingleResult<CheckRoomAvailabilityResult>Rooms
hdc.CheckRoomAvailability();

.......
.......

}