[RESOLVED] [2.0] Dataset question...

[bnathvbdotnet]

I am written the following code that will call oracle stored proc and the results are captured in a dataset.

In my new requirements, I need to call one more stored proc add the results from that procedure to the same dataset (may be a new table). so when I go thru this dataset I will have two datatables

How can add the results of the second stored proc to the same dataset (aDataSet)?

thanks

nath

OracleParameter ps1 = new OracleParameter("io_cursor", OracleType.Cursor);

ps1.Direction = ParameterDirection.Output;


OracleParameter[] param = { ps1 };

aDataSet = aDataBase.ExecuteDataSet("ReconcileHarmdm", param);

return aDataSet;

[wild_bill]

			DataSet ds1 = new DataSet();
			ds1.Tables.Add("Table1");
			DataSet ds2 = new DataSet();
			ds2.Tables.Add("Table2");

			ds1.Merge(ds2);
			Console.WriteLine(ds1.Tables.Count);

[bnathvbdotnet]

thank you wild bill.
nath

[mendhak]

Why not use both dataadapters to fill the same dataset, just different tables within it?