Viewing data from many tables

  • Thread starter Thread starter Jakub Konecki
  • Start date Start date
J

Jakub Konecki

Hello!

I have a following problem. I have a dataset with many
tables, with master-detail relations. I want to display in
a DataGrid a view, that is composed from many columns from
many tables (ie. Col1, Col2 from Table1 and Col2, Col3
from Table3 ). I don't want to use a navigation feature,
but rather to display a normal table.

I can't use a DataView, because it operates on a single
table.

I found a DataSetHelper class in MSDN, but this code
generates new table and COPIES ALL DATA to the new one. I
find it at least not optimal to hold duplicate data in
memory ( all data is in the dataset ).

Do anyone have any idea, how to display a multi-table view
WITHOUT data duplication.

Best X-Mass and New Year wishes to all of you,
Jakub Konecki
 
Hi Jakub,

As you've found out there is no simple way.
You might construct a datasource (implementing IList or IBindingList) which
proxies the data from various tables.
 
I ended up using a grid that I bought from Infragistics to do the same kind
of thing.

-Darrin
 
Back
Top