Thread: Differences between Dataset and Data Reader

Dataset is in memory representation of the Database. It permits us to work in Connection less environment.

Data reader is like forward only read-only cursor, which is used to get back data. Data manipulation is not possible while using datareader. datareader always keeps the connection open.

Dataset

• Dataset can be used when the connection is closed.

• Dataset can be used to modify or delete or insert data in the database.

• A dataset can allow you access the info on any order at any time.

Data Reader

• Data reader requires the connection open to be used.

• Data reader can be used only to read data

• Data reader allows you access the info only one time per item and only in a sequential order.