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 |
Is VB comes under Object Oriented Programming ?
What is the current version of Visual Basic for Windows?
How do I dial a phone number without using the MSCOMM VBX?
Is it posible to Create Tables Through Querydef?
What is the difference between c++ and visual basic?
Which method is preferred to save datas like database?
What are the types of line styles available in Treeview Control?
Name the four different cursor and locking types in ADO ?
What is the Dll required for running the VB?
Explain the differences between ActiveX Dll and ActiveX Exe?
Dim x, y as integer. What is x and y data type?
Can Redim be used to declare a new array ?
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)