Interested to Buy Any Domain ? << Click Here >> for more details...
can we have multiple datatables in a datareader ?
- 18 Answers
- 38600 Views
- Fulcrum Logic, Infosys, Kale Consultants, Ness Technologies, I also Faced
- E-Mail Answers
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 essential features of ado.net?
What are the different ado.net namespaces?
What is shadow copy?
How can you add or remove rows from the datatable object of dataset?
How can we check that some changes have been made to dataset since it was loaded?
What are the ado.net objects?
Explian About DataAdapters
How to generate XML from a dataset and vice versa?
What is DataReader Object?
make a login control??
What is sqlconnection and sqlcommand?
What is difference between executequery and executeupdate?
-
Visual Basic (800) - C Sharp (3816)
- ASP.NET (3180)
- VB.NET (461)
- COM+ (79)
- ADO.NET (717)
- IIS (369)
- MTS (11)
- Crystal Reports (81)
- BizTalk (89)
- Dot Net (2435)
- Exchange Server (362)
- SharePoint (720)
- WCF (340)
- MS Office Microsoft (6963)
- LINQ Language-Integrated Query (317)
- WPF (371)
- TypeScript (144)
- Microsoft Related AllOther (311)
