一般式:
DataSet ds = new DataSet();
DataTable dt = new Datatable();
DataTable dt2 = new Datatable();
ds.Table.Add(dt,"table1");
ds.Table.Add(dt2,"table2");
資料庫方式:
using System.Data.OracleClient;
DataSet ds = new DataSet();
string sql = "select * from abc";
OracleDataAdapter da= new OracleDataAdapter(sql, conn);
da.Fill(ds, "table1");
string sql = "select * from abc2";
OleDbDataAdapter da= new OleDbDataAdapter(sql, conn);
da.Fill(ds, "table2");