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
How can we store decimal data in .net?
What do you mean by serialization?
What do you mean by option strict on?
Explain some of the exclusive features which are present in vb?
Using VB, how can you change the Mouse Pointer?
How vb implements the disconnected architecture as like vb.net?
Tell me which namespace are used for accessing the data?
What are the assembly entry points?
what is the need for dynamic controls in vb.net? i would like to know for what purpose should we create the controls dynamically? please give the answer in simple words.
i am attending to US consulate i kept my projects on vb.net ,please help me what questions will be ask on vb.net in us consulate
Write the role of new keyword?
What are the features present in vb 2005?
What are jagged arrays ?
Explain private assembly?
Can you please explain the difference between namespace and assembly?