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.
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.