Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Dataset and Recordset?
- 7 Answers
- 33606 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 internal keyword in .net framework?
Name a feature which is common to all .net languages?
Explain option explicit?
Tell me which namespace are used for accessing the data?
What is the difference between a "jagged array" and multidimensional array" ?can anyone show me it practically ?
Define clr?
What is break mode? What are the options to step through code?
Which is the tool which can convert visual basic old version to .net compatibility version?
What is the significance of delegates. Where should they be used?
Why should you use delegate?
What is branching logic control in VB.NET?
how many server control present in .net
What’s the difference between private and shared assembly?
Which is the base class for all the classes in .net framework?
Tell me how many .net languages can a single .net dll contain?
