How to show fields from related tables in same datagrid

[Guest]

I run VS .Net 2003. I have a distributed application with sql server 2000 and
windows front end, written in c#.

I have a number of tables in a dataset with relations between them. In one
single read-only datagrid I would like to display child rows from a child
table as well as one column from the parent table. How can I fix this in an
easy way?

I thought I could handle this via dataviews and dataviewmanager as source
for the datagrid, but I have not found any good article. I need a detailed
explanation as I am a novice on this.

I realize I could produce a new table on the windows client from the two
related tables, but as I consider the data structure to be well designed this
is not what I would like to do.

Regards

Tore

 

[Bajoo]

Dear Tore,
One way to do this is to make a Class which contains all
the fields as properties from both tables. this class acts as your
container and use can assign a List of the class to the DataGrid

Regards,
Naveed Ahmad Bajwa
http://bajoo.blogspot.com/

 

[Guest]

Sorry, I am a novice on this.Your answer did not help me.

Regards

Tore