Need to Bind Several Dataset Tables to a One Datagrid

[1Data]

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?

 

[jbenson001]

No, you would have to create your SQL to generate one table and use that to display

Jim

 

[1Data]

Jim can you give me an example please? something generic...

 

[ca8msm]

Just a simple join in the database e.g.

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.

 

[1Data]

I probably should of said this from the beginning but I am loading my dataset from an XML Document.

 

[jbenson001]

just load your XML doc into one table and use that as your data source