DataView on several DataTables???

[Marcel]

Hi
I now know that you cannot create a DataView on more than
one DataTable but are wondering if anyone knows a way
around this?
I only have a single DataSet with a handful of DataTables
saving changes made to the datatables into an xml
representation of the dataset no connections nor any data
is stored in a database!!

Thanks
Marcel

 

[Miha Markic]

Hi Marcel,

No, there is no simple way.
You could create a proxy class that returns data from more tables (like
DataView over more tables).
Or you could creata a combined DataTable and put joined data there. Then use
the combined table as datasource.
HOW TO: Implement a DataSet JOIN helper class in Visual C# .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;326080&Product=vcSnet

 

[Marcel]

Many thanks Miha
Looks like a good article with work-arounds..
Do you know if MS will incorporate this at some stage? It
would make a huge difference I think to the usability of
the DataViews!

 

[Miha Markic]

Hi Marcel,

Many thanks Miha
Looks like a good article with work-arounds..
Do you know if MS will incorporate this at some stage? It
would make a huge difference I think to the usability of
the DataViews!

Indeed. It would be very usefull feature.
Unfortunatelly, I haven't had yet time to look into whidbey release, so I
can't say.