What are different types of cursors in ADODB?
Answers were Sorted based on User's Feedback
Answer / venkatesh
we have four types of cursors in ADODB method
1.static
2.dynamic
3.keyset
4.Forward only
| Is This Answer Correct ? | 18 Yes | 1 No |
Answer / pranita
there are four cursors in ADODB
1.Forward only-allows to move forward only through a
recordset.
2.keyset-allows to move forward and backward through
recordset.reflects modifications and deletions done by
other users.
3.dynamic-allows to move through a recordset.reflects all
changes made by another user.
4.static-allows to move forward and backward through a
recordset.does not reflect any changes made by the other
users.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / hema
1.Dynamic Recordsets
- it allows viewing the result of add,modify &
deletion by other users.
2.Keyset Recordsets
- it same as Dynamic rs but prevents seeing of
changes by the other users.
3.Static Recordsets
- the static copy of a set of records to find data
or generate reports.
4.Forward-only
- it improve performance.it behaves identical to a
static recordset and allows forward-only
| Is This Answer Correct ? | 4 Yes | 3 No |
Answer / shri vardhan gupta
Cursor Type: Cursor can be various types:
Adopendynamic: The resultset reflects changes ,addition and deletion. Resultset can be navigated anyway.
Adopenforwardonly:The resultset reflects changes ,addition and deletions.can be navigated in forward direction only.
Adopenkeyset:The resultset reflects modifcations to data but not records addded by other users.
Adopenstatic:returns the static set of records cannot be modified.
| Is This Answer Correct ? | 0 Yes | 0 No |
Which property of textbox cannot be changed at runtime. What is the max size of textbox?
Explain Get, Let, Set Properties.
How to get freefile location in memory?
What is pivot table and how to create a pivot table
what is the Property used to count number of items in a combobox?
what are the Differenct Types of Procedures in VB?
What is the Advantage of ActiveX Dll over Active Exe?
What is the difference between Property Get, Set and Let.
Which ADO object is used to perform commit / rollback ? Is it command or connection or recordset I am not sure of the options given. So please let me know the answer if it is something else.
how a multiple routing works ?
What is disconnected recordset?
Difference between Tabletype and Snapshot?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)