Accessing MySQL on VB.NET using MySQL Connector/Net, Part 1: Introduction

This entry is part 1 of 8 in the series Accessing MySQL on VB.NET

Introduction

Here comes again, another tutorial about accessing MySQL on VB.NET. 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.

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.

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.

Series NavigationAccessing MySQL on VB.NET using MySQL Connector/Net, Part 2: Setup MySQL Server >>

15 Comments

  1. John Grissom July 27, 2009
  2. Jose Miguel Castillo October 29, 2009
  3. linglom November 4, 2009
  4. jheck November 11, 2010
  5. Guy December 10, 2010
  6. napstyr April 23, 2011
  7. Ben September 15, 2011
  8. john September 27, 2011
  9. chieto February 7, 2012
  10. huejii February 14, 2012
  11. leary March 15, 2012
  12. TERI September 4, 2012
  13. kakang October 26, 2012
  14. Scousebutty November 27, 2012
  15. zahid April 14, 2013

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.