How to fill dataset when sql is returning more than one table

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/03/30 10:23 UTC
Read the original article Hit count: 380

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