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 |
Data Control missing from toolbox when I use VB under NT3.5. Why?
what are the Types of Resultsets?
What do you mean by ADO?
How can you filter out specific type of file using file system controls?
What is the difference between a Dynaset and Snapshot and how would you create one?
Is the Access Engine and Visual Basic Pro good enough for database work?
what is the Difference between listbox and combo box?
How would you create properties by using class Builder Wizard?
How would you access objects created in ActiveX Exe and ActiveX D1T ?
How to register a component?
To.set the command button for ESC ___ Property has to be changed.
How would you navigate between one document to another document in Internet Explorer ?
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)