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

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

February 12, 2009 VB.NET 15 Comments
This entry is part 1 of 8 in the series Accessing MySQL on VB.NET

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 >>

Related Posts

15 Comments

  1. John Grissom July 27, 2009

    How would I go about doing this without using the datagrid if I wanted to post the username etc. of a user in a label

  2. Jose Miguel Castillo October 29, 2009

    ado.net + MySQL connect/net ?
    or
    only MySQL connect/net ?

    i need to connect my pockec wiht MySQL data base

    (i have VB.net 2008 and MySQL Connect/net 6.2)

    help

  3. linglom November 4, 2009

    Hi, Jose Miguel Castillo
    MySQL Connector/Net is a fully-managed ADO.NET driver. I think you can follow my article.

  4. jheck November 11, 2010

    i hope this tutorial will help to learn more about in visual basic .net Express edition

  5. Guy December 10, 2010

    this tutorial help me very mutch

  6. napstyr April 23, 2011

    you’re great man.. thanks very much!

  7. Ben September 15, 2011

    Thank you very much. After hours and hours of researches to connect my programm vb.net to MySQL, I finally found your tutorial. It finally works thanks to you.

  8. john September 27, 2011

    thanks so much.

  9. chieto February 7, 2012

    hi. . .thanks for the tutorial. . .

    can you give. a step by step on how pc1(server) and pc2(client). with only 1 database.

    i am using wampserver.

    my problem is . . when i am in pc2(client)

    i can’t connect with pc1(server)using pc1 ip address. .
    conn.ConnectionString = “server=192.168.1.1;

    please help me. thanks

  10. huejii February 14, 2012

    I have the same problem with CHIETO

    connecting to mysql server using the vb.net

  11. leary March 15, 2012

    we can’t activate our search bar ,would you help us how is it??tnx

  12. TERI September 4, 2012

    You realize therefore significantly in terms of this subject, made me for my part believe it from numerous numerous angles. Its like women and men don’t seem to be interested until it’s something to accomplish with Girl gaga! Your individual stuffs great. Always maintain it up!

  13. kakang October 26, 2012

    @Chieto :mungkin pada saat configuration wizard pada MySQL anda tidak mencentang “Enable root acces from remote machine”

  14. Scousebutty November 27, 2012

    Excellent work. Thanks for publishing. Made my day!

  15. zahid April 14, 2013

    Great article .I learn from this

Leave a Reply