Suresh Kumar
Can you explain the difference between an ADO.NET Dataset and an ADO Recordset?
By Suresh Kumar in ASP.NET on Nov 04 2017
  • Suresh Kumar
    Nov, 2017 4

    • A DataSet can represent an entire relational database in memory, complete with tables, relations, and views. • A DataSet is designed to work without any continuing onnection to the original data source. • Data in a DataSet is bulk-loaded, rather than being loaded on demand. • There's no concept of cursor types in a DataSet. • DataSets have no current record pointer You can use For Each loops to move through the data. • You can store many edits in a DataSet, and write them to the original data source in a single operation. • Though the DataSet is universal, other objects in ADO.NET come in different versions for different data sources.

    • 1
  • Laxmidhar Sahoo
    Nov, 2017 28

    Dataset is a connectionless data holder whereas RecordSet is connection oriented Data holder.when Dataset has read write option the recoerdset has only read option

    • 0
  • Laxmidhar Sahoo
    Nov, 2017 28

    Dataset is a connectionless data holder whereas RecordSet is connection oriented Data holder.when Dataset has read write option the recoerdset has only read option

    • 0