DataGrid + Access-DB - display date-values grouped by date and time?

[Olaf Rabbachin]

Hi folks,

I have a table in an Access-DB that has a date-field (date + time). I'd
like to use a DataSet + DataGrid to achieve a grouped/hierarchical display
where the user would work his/her way from years to months therein (rows
with items only) and finally the data-rows themselves.
My first idea is to setup a DataSet containing virtual tables, but I'm
wondering as to how I could split up the date from the database into date &
time (and whatever comes below that level) because VBA-functions such as
DatePart() and Format() won't be available, thus I'll only be able to query
the date-field as a whole. How would I get years and months separated and
into the DataSet?

Any hints on where to start?

TIA & cheers,
Olaf

 

[Cor Ligthert]

Olaf,

What you ask is in my opinion certainly not the best part of Net, however
have a look at this. And link than deeper to datetime.

http://msdn.microsoft.com/library/d...ormsdatagridtextboxcolumnclassformattopic.asp

I hope this helps,

Cor