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 the difference between Datareader and Dataset?
What is oledb driver?
What are the usages of the command object in ado.net?
What are the benefits of ADO.NET?
What is dbcontext and dbset in entity framework?
What are the advantages of using datalist?
What is ado.net full form?
What is disconnected architecture in ado.net?
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?
Define partial class?
Which database is the ado.net sql connection object designed for?
What is meant by executenonquery?
What are the features of ado.net?
How does entity framework work?
How does ado.net work?