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
Returns or sets the name of the object or application which generated the error originally. The Source property indicates a string expression which is usually the class name or pro


Displaying the file Without Scrolling: To display a file follow the steps as shown below: 1. Generate a SDI application. 2. Type the coding as shown in the Serialize els


You are given a console program in both VB and C# that uses a class CElevator (ElevatorAppAssign). The main modules are in the assign directory class files. Below is a discus

Question 1 Design a form based applications using labels, text boxes, and buttons to perform basic arithmetic operations on integers Question 2 Describe the concept of Except

Write a XML with database with book details (BOOK ID, Title, Author, subject, published Year, language, vendor, price)

John''s gas supply is read from a 4-digit meter each month that shows the current total gas used in cubic meters. The amount of gas used that month is determined by subtracting t

The following table lists suggested conventions for objects you might encounter while programming VBScript. Code Commenting Conventions All process should begin with a brie

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