21⟩ Under the ADO Command Object, what collection is responsible for input to stored procedures?
The Parameters collection.
Visual Basic (VB)
Home Computer Programming Visual Basic (VB)
“Visual Basic Interview Questions and Answers will guide you that Visual Basic (VB) is the third-generation event-driven programming language and integrated development environment (IDE) from Microsoft for its COM programming model. By browsing our Visual Basic Interview Questions and Answers you will learn that VB is also considered a relatively easy to learn and use programming language. This VB interview questions and answers guide will make Visual Basic more easy to learn for every one.”
102 Visual Basic (VB) Questions And Answers
22⟩ What are the ADO objects?
Provide a scenario using three of them to return data from a database. Expected answer: Connection Connects to a data source; contains the Errors collectionCommand Executes commands to the data source. Is the only object that can accept parameters for a stored procedure.Recordset The set of data returned from the database.Scenario: There are many possibilities. The most likely is as follows:Dim conn As ADODB.ConnectionDim rs As ADODB.RecordsetDim Cmd As ADODB.Commandconn.ConnectionString = ?CONNECTION STRING?conn.OpenSet Cmd.ActiveConnection = connCmd.CommandText = ?SQL STATEMENT?Set rs = Cmd.ExecuteSet rs.ActiveConnection = Nothingconn.Close
23⟩ Describe Database Connection pooling (relative to MTS )?
This allows MTS to reuse database connections. Database connections are put to sleep as opposed to being created and destroyed and are activated upon request.
24⟩ Drag and Drop state numbers and functions in VB?
State 0 Source control is being dragged with the range of a target.
1 Out of the range of a target.
2 One position in the target to another.
25⟩ What is Mixed Cursors in VB?
Static + Keyset
26⟩ What are the Style Properties of Combo Box in VB?
Simple, Dropdown list We can type and select. Dropdown Combo Only Drop Down.
27⟩ What is the diff between the Std and Class Module in VB?
Std Global with in the project. Cls Global through out the all project only thing is we want to set the type lib. Class Modules can be Instantiated.
28⟩ What is the size of the variant data type?
The Variant data type has a numeric storage size of 16 bytes and can contain data up to the range of a Decimal, or a character storage size of 22 bytes (plus string length),and can store any character text.
29⟩ In project properties if we set Unattended what is it mean?
This cannot have user interface. This can be used for the COM creation.
30⟩ What is view Port in VB?
The area under which the container provides the view of the ActiveX Document is known as a view port.
31⟩ What is the Dll required for running the VB?
Vbrun300.dll
32⟩ Handling Error in Calling chain.
This will call the top most error where the error is handled.
33⟩ What are the different types of error in VB?
Syntax Errors,
Runtime ,
Logic.
34⟩ Why we use Treeview Control in VB?
To list the hierarchical list of the node objects. Such of files and Directories.
35⟩ What is Centralization Error Handling?
Writing function and calling it when error occurs.
36⟩ Dim x, y as integer. What is x and y data type?
X as variant and y as integer.
37⟩ What is frx? What is frx?
When some controls like grid and third party control placed in our application then it will create frx in run time.
38⟩ Different type of Instantiation in VB?
Private Only for the Specific Module.
Public not creatable Private & Public
Multi Use - Variable we have to declare.
Single Use Not possible through dll.
Global Multiuse Have variable not Required to Declare.
Global Single Use - Only for exe.
39⟩ Have you create Properties and Methods for your own Controls?
Properties Public variable of a Class
Method Public procedure of a class
40⟩ Diff types of Lock Types?
RdConcurReadOnly 0 (Default)
RdConcurLock 1 (Pessimistic Locking)
RdConcurRowver 2 (Optimistic Lociking)
RdConcurValues 3
RdConcurBatch 4
