Linglom's blog

Introduction

Here comes again, tutorial about programming to access a database server. This tutorial shows you how to use Microsoft Visual Studio’s VB.NET to connect MySQL using MySQL Connector/Net.

I’m going to divide this article into 8 parts:

1. Part I: Introduction
   The post which you’re reading is the article’s index that has short description on each post. Also, information about MySQL Connector/Net and Hardware & Software environment that I use to complete the article.
2. Part II: Setup MySQL Server
   This part shows how to install and configure MySQL Server on a database PC.
3. Part III: Install Sample Database
   The part shows how to install an sample database on MySQL Server. The sample database that I use is world database.
4. Part IV: Create & Grant MySQL User Account
   The part shows how to create a new user and grant privileges to certain database on the MySQL Server.
5. Part V: Install MySQL Connector Net
   This part shows how to install MySQL Connector Net 5.2.5 on a development PC.
6. Part VI: Create Connection
   This part shows how to establish a connection between VB.NET and MySQL.
7. Part VII: Perform SQL Operations
   This is the main part of the article that shows how to perform some basic operations from VB.NET to MySQL. For instance, send query as SELECT, INSERT, UPDATE to a database.
8. Part VIII: Display Result on GUI
   This part shows how to display the query data on GUI using datagrid.

Section

1. MySQL Connector/Net
2. Environment

MySQL Connector/Net

MySQL Connector/Net enables developers to easily create .NET applications that require secure, high-performance data connectivity with MySQL. It implements the required ADO.NET interfaces and integrates into ADO.NET aware tools. Developers can build applications using their choice of .NET languages. MySQL Connector/Net is a fully-managed ADO.NET driver written in 100% pure C#. For more information about MySQL Connector/Net, see MySQL Connector/Net.
Back to top

Environment

Here is the list of the hardware and software that have already been setup in my environment.

1. A Database PC
   • Microsoft Windows XP SP3 (Clean Installation).
   • MySQL 5.1.30 Community Edition (Free). I’m going to install it in Part II.
2. A Development PC
   • Microsoft Windows 2003 Server SP2 (Standard Edition). This is not a requirement, just my environment. You can use Windows XP if you want.
   • Microsoft Visual Studio 2005.

Note: You don’t have to setup exactly environment as mine. For instance, you can setup all the software above in a single PC for ease of development.
Back to top