Problem booking timeslots within a range of dates

[Twyce]

I'm working on a venue booking system.This system allows a person to make a booking for any period during the year(for a whole month or week).My problem is getting my system to check and display available time slots between a specified range.for example: a person may book from 12 August to 30 August,now how do i get the system to check and display available or unavailable slots.i'm using a grid to display all of this so what i want is my grid to shade with a color the booked time slots on a particular day and allow a person to select the slots they prefer on the grid with a different colour.Any help with this will be appreciated.(code,sql statements) Thanx

[Luc Pattyn]

Hi, you could loop over the days from date1 to date2, by "incrementing" a DateTime, using DateTime.AddDays(1); and check that each of these days is still free. And of course you would use DateTime.Date to get rid of the time component when performing comparisons. :)

Luc Pattyn [Forum Guidelines] [My Articles]

---

Voting for dummies? No thanks. X|

---