Get Data from Oracle cursors

k_kosaraju · October 29th, 2004, 01:23 PM

I have written a stored procedure with 2 cursors of out direction. I want to retreive the 2 cursor record sets into one dataset. I am able to create dataset with one cursor. Can you pls help me how o get from 2 cursors and i want to store the data into a single dataset with 2 tables.

DARSIN · November 10th, 2004, 11:55 AM

are'nt u using ref cursors

mlingamus · January 27th, 2009, 11:38 AM

create a data adapter based on your datasource.
here I am using oracle

Code:

OracleCommand cmd = new OracleCommand();
OracleDataAdapter dbAdapter = new OracleDataAdapter();
dbAdapter.cmd = conn;
//assign the stored procedure to cmd
//assign the command type to be storedprocedure, then

Code:

DataSet dataSet = newDataSet();
DataTable dataTable = newDataTable();
dataTable.BeginLoadData();
dbAdapter.Fill(dataTable);
dataTable.EndLoadData();
dataSet.EnforceConstraints = false;
dataSet.Tables.Add(dataTable);

this should have both tables written into one dataset.

to check you can write the tables to a xml schema and see if you have the tables:

dataSet.WriteXmlSchema("path\\tables.xsd");

Hope this helps