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 |
What are the parameters that control most of connection pooling behaviours?
What is ado object model?
How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?
0 Answers SwanSoft Technologies,
What is the difference between statement and preparedstatement interface?
What is ODP.NET ?
What is meant by entity framework?
can u tell me the why ADO does not support xml..
When multiple users attempt to modify data at the same time Ex user 1 is updating record at same time user2 deleted record sucessfully.now user1 has press update button . how to handle concurrency
Which object of ado contains datarow datacolumn collection?
What are the benefits of using ado.net?
How to retrieve the third table value from the data set?
What is a sqldataadapter?