dataset, datatable, dataadapter

[DaveP]

is it possible to send one command and return multiple record sets
instead of creating 3 separate command objects
and executing them independently

Tia
DaveP

 

[Arnshea]

is it possible to send one command and return multiple record sets
instead of creating 3 separate command objects
and executing them independently

Tia
DaveP

Yep. Make the command a transact sql batch. You can move to the next
resultset with the DataReader.NextResult() method (assuming you're
using the SqlClient).

 

[Arnshea]

is it possible to send one command and return multiple record sets
instead of creating 3 separate command objects
and executing them independently

Tia
DaveP

If you were connecting to the sample pubs database, you could return 2
resultsets w/ the following:

SqlCommand cmd = conn.CreateCommand();

cmd.CommandText = @"BEGIN
select * from authors
select * from titles
END";

try
{
conn.Open();

SqlDataReader rdr = cmd.ExecuteReader();

while ( rdr.Read() )
Console.WriteLine("author={0} {1}", rdr["au_fname"],
rdr["au_lname"]);

rdr.NextResult();

while ( rdr.Read() )
Console.WriteLine("title={0}", rdr["title"]);

rdr.Close();
}
catch
{ // do whatever here....
}
finally
{
conn.Close();
}

 

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

Hi,

is it possible to send one command and return multiple record sets
instead of creating 3 separate command objects
and executing them independently

Yes, just put more than one SELECT statement in the query

 

[DaveP]

thanks for the Sample

is it possible to send one command and return multiple record sets
instead of creating 3 separate command objects
and executing them independently

Tia
DaveP

If you were connecting to the sample pubs database, you could return 2
resultsets w/ the following:

SqlCommand cmd = conn.CreateCommand();

cmd.CommandText = @"BEGIN
select * from authors
select * from titles
END";

try
{
conn.Open();

SqlDataReader rdr = cmd.ExecuteReader();

while ( rdr.Read() )
Console.WriteLine("author={0} {1}", rdr["au_fname"],
rdr["au_lname"]);

rdr.NextResult();

while ( rdr.Read() )
Console.WriteLine("title={0}", rdr["title"]);

rdr.Close();
}
catch
{ // do whatever here....
}
finally
{
conn.Close();
}