Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dataview multiple tables?

Status
Not open for further replies.

Glowworm27

Programmer
May 30, 2003
587
US
A dataset can have multiple tables, can a Dataview have multiple tables?

I am asking becasue I am trying to populate a treeview with hierarchal data that I am retrieveing into a dataset and trying to bind to a treeview.

Thanks

George Oakes
Goakes@TiresPlus.com = Programmer
George@1-Specialday.com = Mobile DJ
Check out this awsome .Net Resource!
 
How about creating a table that is populated by a UNION of SQL Statements? Once you populated the table you can assign it to you DataView and you should be able to proceed...

hth

Daren J. Lahey
Just another computer guy...
FAQ183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
Support your forums TODAY!
 
Thanks,

No I was trying to use relational tables to load a treeview, but that wasn't working the way the documents were written.

Most of the examples for web treeviews only cover relational data that is Parent - Child, and I need to dynamicaly populate a tree that is MANY layers deep

Parent -> Child -> SubChild -> SubSubChild -> etc.....

and right now im only 4 layers deep but still the ability to go down an unlimited number of nodes is what I'm looking for.

I have 4 tables. first is a Region of Stores (4 regions breaking up the US)
then next are districts which has a One to many relation ship with the Regions
then the Stores that have a one to many relationship with districts,
and Finaly Customers that have one to many relationship with the stores.

The online help for tree views, Isn't :)

Microsoft treeview wants XML data but doesnt define the Data layout



George Oakes
Goakes@TiresPlus.com = Programmer
George@1-Specialday.com = Mobile DJ
Check out this awsome .Net Resource!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top