How do I display data from 2 tables in a datagrid?

[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

[Cor Ligthert]

Jon,

Just create a datarelation
In this message from yesterday it is set

http://groups-beta.google.com/group/...29d47a02137ebd

I hope this helps,

Cor

[Jon Bosker]

Thanks for the reply. I now believe that I need to use a
DataViewManager... something like this:

mySchema.ReadXml("MyFileName.xsd");
mySchema.Relations.Add("TimeProjects",
mySchema.Tables["Projects"].Columns["ProjectID"],
mySchema.Tables["TimeEntries"].Columns["ProjectID"]);
DataViewManager dvManager = new DataViewManager(mySchema);

But I still cannot figure out how to get the column into the datagrid -
doing the following would not include the ProjectName column:

this.dataGrid1.SetDataBinding(dvManager, "TimeEntries");

Can anyone offer any more advice?

Regards, Jon

*** Sent via Developersdex http://www.developersdex.com ***

[Cor Ligthert]

Jon,

The most simple way is first doing after setting the relations to the
dataset.

datagrid1.DataSource = YourDataset;

After that you can start playing with the dataviewmanager

[AMeador]

I am only starting to mess with the dataviews and dataviewmanagers
myself, but maybe this will help. There is a method of the
dataviewmanager that you can call the will return an instance of a
dataview based on the dataviewmanager. I think you have to bind the
dataview that is created from this method rather than trying to bind it
to the dataviewmanager object itself.

DataView myDV = dvManager.CreateDataView(???);
this.dataGrid1.DataSource = myDV;

From the samples I have played with so far, the ??? is a dataset. From

your code listed I don't what should go here.Anyway,maybe this will
help you move in the right direction.

- Andrew