What are the different cursor types that can we create
using ADO Recordset?
Difference between these cursor types?
Answer Posted / pratik
•A Static Cursor doesn't reflect data changes made to the DB once the ResultSet has been created whereas a Dynamic Cursor reflects the changes as and when they happen.
•A Static Cursor is much more performant than a Dynamic Cursor as it doesn't require further interaction with the DB server.
•A static cursor supports both Relative and Absolute Positioning whereas a Dynamic Cursor supports only Relative Positioning.
•A Static Cursor can be used for Bookmarking purposes as the data returned is static whereas a Dynamic Cursor can't be used for the same
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
which property of menu cannot be set at run time.
What is the-use of property page Wizard in ActiveX Control?
Is it possible to Access BackEnd procedures? Explain.
What is the use of ActiveX Documents?
Write the Steps in Creating an ActiveX Control?
How would you add column headers in listview control?
Give brief description about class?
Types of LockEdits in RDO.
How can you save and Get data from Clipboard/ Recordset object consists what?
Why does everybody say I should save in TEXT not BINARY?
Explain about the basic features of Visual basic?
Difference between DDE and OLE.
Types of cursors in DAO?
What is ado in vb.net?
How would you add elements and pictures to listitems in listview control?