Wednesday, April 29, 2009

Diffrence between Data Reader, Dataset and Data Adapter

Difference  Angle

Data Reader

Dataset

Data Adapter

Disconnected mode

Connected mode

Disconnected mode

Disconnected mode

Forward Only

Yes

No

No

Read/Write

Read Only

Read/Write

Read/Write

Handling

Database Table

Can handle text file, XML file and Database table

Can handle text file, XML file and Database table

Storage Capacity

No storage

Temporary Storage Capacity

Temporary Storage Capacity

Accessibility

Can access one table at a time

Multiple table at a time

Multiple table at a time

Faster

Much faster than dataset

Less faster than data reader

Less faster than data reader

No comments:

Post a Comment