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 is connection pooling and what is the maximum pool size in ado.net connection string?
Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?
Why is it important to close an ado.net application?
What is the difference between Data adaptor and Data set?
How can we perform transactions in .net?
What are the parameters that control most of connection pooling behaviors?
Explain the differences between oledb sql server, oledbdotnet provider?
How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?
Does dapper use ado.net?
Why is stored procedure used in ado.net?
What is the default Timeout for SqlCommand.CommandTimeout property?
What is serialization and de-serialization in .net? How can we serialize the dataset object?
What is difference between datatable and dataset?
What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?
What are the differences between OLEDB and SQLClient Providers?