Answer / vrsanaidu

Yes, we can have multiple result set means multiple
datatable data in one datareader..., code as below

SqlConnection con = new
SqlConnection(ConfigurationSettings.AppSettings["con"]);
SqlCommand cmd = new SqlCommand("SELECT SiteName FROM
Sites;SELECT SiteCode FROM Sites", con);
cmd.Connection.Open();
SqlDataReader r = cmd.ExecuteReader();
do {
while(r.Read()) {
Response.Write(r.GetString(0) + "<br>");
}
} while (r.NextResult());


r.Close();
con.Close();
cmd = null;
r = null;
con = null;

Answer / satya

Yes. We can have multiple data tables in a datareader. You
can read the reuslt with datareader.NextResult method.

Answer / satya

we can not have multiple dataTables in a datareader but we can
have multiple reuslt Sets in a datareader.

Answer / ratnam

Yes. We can have multiple data tables in a datareader. You
can read the reuslt with datareader.NextResult method.

Answer / mayank jain

Yes we can have...
for that datareader have "NextResult" method. by using we
can use the multiple table.

Answer / sridhar para

we can not have multiple dataTables in a datareader but we
can have multiple reuslt Sets in a datareader.

We can have multiple dataTables in a dataset.

Answer / eduardo belmonte

Some people get confused.

A datareader can not have any amount of datatables.
Not even one of them.

Datatables exist by themmselves or inside a dataset, but
they are not generated nor filled by a datareader.

A datareader generates "only datarows", it doesn't generate
datatables. Each one of the datarows comply with a
structure as defined by the SELECT sql statement.

That SELECT statement may have columns that belong to one
or more "tables in the database". By example using a JOIN
or something similar. But listen well I said "tables" not
"datatables".

OK my friends?

Answer / rajesh n s

No multiple datables but multiple tableS from database with
query statement.

Answer / vivek

we can not have multiple databases in datareader

Answer / yuri

The question itself is incorrect. A data reader is a stream
of data, while a data table is a fixed structure. Having
said that, a data reader has one or more schema tables which
are of type DataTable. I suppose the correct question would
be: "can one data reader read from multiple SELECT
statements" and the answer to that question is YES.

What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?

0 Answers  

How can I retrieve two tables of data at a time by using data reader?

0 Answers  

What is microsoft ado.net?

0 Answers  

If we want to connect to many databases in dataaccess layer such as MSAccess,Sql server,oracle means not to a particular database depends on condition we have to connect to appropriate database in this scenario if we without changing code Ho wdo you handle this situation?

4 Answers   Honeywell,

Define data adapter?

0 Answers  

What is Pooling? what is data pooling? what is sql pooling?

3 Answers   TCS,

What is executequery?

0 Answers  

What is datasource in ado.net?

0 Answers  

What two types of data providers does ADO.NET supply? What determines which one you should use?

0 Answers   CDC,

Which object of ado contains datarow datacolumn collection?

0 Answers  

What is connected architecture in ado.net?

0 Answers  

Can we do database operations without using any of the ado.net objects?

0 Answers