What is the difference between Dataset and Recordset?
- 7 Answers
- 31792 Views
- IG, Silicon, I also Faced
- E-Mail Answers
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
What is the difference between static or dynamic assemblies?
What is the Advantage of vb.net over vb
List the types of authentication?
Name the class which allows an element to be accessed using unique key?
What is the feature which is common to all .net languages?
What are the technology areas that microsoft.net contains?
Tell us how many languages are supported by .net?
What is the difference between a "jagged array" and multidimensional array" ?can anyone show me it practically ?
Explain the difference between namespace and assembly?
What do you mean by Redim in VB.NET?
Name and explain some of the exclusive features which are present in vb?
What is an arraylist?
What are the differences between c# and visual basic.net?
Explain redim keyword?
What is the feature anonymous type?
