G
Guest
Hello All:
I have a DataTable whose rows are going to be rendered into an HTML table.
The trick is that there isn't a one-to-one relationship between a datarow and
a HTML table row. The data from one or more datarows could be used to create
a single HTML table row. The data contains, among other things, a date/time
stamp and a customer code. The timestamp determines a new row; number of
customer codes for that timestamp determine the number of entries in that
row. Here's a sample :
10/05/05 12:34 pm AXJ
10/05/05 12:34 pm AKL
10/05/05 12:37 pm BMJ
10/05/05 12:45 pm DFG
10/05/05 12:45 pm DRG
10/05/05 12:45 pm BTG
So, the HTML table's first row would contain info about the first two items;
its second row would contain info about the third item; the third row would
contain info about the last three items.
Is there a way for my to extract just the unique timestamps from the
DataTable? That way I can iterate through the timetamps and use the
DataTable's DefaultView's RowFilter property to extract only the records for
that particular timestamp.
Any help would be appreciated.
TIA,
I have a DataTable whose rows are going to be rendered into an HTML table.
The trick is that there isn't a one-to-one relationship between a datarow and
a HTML table row. The data from one or more datarows could be used to create
a single HTML table row. The data contains, among other things, a date/time
stamp and a customer code. The timestamp determines a new row; number of
customer codes for that timestamp determine the number of entries in that
row. Here's a sample :
10/05/05 12:34 pm AXJ
10/05/05 12:34 pm AKL
10/05/05 12:37 pm BMJ
10/05/05 12:45 pm DFG
10/05/05 12:45 pm DRG
10/05/05 12:45 pm BTG
So, the HTML table's first row would contain info about the first two items;
its second row would contain info about the third item; the third row would
contain info about the last three items.
Is there a way for my to extract just the unique timestamps from the
DataTable? That way I can iterate through the timetamps and use the
DataTable's DefaultView's RowFilter property to extract only the records for
that particular timestamp.
Any help would be appreciated.
TIA,