Click here to Skip to main content
Click here to Skip to main content

VB.NET to MySQL Database Connection

, 18 Jun 2007
Rate this:
Please Sign up or sign in to vote.
Connecting from VB.NET to a MySQL database.

Introduction

I'm currently developing an inventory management system which caters to multiple warehouses. I will share with you some tips and tricks in the development of this program. The system is still under development.

The database I use is MySQL Server 5.0.x together with the MySQL .NET Connector. Firstly, I'll share a few tricks about connecting to MySQL. Discussions on saving, querying, and other useful tricks will follow later on.

Using the code

To be able to create this program, you must have basic knowledge concerning MySQL 5.0 as well as VB.NET.

Prerequisites

Steps

  1. Install MySQL Server 5.0 and and MySQL .NET Connector.
  2. Import a reference of the MySQL >NET Conenctor in Project Settings.
  3. Go to Settings and type the following settings:
  4. Name         Type      Scope   Value
    myDB ->      String -> User -> DatabaseName
    myServer->   String -> User -> Servername
    myUsername-> String -> User -> DbUserName
    myPassword-> String -> User -> DbPassword
    myPort->     String -> User -> mySQLPort(3306)

  5. Change the values in your MySQL database settings. The purpose of changing the setting is that if the MySQL database settings will change, e.g., the server is migrated, you can easily change the server settings and you won't have to rebuild the project.
  6. Add a Module in your project and name it mdlDataConn6. Paste the following code in your Module:
  7. Imports MySql.Data.MySqlClient
    
    Module mdlDataConn
        Public conn As New MySqlConnection
    
        Public Sub ConnectDatabase()
    
            Try
                If conn.State = ConnectionState.Closed Then
                    conn.ConnectionString = "DATABASE=" & My.Settings.myDB & ";" _
                      & "SERVER=" & My.Settings.myServer & ";user id=" & My.Settings.myUsername _
                      & ";password=" & My.Settings.myPassword &";port=" & _
                      My.Settings.myPort & ";charset=utf8"
                    conn.Open()
                End If
    
            Catch myerror As Exception
                MessageBox.Show("Error Connecting to the database", "Error Database Server", _
                                MessageBoxButtons.OK, MessageBoxIcon.Exclamation)
                End
            End Try
        End Sub
    
        Public Sub DisconnectDatabase()
            Try
                conn.Close()
            Catch myerror As MySql.Data.MySqlClient.MySqlException
    
            End Try
        End Sub
    End Module
    'To connect to mySQL Database just call.
    ConnectDatabase
    
    'To close the mySQL Database
    DisconnectDatabase

That's all!

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

jopascual
Web Developer
Philippines Philippines
Jayson Pascual is the software developer of the POS Technology Solution located in Philippines. He was more than 4 years in experience developing in business system such as POS, Inventory, Accounting, and etc. He start developing business system at age of 17 using VB6 and MS SQL Server 2000 and current using VB2005 and MySQL 5.0 to reduce cost and maintenance for the SME's Businesses. \
 
He currently serving SME's in the Philippines and developing easiest as possible business system because most of the employees and employers are first time user in computer.

Comments and Discussions

 
Question'&amp' not declared PinmemberBeninda5-Dec-13 0:27 
AnswerRe: '&amp' not declared PinmemberMark_essex27-Dec-13 7:13 
QuestionError (amp;) PinmemberZoZZ8819-Jun-13 14:18 
QuestionHow enumerated MySQL server instances on the network? PinmemberGregorio Cobá14-Jul-09 19:14 
GeneralHelp! I'm a desperate beginner :( PinmemberDarkRaven102415-Nov-07 23:35 
QuestionSample SQL query codes PinmemberM Sopian H17-Sep-07 16:45 
AnswerRe: Sample SQL query codes Pinmemberfdchiu24-Sep-10 21:11 
QuestionMysql 4.2 Pinmemberzubinkasad26-Jun-07 21:52 
AnswerRe: Mysql 4.2 PinmemberIrwan Hassan27-Jun-07 3:17 
OK, I would like to help you, but I don't understand your question.
 
Did you mean MySQL 4.1.2? I don't know if there are mysql 4.2 available.
 
I'm a VB6 Programmer for past 7 years. Currently I'm slowly moving to VB2005. I'm using MySQL 4.1.12 for more 2 years. Before this I'm using MS Access for most of my developed application.
 
So, you may ask the question to both of us. I will help you, if I understand your question.
GeneralRe: Mysql 4.2 Pinmemberzubinkasad27-Jun-07 3:36 
GeneralRe: Mysql 4.2 PinmemberIrwan Hassan27-Jun-07 15:16 
GeneralRe: Mysql 4.2 Pinmemberzubinkasad27-Jun-07 18:46 
GeneralRe: Mysql 4.2 PinmemberIrwan Hassan28-Jun-07 17:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web04 | 2.8.140827.1 | Last Updated 18 Jun 2007
Article Copyright 2007 by jopascual
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid