Difference between Dataset and Datareader asp.net

In this blog we will discuss about difference between datareader and dataset in Ado.Net.

Also you can check out:

- How To Call a Button Click From Another Button in C#.Net?

- RangeValidator example in Asp.Net

- Bind dropdownlist from enum in Asp.Net

Dataset:
(1)-It is defined with multiple tables.

(2)-It is a disconnected architecture.

(3)-It can't be defined without DataAdapter.

(4)-Dataset is able to fetch record in bidirection.

(5)-Dataset having read/write acess.

(6)-It comes under disconnected architecture.

(7)-It is slower as compared to datareader.

Datareader:
(1)-It is a readonly and forward only data i.e Read-Only access.

(2)-You can access one table at a time .

(3)-It comes under connected architecture.

(4)-One of the most advantage is that it is much faster than dataadapter.

(5)-Using Datareader only one value can be accessed at a time from the database.

(6)-Here the data is retrieved based on the select statement .

(7)-We can't do DML operations through datareader.