data representation of months in a web page

[monfu]

Dear all,

I wish to do a display on a web page something of this sort:-

Month Name
Date Title 1 Title 2 Price
Entry1
Entry2
Entry3

Month Name2
Date Title 1 Title 2 Price
Entry4
Entry5
Entry6

Month Name3
Date Title 1 Title 2 Price
Entry7
Entry8
Entry9

My idea is to create multiple dynamic datagrids and bind them to the data retreived for that particular month.

However i was wondering if there is a shorter work-around for this representation

Thanks for your help

Johann

[daninmanchester]

I think what you need is a nested data repeater / data grid bound to a dataset or datareader.

you would have to handle the nested repeater databinding manually within the itemdatabound event.

[snow]

The best way I've found to get month names in ASP.net is by using:

Code: Select all

 
dim dtfi as System.Globalization.DateTimeFormatInfo = new System.Globalization.DateTimeFormatInfo
monthName = dtfi.getMonthName(monthNo)

So, then if monthNo was '03', then monthName would be March.


If you're getting the full date from a datasource, and I'm assuming you need to extract it from an an msSQL database, you'd need the query:

Code: Select all

SELECT DATEPART(mm,monthField) as theMonth

I made some very large assumptions when writing this - but I hope you can get something useful out of it!

Good luck,
Snow