Hi, Im busy desinging a website for a holiday home rental agency. I want the user to be able to select an arrival date and departure date and then search to display the appartments available within these selected dates. The way I was going to go about creating this facility was using ASP.NET and SQL.

I am fairly new to both and I am a bit stuck on what I need to include in the SQL databse to relate to the dates the user selects form drop down list boxes.. I had thought of including a column for example 'bookdate' and listing all of the dates that the apartment is booked in this column? Then running the query to display apartments which avoid these dates? But this doesnt seem the most efficent way to me and I figured there must be an easier way! Can anyone help me out my mind seems to have gone blank!

The selection part will look something like this:


and the results to be displayed like this:


Any help at all will be appreciated, thanks!