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
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