Difference between datareader and dataset?
Answer Posted / chitaranjan mallick
- Data Reader apply only Select Statement, It can featch data from multiple Table Through Multiple Select Statement separated by Semicolon(;) Likes For Ex:
SqlCommand cmd=new SqlCommand("Select * from Emp";" Select * From Dept",Con);
DataReader dr=cmd.ExecuteReader();
dr.NextResults();
Here NextResults() Navigate from One Tables to Anather Tables
- It is Readonly, It can featch single Record At a Time..
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What DataReader class do in ADO.NET ?
What is the use of SqlCommand object?
What does datareader object do?
What is aggregate root?
How to check if a datareader is closed or opened? IsClosed()
What is variable view?
How to bind the controls(best practice) comboboxes to the data in the dataset?
What provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?
How does entity framework work?
What does executenonquery () method return?
What is ado.net code?
What is bubbled event?
What are the several execute methods of ado.net?
Explain how to call the sql commands asynchronously in ado.net version 2.0?
What is the DataTableCollection?