Re: Multiple Result Sets in a DataSet from DataAdapter ?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,

DataAdapter.Fill will do it for you

From MSDN:
When handling batch SQL statements that return multiple results, the
implementation of FillSchema for the .NET Framework Data Provider for OLE DB
retrieves schema information for only the first result. To retrieve schema
information for multiple results, use Fill with the MissingSchemaAction set
to AddWithKey.

So it will create one table per resultset


--
Ignacio Machin
machin AT laceupsolutions.com



"Liz" <liz@xxxxxxxxxxxxxxx> wrote in message
news:e8ZEikZ7GHA.2380@xxxxxxxxxxxxxxxxxxxxxxx

Anyone have any info on how you can fill a DataSet with mutiple result
sets
from a SQL batch ? I know with a dataReader you can use the nextResult
method but I'm lost on how you do this with a dataAdapter ....

TIA ..

L




.