Powered by Blogger.

Thursday, September 26, 2013

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

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

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