What is difference between datagrid and flexgrid?
Datagrid – Editable. Flexigrid – Non-Editable. (Generally used for Read only purpose.) Read more »
‘Visual Basic Interview Questions’ - KyaPoocha.com
What is ADO? What are its objects ?
ActiveX Data Object. ADO can access data from both flat files as well as the databases. I.e., It is encapsulation of DAO, RDO, and OLE that is why we call it as... Read more »
What is Dataware Control?
Any control bound to Data Control. Ex:- Textbox, Check Box, Picture Box, Image Control, Label, List box, Combo Box, DB Combo, Read more »
What are the locks available in Visual Basic?
Locking is the process by which a DBMS restricts access to a row in a multi-user environment. 4 types of locks. They are 1.Batch Optimistic 2.Optimistic 3.Pessimistic 4.Read... Read more »
What is the diff between RDO and ADO?
RDO is Hierarchy model where as ADO is Object model. ADO can access data from both flat files as well as the data bases. I.e., It is encapsulation of DAO, RDO, OLE... Read more »
How can we call Stored procedure of Back End in RDO and ADO ?
In RDO – We can call using RDO Query Objects. In ADO – We can call using Command Objects. Read more »
What is the different between Microsoft ODBC Driver and Oracle OBDC Driver?
Microsoft ODBC driver will support all the methods and properties of Visual Basic. Where as the Oracle not. Read more »
What are the Technologies for Accessing Database from Visual Basic?
DAO, Data Control, RDO, ODBCDIRECT, ADO, ODBC API. Read more »
Calling Stored Procedures in VB?
Calling Simply the Procedure with out Arguments “Call ProcedureName}” If it is with Arguments Means then Declare the Query Def qy Set Qy as New Query def Qy.SQL... Read more »
What is Seek Method which type of record set is available this?
Only in DbOpenTables. Syntax: rs.index = “empno” rs.seek “=” , 10 If with our setting the rs.index then run time error will occur. Read more »
What is Centralization Error Handling?
Writing funciton and calling it when error occurs. Handling Error in Calling chain. This will call the top most error where the error is handled. Read more »
How to trap Data Base Error?
Dim x as RDOError X(0).Des X(1).Number Read more »
What is view Port?
The area under which the container provides the view of the ActiveX Document is known as a view port. Read more »
What methods are used for DBGrid in unbound mode?
AddData, EditData, Readdata, WriteData. Read more »
What are the record set types?
RdOpenFowardOnly 0 (Default used only for the read only purpose) RdOpenStatic 1 RdOpenDynamic 2 RdOpenKeySet 3 (Normally used for the live project) Read more »
Different types of Lock Types?
RdConcurReadOnly 0 (Default) RdConcurLock 1 (Pessimistic Locking) RdConcurRowver 2 (Optimistic Lociking) RdConcurValues 3 RdConcurBatch 4 Read more »
What are the RDO Methods and Events?
Methods Events Begin Trans Validate Commit Trans Reposition Rollback Trans Error Cancel Query Complied Refresh Update Controls Read more »