Creating date-based grid in ASP
 

I need to create a grid which along the y axis has a user name and along
the x axis has a date. Somehow I need to populate the x axis with 6
months worth of dates from the current date, and then look at a database
table that lists what dates a user is busy on so that I end up with a
grid that shows all users and all dates for the next 6 months and when
they are busy and when they are not busy.

I have very little experience in ASP so this is proving very tricky, I
think the hardest part would be creating the grid with a column for each
date for the next 6 months.
Can anybody help?



*** Sent via Developersdex http://www.developersdex.com ***

Re: Creating date-based grid in ASP
 

Mike P wrote:
> I need to create a grid which along the y axis has a user name and
> along the x axis has a date. Somehow I need to populate the x axis
> with 6 months worth of dates from the current date, and then look at
> a database table that lists what dates a user is busy on so that I
> end up with a grid that shows all users and all dates for the next 6
> months and when they are busy and when they are not busy.
>
> I have very little experience in ASP so this is proving very tricky, I
> think the hardest part would be creating the grid with a column for
> each date for the next 6 months.
> Can anybody help?
>
>
>
What database type and version are you using?
How is the data stored? Column names and datatypes please. A few rows of
sample data would not hurt.

--
HTH,
Bob Barrows