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
What do you mean by serialization and deserialization?
What is the purpose of objects present in asp.net?
Explain global assembly cache (gac)?
What is jagged array in vb.net?
What are the advantages of migrating to vb.net?
What is the difference between manifest and metadata?
Explain the differences between vb.net and c#, related to oops concepts?
Is it necessary to have SQL server installed in your computer in order to create a service based database in vb.net?
Explain the difference between vb.net and c#, related to oops concepts?
Explain enumerator?
How to run a dos command in vb.net?
What is a static class?
Why do you need Lock in Visual Basic?
Explain the difference between c# and vb.net?
Explain the difference between import system.data.sqlclient and system.data.oledb?