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 |
___,_____ and ____ container objects. ___ Property is to compress a image in image control. ___,___ and __ are difference between image and picture controls. To set the command button for ESC ___ Property has to be changed. ___,__,___ are the type of combo box? __ no of controls in form. OLE is used for _______ ___ is the control used to call a windows application. Clear property is available in ____,___ control. ___ Property is used to count no. of items in a combobox. ___ is a property to resize a label control according to your caption. ___ property is used to change to ___ value to access a identity column'in datacontrols. _____ is the property to ___,____,____ are valid for recordsource property of dat control. Timer control contains ________ no. of events. ____ property is used to lock a textbox to enter a datas. ____ is the difference between Listindex and Tab index. ____ property of menu cannot be set at run time. _____ collection in recordset used to assign a value from textbox to table columns without making abinding in datacontrol. ___ argument can be used to make a menuitem into bold. ___,___ arguments will be used to run a executable program in shell function ___ property used to add a menus at runtime. ___ VB constant make the menu item in centre. ___ method used to move a recordset pointer in nth position in DAG.
how a multiple routing works ?
How would you attach pictures in column headers of List View Control?
What is the difference in passing values ByRef or ByVal to a procedure?
How would you use ActiveX Dll and ActiveX Exe in your application?
Can you tell me the properties of the controls?
What are properties available in Clip Board?
How would you create Visual basic Document file?
Parts of ODBC?
WHAT IS DIFFERENCE BETWEEN Message box and image box
What is the max size of textbox?
What is snapshot in vb?
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)