Single Query returning me 4 tables, How to get all of them back into dataset ?

Posted by Shantanu Gupta on Stack Overflow See other posts from Stack Overflow or by Shantanu Gupta
Published on 2010-03-30T09:54:28Z Indexed on 2010/04/01 4:53 UTC
Read the original article Hit count: 273

Filed under:
|
|
|
|

How to fill multiple tables in a dataset.

I m using a query that returns me four tables.

At the frontend I am trying to fill all the four resultant table into dataset.

Here is my Query. Query is not complete. But it is just a refrence for my Ques

Select * from tblxyz compute sum(col1)

suppose this query returns more than one table, I want to fill all the tables into my dataset

I am filling result like this

con.open();
adp.fill(dset);
con.close();

Now when i checks this dataset. It shows me that it has four tables but only first table data is being displayed into it. rest 3 dont even have schema also.

What i need to do to get desired output

© Stack Overflow or respective owner

Related posts about ADO.NET

Related posts about dataset