What is the difference between Dataset and Recordset?

Answer Posted / sathiyapriya

The Recordset was not XML-based and could not be serialized
to XML easily or flexibly.
Finally, a Recordset was not independent of a data store
because it tracked a Connection object
and through its methods could send queries to the data
source to populate, update,
and refresh its data.
To that end, the Recordset contained functionality found in
the ADO.NET DataSet,
data reader, and data adapter objects.

Similar to the DataSet, a Recordset could be disconnected
from its data store
and therefore act as an in-memory cache of data.
Of course, it could also be used in a connected model
depending on the cursor options that were set.
Although the Recordset object stored multiple versions of
each column for each of its rows,
it was not by nature able to represent multiple tables
without the use of the Data Shape Provider.

Is This Answer Correct ?    11 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain option explicit?

767


Name some of the features present in vb 2005?

762


What is branching logic control in VB.NET?

741


Explain i.tostring method?

688


What are the features of c# which are not present in vb.net?

831


What is global assembly cache (gac)?

749


Explain about Visual basic.NET culture?

783


Described strong typing

741


What is sorting in vb?

671


What is the difference between manifest and metadata?

738


What is a stream in vb.net?

740


What are the advantages of an assembly?

827


Explain the differences between vb.net and c#, related to oops concepts?

712


What is the difference between convert.tostring and .tostring() method?

762


What is visual basic.net culture?

723