Data Control

The Data Control: is used to connect VB with a Database

Properties of Data Control.

1.                        Connect

2.                        Data base Name

3.                        Record Source

4.                        Recordset Type

Connect: 

1.            Specifies the type of the database

Default type: Access.

Other types:  Dbase, FoxPro, Excel, Lotus, Paradox etc.

2.            Steps to set the Connect Property.

1.Select the data control in the form.

2.Properties à Connect àSelect the type of database.

II.        Database Name

1.Identifies the path of the database file

III.                  Steps to set the Database Name

Name Property.

1.Select the data control in the form.

2.Properties à Database Name     àSelect àDatabase file Name

III. RecordSource: Is used to select table used by the data control

  Arrays and Procedures

Q.1.  (a). You need to write a program to store the names of the students in your class. What type of data storage is most suitable and why?

         (b). Which loop structure is most convenient to process array? (Give two reasons for your answer.

Q.1.  Suggest most suitable    controls for the following

Q.2.  Design a form that will allow you to enter multiple lines of text in some control. The text entered must be displayed in bold and italic type:

Ans:  We can use a text box (Control) to accept multiple lines of text.

Set Multiline Property à True

Set FontBold à True

Set FontItalic à True

Q.3.  A VB program when executed does not display the window. Instead the window is shown on the task bar. What is the reason? How will you correct this problem?