Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Dataset and Recordset?
- 7 Answers
- 32993 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 are the different types of applications supported in .net (or) .net framework?
Explain nested classes?
What are the advantages of an assembly?
Explain an assembly?
What are the differences between c# and visual basic.net?
How can I extract the formated word(bold,italic,underline,font,color etc) from the msword file.?
Explain the difference between datatable and dataset?
What is the source code for display the picture in button click event?
What are the features of c# which are not present in vb.net?
What is option strict?
Can you please explain the difference between dataset and datareader?
What is the significance of delegates?
Why do we use byref keyword in vb.net?
How do you script this scenario in QTP using VB? Verify XML attributes in XML message against XSD and data mapping of fields to Oracle tables? Verify data in XML to data in a defined table?
What do you mean by serialization?
