Viewing data from many tables

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

Miha
Fri Dec 19 09:16:11 CST 2003

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.

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"Jakub Konecki" <jkonecki@lodz.home.pl> wrote in message
news:341a01c3c641$3c832f30$7d02280a@phx.gbl...
> 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

Darrin
Fri Dec 19 09:35:10 CST 2003

I ended up using a grid that I bought from Infragistics to do the same kind
of thing.

-Darrin


"Jakub Konecki" <jkonecki@lodz.home.pl> wrote in message
news:341a01c3c641$3c832f30$7d02280a@phx.gbl...
> 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