Difference between datareader and dataset?
Answer Posted / ankur
data reader is connection oriented.it can access only one
value from the database.but the advantage is that it is
faster that dataset operation.
dataset is disconnected.using dataset you can access any
number of values. it can't be used without data adapter.
dataset can contain any number of tables and it maintain
the relationship between tables. when you refesh the
dataset then the changes affect the database
Is This Answer Correct ? | 16 Yes | 16 No |
Post New Answer View All Answers
What is ole2 format?
How to perform sorting on a table in ADO.NET?
Define Execute Reader?
Can datareader hold data from multiple tables?
What is bubbled event can you please explain?
What is the difference between SqlCommand and SqlCommandBuilder?
What is commandbuilder in ado.net?
If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?
What is ado.net objects?
Can we connect two dataadapters to same data source using single connection at same time?
What are the steps you will take to improve performance? Will you use dataset or datareader?
What is difference between executequery and executeupdate?
What is disconnected architecture in ado.net?
Which method is used to sort the data in ADO.Net?
How to bind the controls(best practice) comboboxes to the data in the dataset?