You can make a dataadapter and a data set..
daTest = new dataadapter();
DataSet dsTest = new DataSet(); // or use a typed dataset
daTest.SelectCommand = cmdSelect; //your stored proc
daTest.Fill(dsTest, "tablename"); // your dataset to fill and the table name
in the dataset..
Or leave out the table name to fill all tables ...
Or have separate stored procs and set the select command equal to each one
before filling each table.
I hope this helps.
Cheers
Claire
"gh" <gh******@FSAF.COM> wrote in message
news:%2******************@TK2MSFTNGP11.phx.gbl...
I have made the following stored procedure with the following select
statement
select * from user
select * from order, orderdetail where order.id=orderdetail.id
I know I can uses DataReader class to get data from the store procedue.
However, is there any way for me to use DataAdapter to get the data and
put it in separate DataTables in a DataSet?