What is the difference between Dataset and Recordset?
Answer Posted / haynes r. rajwadi
With Recordset comes the Recordset pointer, that points to
the relative data so retrieved from the database. The
Recordset object has MoveNext, MoveFirst, MovePrevious and
MoveLast methods that provides a means for Data Traversal
With DataSet there is no pointer that points to the record,
while a Bulk of Data is retrieved from the Database to the
Computer's Memory, and the record is accessed via the index
of the Record so retrieved.
With Recordset, has types of Cursors ie. Open Cursor and
Data Manipulation Cursor, which enables the cursor to be
open as read-only or dynamic (meaning for data
manipulations)
With Dataset as bulk of data is loaded to the Memory, only
Viewing operation is possible.
With Recordset, if the cursor is open as OpenDynamic and
OpenOptimistic, the Data manipulated by 1 user, its effect
is visible to the other user, leading to clear picture of
the Database, while this is not the case in DataSet.
DataSet can be viewed as a ONE WAY HIGHWAY, where the data
comes from Database to the Computer's Memory.
RecordSet can be viewed as a TWO WAY HIGHWAY, based on and
according to the Cursor type selected in the recordset
| Is This Answer Correct ? | 16 Yes | 9 No |
Post New Answer View All Answers
Explain the services provided by common language infrastructure.
What is early binding?
Described strong typing
What is datatype conversion?
Explain the difference between import system.data.sqlclient and system.data.oledb?
Define serialization in .net?
What are jagged arrays ?
What are the two main parts of .net?
Explain nested classes?
what is interface and when it is used?
Which is the tool which can convert visual basic old version to .net compatibility version?
What is redim keyword and its use?
How to store decimal data in .net?
Explain the difference between vb.net and c#, related to oops concepts?
What is the difference between datagrid and gridview?