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 is the difference between a Dataset and DataReader? Can dataReader hold data from multiple tables?

3 Answers   Fulcrum Logic, Merrill Lynch,

What are dcl commands?

0 Answers  

What is dataset object? Explain the various objects in dataset.

0 Answers  

What is csdl entity framework?

0 Answers  

what is a dataset?

9 Answers   Choice Solutions,

How can you implement sub data grid in a master datagrid?

1 Answers  

how to add a selected row of a gridview to another gridview without reloading the page??

2 Answers  

What is difference between datareader and dataadapter?

0 Answers  

What are all the different methods under sqlcommand?

0 Answers  

What is the difference between dataset and datatable?

0 Answers  

What are different layers of ADO.Net?

0 Answers  

How to you declare connection strings and how to you make use of web.config ?

3 Answers   MMTS,