Data control, Visual Basic Programming

DATA CONTROL

The data control is used to connect to the database. Three properties are very necessary to connect to the database. The primary property is the database name. You can put this in the data control property. The syntax is as shown below:

Form.datacontrol.DatabaseName = pathname

The pathname is the position of the database file name. When the database is ex.mdb and the data control is Data1 next to put the DatabaseName property to do the initialization as shown below:

Data1.DatabaseName = "C:\ex.mdb"

The second property is the Connect property. The default is Access. When you click the drop down list box you'll examine that you can connect to the Paradox, Lotus, Dbase, Excel, and ODBC. You require setting the Connect property. The third property is a Record set property. It can be a dyna set type record set table, a table or a snap shot type record set. The Record Source can be a SQL statement or a table.

Posted Date: 10/10/2012 1:05:23 AM | Location : United States







Related Discussions:- Data control, Assignment Help, Ask Question on Data control, Get Answer, Expert's Help, Data control Discussions

Write discussion on Data control
Your posts are moderated
Related Questions
Variant Type: If no data type is related with the VB variables, it takes the default variant type. The variable x will be of the variant type when the two declarations below a

Events: The Controls are placed on a form and then to make them functional an "event procedure" is related with the control object. An event process is what happens in respons

The objective of this unit is to describe the basics of VBScript. After completing this unit, you will be capable to write code for Web pages via VBScript. You will be able to unde

In VBScript, You create user-defined constants using the Const statement. It lets you create string or numeric constants along with meaningful names and let you to assign them lite

Use the While keyword to verify a condition in a Do...Loop statement. You can verify the condition before you enter the loop (as illustrated in the following ChkFirstWhile instance

DIALOG BOXES IN VB The two dialog boxes, namely, the message box and the input box are usually used in the Visual Basic. The message box is used for displaying the messages to

To run only one statement while a condition is True, employ the single-line syntax for the If...Then...Else statement. The following instance shows the single-line syntax. Notice t

#question.algorithemtofindwhetheragivennumberisprime/not.

Displaying a file With Scrolling: To display a file with the scrolling option allows the steps as shown below: 1. Generate a SDI application. 2. In the Step 6 of the App

If Then Else: The control statement If Then Else is used for computing a condition and taking the action based on the condition. If the condition is true then the section will