To be a programmer you should and should control or have some basic coding of a simple connection especially with Access. On this occasion I would like to discuss some ways to discuss a little coding or connect using Access which is a basic database application programs that are often used in the office environment especially web connection and Visual Basic 6.0.
Before doing the real thing, in making the above table we are not really necessary in this discussion but just for information only for beginners in order to better understand and comprehend. To give an explanation to pembaca.Yang must be considered in this matter is the understanding of coding the connection itself.
For the first one done is create a module for the first call of the database connection. After making the connection input coding as follows:
For the first one done is create a module for the first call of the database connection. After making the connection input coding as follows:
Public cn As New
ADODB.Connection Public Sub BukaDB() Dim
koneksi As String koneksi = “provider=microsoft.jet.oledb.4.0;
Data source= ” & App.Path & “\latihan.mdb;”cn.Open koneksi End
Sub.
Note the above code, should not be confused and mistake his writing because it is important in mengkoneksikannya code will ttetapi you should be able to understand it correctly, the first one is
Cn As New ADODB.Connection Public Function to create a variable to be public use ADODB
Dim connection As String Functions to create are private variables of type string connection = "Provider = Microsoft.Jet.OLEDB.4.0; data source =" & App.Path & "\ latihan.mdb;"
the above code is the main code of the connection is required. The first uses the Microsoft Jet OLEDB 4.0 provider that calls the data source / sources of data from the database latihan.mdb.
Open the connection and the last is opening connections are public using the code above.Database Programming (Database Programming) is a form of alternative programming for database processing. Through database programming with freely can manage a database and workflow better. One of the programming language that has been supporting the visual Basic database programming. Visual Basic can be associated with a data processing application programs such as MySQL.
MySQL is one of the open source database of the most popular in the world due to high speed, high reliability and user friendly. In addition to MySQL, Visual Basic can be linked with other data pegolahan applications, such as MS. Access, Paradox, SQL Server, and so on.
Before the data from the database may be used, the connection between the program and the database must be opened first. There are many ways to open a connection, here used mysqlnetConnector, a library created by the mysql connector to connect applications. Net with mysql database. Another way to use the ODBC connector.
Thanks
