Code: Select all
Select * From Table1; Select * From Table2; Select * From Table3;
is there any possibility in DevArt?
regards,
Anand
Code: Select all
Select * From Table1; Select * From Table2; Select * From Table3;
Code: Select all
static void Main(string[] args)
{
OracleConnection conn = new OracleConnection("your connection string");
conn.Open();
OracleScript script = new OracleScript("Select * From Table1; Select * From Table2; Select * From Table3;", conn);
OracleDataReader reader;
OracleDataSet ds = new OracleDataSet();
while(script.ExecuteNext(out reader))
{
var dt = ds.Tables.Add();
dt.Load(reader);
}
conn.Close();
}