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 |
Wat is multithreading in VB?
How do you do multithreading application in VB
Explain the types of Views in Listview Control.
How should dates be implemented so they work with other language and country formats?
What is the difference between Single and Double in VB?
Why API functions are Required?
What is the latest version of visual basic?
What is Seek Method which type of record set is available this?
how many no of controls in form?
1 Answers Airex Logistics, Tata Logistics,
How do I call a DLL?
what is the Default property of datacontrol ?
How do I use GetPrivateProfileString to read from INI files?
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)