can we have multiple datatables in a datareader ?
Answers were Sorted based on User's Feedback
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;
Is This Answer Correct ? | 47 Yes | 1 No |
Answer / satya
Yes. We can have multiple data tables in a datareader. You
can read the reuslt with datareader.NextResult method.
Is This Answer Correct ? | 46 Yes | 8 No |
Answer / satya
we can not have multiple dataTables in a datareader but we can
have multiple reuslt Sets in a datareader.
Is This Answer Correct ? | 17 Yes | 7 No |
Answer / ratnam
Yes. We can have multiple data tables in a datareader. You
can read the reuslt with datareader.NextResult method.
Is This Answer Correct ? | 11 Yes | 2 No |
Answer / mayank jain
Yes we can have...
for that datareader have "NextResult" method. by using we
can use the multiple table.
Is This Answer Correct ? | 7 Yes | 1 No |
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.
Is This Answer Correct ? | 6 Yes | 0 No |
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?
Is This Answer Correct ? | 12 Yes | 8 No |
Answer / rajesh n s
No multiple datables but multiple tableS from database with
query statement.
Is This Answer Correct ? | 5 Yes | 1 No |
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.
Is This Answer Correct ? | 0 Yes | 0 No |
How do you implement locking concept for dataset?
How to find the given query is optimised one or not?
What is the meaning of object pooling?
What are the steps you will take to improve performance?
What are the advantages and drawbacks of using ado.net?
What is ODP.NET?
Which is faster dataset or datareader?
Describe briefly an ADO.NET Dataset ?
What are the pre-requisites for connection pooling?
Is ado.net an orm?
What are the key features of ado.net?
Explain all the classes those are used for database connections between sql server and asp.net?