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 |
in vb6.0 can we use function keys (F1 to F12) in form_keypress event in a form which contains commandbutton (s) control? if yes, then explain me how it is possible. Thanks.
What is dao in vba?
Name some date functions?
What is Zorder Method?
Explain about control properties?
What's the difference between MODAL and MODELESS forms?
reading lines from a file by searching a word(instr) and copying to other textfile,but its only copying only one line but there are some other lines match criteria but not copying to the files
CONNECTIVITY OF SQL 2000 + VB USING ODBC. steps i Follow- 1) Go to Control panel-->Admintrative Tools-->Double -click Data sources(ODBC)-->click Add button-->I choose SQL server (last option), Is it right or wrong option for connecting to SQL 2000.Then a new screen appears Create a New dataSource-->in name textbox,we can write anyname--Right or wrong. suppose i enter sonia, & my server name is .,so I enter . in server & click next button-->On the Next screen i have checked the option With Sql server authentication-- >Login Id-sa, Password-->Blank-->Click next button-->Next-- >Finish-->Then I click on button Test Data source-->Mesage Comes TESTS COMPLETED SUCCESSFULLY-->OK-->OK-->Ok. These steps we have to do or not for Connectivity using ODBC. If yes,then what after these steps we have to do??Plz reply me early ??Thx in advance.
What is the size of the variant data type?
How do you change the system menu (on the Control-Menu Box)?
To.set the command button for ESC ___ Property has to be changed.
how many no of controls in form?
16 Answers AIMS, Airex Logistics,
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)