1 connection- 2 result tables

[Avon]

Hi there,

I am very sorry for my not perfect English.

I've got very simple question. Is it possible to have stored procedure with
2 result tables and then from my application to refer to this tables by ado.

Something likes that:

Select * from aaa

Select * from bbb

And then in my application

SqlDataAdapter adapter=new SqlDataAdapter();

DataSet MyDataSet=new DataSet();

adapter.Fill(MyDataSet, "aaa");

adapter.Fill(MyDataSet, "bbb");

Basically I want to receive with 1 connection to the database 2 tables.

If is possible haw I can do it,

And if is not possible is there any other way I can do it?

Thanks in advance

[Peter Rilling]

Yes.

You would then refer to it using syntax such as myDataset.Tables[0] or
myDataset.Tables[1].

The tables are just indexed in the table collection and can be accessed.

"Avon" <mi*********@yahoo.com> wrote in message
news:%2***************@TK2MSFTNGP10.phx.gbl...

Hi there,

I am very sorry for my not perfect English.

I've got very simple question. Is it possible to have stored procedure
with 2 result tables and then from my application to refer to this tables
by ado.

Something likes that:

Select * from aaa

Select * from bbb

And then in my application

SqlDataAdapter adapter=new SqlDataAdapter();

DataSet MyDataSet=new DataSet();

adapter.Fill(MyDataSet, "aaa");

adapter.Fill(MyDataSet, "bbb");

Basically I want to receive with 1 connection to the database 2 tables.

If is possible haw I can do it,

And if is not possible is there any other way I can do it?

Thanks in advance

[Venkat_KL]

Hello Dear Avon,

Yes You can have a stored procedure with 2 SQL Select Statement.
I will show you how you can also retreive 2 SQL Select Statements in one
single Query.

It goes like this.

Create a connection string

const string dsn="server=(local);trusted_connection=yes;databas e=pubs";

Using(SqlConnection conn = new SqlConnection(dsn);

Using(SqlCommand cmd = new SqlCommand(SELECT * FROM Authors;SELECT * FROM
Publishers", conn));

//here you can give two (2) SQL Statements with a semicolon (;) in-between
like above.

SqlDataReader dr = cmd.ExecuteReader();
do
{
while (dr.read())
{
Console.Writeline(" {0} {1}", dr[1], dr[2]);
}

}while(reader.NextResult[1])
}

************************************************** ************************************************** ********************

You can also fill the DataSet with 2 Tables like below

Create a connection string

const string dsn="server=(local);trusted_connection=yes;databas e=pubs";

Using(SqlConnection conn = new SqlConnection(dsn);

SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Authors;SELECT * FROM
Publishers", conn);
then you can fill the DataSet like this
=======================
DataSet ds = new DataSet();

da.Fill(ds,"Authors");

//The Table Name "Authors" is assigned to the First (1st) DataTable. You
have to Specifically Assign the Table Name for the Second (2nd) DataTable
like below

ds.Tables[1].TableName="Publishers"

you can user the DataTable by refereing either their Ordinal Number or Name
of the Table like below

ds.Tables["Authors"]
or
ds.Tables[0]

AND / OR

ds.Tables["Publishers"]
or
ds.Tables[1]

For anything and everything please let me know

bye
Venkat_KL

[Venkat_KL]

Hi dear Avon,

you can also read these two pages by clicking the respective URLs

Inserting relational data using DataSet and DataAdapter
====================================

http://www.codeproject.com/cs/databa...&select=937255
DataSet Class
=========
http://msdn.microsoft.com/library/de...classtopic.asp

bye
Venkat_KL

[Avon]

Thanks a lot friends!

"Avon" <mi*********@yahoo.com> wrote in message
news:%2***************@TK2MSFTNGP10.phx.gbl...

Hi there,

I am very sorry for my not perfect English.

I've got very simple question. Is it possible to have stored procedure
with 2 result tables and then from my application to refer to this tables
by ado.

Something likes that:

Select * from aaa

Select * from bbb

And then in my application

SqlDataAdapter adapter=new SqlDataAdapter();

DataSet MyDataSet=new DataSet();

adapter.Fill(MyDataSet, "aaa");

adapter.Fill(MyDataSet, "bbb");

Basically I want to receive with 1 connection to the database 2 tables.

If is possible haw I can do it,

And if is not possible is there any other way I can do it?

Thanks in advance