[RESOLVED] [2.0] Dataset question...

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;

Code:

---

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

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

---

thank you wild bill.
nath

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