Multiple Result Sets in a DataSet from DataAdapter ?

[Liz]

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

[Deepak Khanal]

You may want to do something like this in C# 2.0:

DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter( "select * from authors;
select * from employee",

ConfigurationMa nager.Connectio nStrings["pubsConnection String"].ConnectionStri ng);
sda.Fill(ds);

gvAuthors.DataS ource = ds.Tables[0]; //gvAuthors = GridView
control
gvAuthors.DataB ind();

gvEmployees.Dat aSource = ds.Tables[1]; //gvEmployees = another
GridView control
gvEmployees.Dat aBind();


On Oct 11, 7:56 pm, "Liz" <l...@tiredofsp am.comwrote:

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

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

DataAdapter.Fil l 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 MissingSchemaAc tion set
to AddWithKey.

So it will create one table per resultset
--
Ignacio Machin
machin AT laceupsolutions .com

"Liz" <li*@tiredofspa m.comwrote in message
news:e8******** ******@TK2MSFTN GP02.phx.gbl...

>
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

[Liz]

"Deepak Khanal" <dk*****@gmail. comwrote in message
news:11******** **************@ h48g2000cwc.goo glegroups.com.. .

You may want to do something like this in C# 2.0:

DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter( "select * from authors;
select * from employee",

ConfigurationMa nager.Connectio nStrings["pubsConnection String"].ConnectionStri ng);
sda.Fill(ds);

gvAuthors.DataS ource = ds.Tables[0]; //gvAuthors = GridView
control
gvAuthors.DataB ind();

gvEmployees.Dat aSource = ds.Tables[1]; //gvEmployees = another
GridView control
gvEmployees.Dat aBind();

so simple ... don't know why I didn't try that ... thanks ....

Liz

[Liz]

"Ignacio Machin ( .NET/ C# MVP )" <machin TA laceupsolutions .comwrote in
message news:eX******** ******@TK2MSFTN GP03.phx.gbl...

Hi,

DataAdapter.Fil l 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 MissingSchemaAc tion

set

to AddWithKey.

ok ... I'm still finding my way around with this stuff ... what's the
significance of this part of the picture ?

Liz