I return a dataset from a function.
This has 3 fields.
Month, WorkHrs, ContractWrkHrs
So the data may look like:
So, the months are January, March and Novemeber.Code:1, 45, 234 3, 23, 98 11, 19, 101
before I pass this data to a datagrid to bind I would like to add all the other months. so the data in the dataset will be:
How would I do this?Code:1, 45, 234 2, 0, 0 3, 23, 98 4, 0, 0 5, 0, 0 6, 0, 0 etc
I basically want to show Jan to Dec in a grid whether they exist or not in the DB.
Woka




Reply With Quote