prssible bug in oleDbDataAdapter

  • Thread starter Thread starter Luigi
  • Start date Start date
L

Luigi

Hi,
I've written a Stored procedure that return 3 different tables. Something
like:
Select * from A;
Select * from B;
Select * from C;

But when I try to retrive the datas in a dataset,
only the first table is filled.
The code I use is like this

DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter(oleDbCommand);
da.tableMappings("Table", "A");
da.tableMappings("Table2", "B");
da.tableMappings("Table3", "C");
da.Fill(ds);

Did somebody had the same problem?

Tnahks
 
Does your database support batched queries? If you are using access (I
noticed the Oledb library) I don't think it does and that's probaby the
problem.
 
Back
Top