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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need to Bind Several Dataset Tables to a One Datagrid

Status
Not open for further replies.

1Data

MIS
Sep 30, 2005
66
US
When I try to renders a Datagrid that is bound to a dataset it only displays the first table in the dataset? Is there a way to render all the tables in the dataset through that datagrid?
 
No, you would have to create your SQL to generate one table and use that to display

Jim
 
Jim can you give me an example please? something generic...
 
Just a simple join in the database e.g.
Code:
SELECT TABLE1.FIELD1, TABLE2.FIELD2
FROM TABLE1 INNER JOIN TABLE2
ON TABLE1.ID = TABLE2.SUBID


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 
I probably should of said this from the beginning but I am loading my dataset from an XML Document.
 
just load your XML doc into one table and use that as your data source
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top