A
Alan Silver
Hello,
I have some data that I'm pulling from an SQL Server, that looks like...
1 jan 05 10
2 jan 05 7
4 jan 05 9
7 jan 05 12
I would like to display this in a repeater, but I want to fill in the
missing days with zeroes, so it would look like...
1 jan 05 10
2 jan 05 7
3 jan 05 0
4 jan 05 9
5 jan 05 0
6 jan 05 0
7 jan 05 12
I have two thoughts about this, either to add the missing rows to the
repeater after it has been bound, or to create a new data table and fill
it with the info from the one pulled from the db, including the missing
days as I go along, and bind the new data to the repeater.
Now the first seems easier, but I can't see any way to do it, although
that could be 'cos I haven't found it yet!!
I have an idea how to do it the second way, but it seems very messy.
Anyone any ideas? TIA
I have some data that I'm pulling from an SQL Server, that looks like...
1 jan 05 10
2 jan 05 7
4 jan 05 9
7 jan 05 12
I would like to display this in a repeater, but I want to fill in the
missing days with zeroes, so it would look like...
1 jan 05 10
2 jan 05 7
3 jan 05 0
4 jan 05 9
5 jan 05 0
6 jan 05 0
7 jan 05 12
I have two thoughts about this, either to add the missing rows to the
repeater after it has been bound, or to create a new data table and fill
it with the info from the one pulled from the db, including the missing
days as I go along, and bind the new data to the repeater.
Now the first seems easier, but I can't see any way to do it, although
that could be 'cos I haven't found it yet!!
I have an idea how to do it the second way, but it seems very messy.
Anyone any ideas? TIA