Name the four different cursor and locking types in ADO ?
Answer / guest
CURSORS::
*********
The cursor types are listed from least to most resource
intensive.
Forward Only - Fastest, can only move forward in recordset
Static - Can move to any record in the recordset. Data is
static and never changes.
KeySet - Changes are detectable, records that are deleted
by other users are unavailable, and records created by
other users are not detected
Dynamic - All changes are visible.
LOCKING TYPES::
****************
LockPessimistic - Locks the row once after any edits occur.
LockOptimistic - Locks the row only when Update is called.
LockBatchOptimistic - Allows Batch Updates.
LockReadOnly - Read only. Cannot alter the data.
| Is This Answer Correct ? | 11 Yes | 0 No |
What is the difference between procedure and functions in VB?
What is Static Cursor?
Parts of ODBC?
What is constructors and distructors.
Is the Variant type slower than using other variable types?
What are forms in visual basic?
what are Instancing for classes provided by ActiveX component like prive, publicnotcreatable,SingleUse, GlobalSinleUse,MultiUse.
Can We create CGI scripts in VB?
what are the types of Recordsets?
It possible to call OLEDB?s Features directly in VB without using any control?
Can you create a Updatecascade, Deletecascade relation in Ms- Access?
What are the different types of Dialog Box?
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)