J
Jon Bosker
Hi
My data is held in XML. I have 2 tables one with some time entry data
and the other with some project related data - here is the much
simplified version:
TimeEntries (table)
- StartTime (column)
- ProjectID (column)
Projects (table)
- ProjectID (column)
- ProjectName (column)
The two tables are related on ProjectID.
What I am trying to do is display my time entries with the ProjectName
in a datagrid (winforms) - spreadsheet style - like this:
StartTime | ProjectName
-------------------------
09:00 | MyProject
What is the best way to achieve this? I know I could create a new
dataset with a new datatable and brute-force the data in but that is
so ugly. I have tried creating a dataview and adding a new column but
when I saved the data back the new column was also there!
Surely there must be an elegant way to do this?!? Can anyone put me
out of my misery?
Regards, Jon
My data is held in XML. I have 2 tables one with some time entry data
and the other with some project related data - here is the much
simplified version:
TimeEntries (table)
- StartTime (column)
- ProjectID (column)
Projects (table)
- ProjectID (column)
- ProjectName (column)
The two tables are related on ProjectID.
What I am trying to do is display my time entries with the ProjectName
in a datagrid (winforms) - spreadsheet style - like this:
StartTime | ProjectName
-------------------------
09:00 | MyProject
What is the best way to achieve this? I know I could create a new
dataset with a new datatable and brute-force the data in but that is
so ugly. I have tried creating a dataview and adding a new column but
when I saved the data back the new column was also there!
Surely there must be an elegant way to do this?!? Can anyone put me
out of my misery?
Regards, Jon