WHAT IS DIFFERENCE BETWEEN DATASET AND DATAREADER?

Sumit Kesarwani

Total Post:782

Points:3910
Posted by  Sumit Kesarwani
C# 
C#
 1422  View(s)
Ratings:
Rate this:
  1. Sumit Kesarwani

    Post:782

    Points:3910
    What is difference between dataset and datareader?

    DataReader provides forward-only and read-only access to data, while the DataSet object can hold more than one table (in other words more than one rowset) from the same data source as well as the relationships between them.

    Dataset is a disconnected architecture while datareader is connected architecture.

    Dataset can persist contents while datareader can not persist contents, they are forward only.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!