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


Please Help Members By Posting Answers For Below Questions

What is the difference between Datareader and Dataset?

786


What is oledb driver?

722


What are the usages of the command object in ado.net?

785


What are the benefits of ADO.NET?

874


What is dbcontext and dbset in entity framework?

703


What are the advantages of using datalist?

732


What is ado.net full form?

767


What is disconnected architecture in ado.net?

748


What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?

792


Define partial class?

751


Which database is the ado.net sql connection object designed for?

836


What is meant by executenonquery?

739


What are the features of ado.net?

722


How does entity framework work?

677


How does ado.net work?

698