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
This is a member of Microsoft's Visual Basic family of development products. Other members comprise Visual Basic (Professional and Standard Editions) & Visual Basic for Application

A Project to Display a Database: 1. Suppose that there are 5 fields describing a customer. Id, address, name, city & state. 2. Put 5 text boxes on the form to exhibit the r

Displaying The Database: The Text box, image box, check box, labels, picture box can be bounded to the data control for exhibiting the data base contents. The two properties a

Problem 1. Describe the concept of exception in .Net environment 2. Explain the process of adding, updating and deleting records with an example 3. Explain DTD elements a

Sets or returns wholly qualified path to a Help File. If Help file is indicated in HelpFile, it is called automatically when the user clicks Help button (or presses the F1 key) in

Adding Handlers With Class Wizard: Whenever a handler is added, the class wizard places the prototype for the message handler in the header (.H) file. It gives a skeleton hand

Option Explicit Declaration: If the option explicit is used essentially then all the variables will have to be declared. Or else an error will be reported saying that the vari

Question 1 Write about the Visual Basic Application Development Life cycle with a sample Forms development for performing integer arithmetic operations Question 2 Discuss the

CONTROL ARRAY The control array is a group of similar objects with similar name. Adding controls with control arrays uses less resource than simply adding the multiple controls

Shopping Cart Purpose – Allows user to browse while keeping track of the items in which they will purchase at the end on the order page link and this will give a final price for al