Actually, I don’t prepare to write this post while I was writing the series. But there are some people want to know how to display a query data on Windows form rather than in console window which I wrote in the previous post. So this post, I’ll show how to display a query data on DataGridView on Windows form using MySqlDataAdapter.
From the previous part, I have successfully connect to world database on MySQL Server from VB.NET. Next, I try to perform basic SQL operations (SELECT, INSERT, UPDATE and DELETE) on the world database.
Note: This post is continued from the previous part. If you start a new project, you’ll need to add MySql.Data reference. See the previous post for more detail.
After I have prepared many things for showing how to access MySQL Server using VB.NET. Let’s see what I have done so far. Right now, I have a remote MySQL Server at 192.168.125.21 with port 3306 (Default port). Also, a sample database “world” and a user account “worldUser” with password “worldpassword”. Now it’s time to start Microsoft Visual Studio 2005 on a development PC.
From last 4 parts, I have prepared MySQL Server with sample database. I’ve done on a database PC. Next, I’ll move to a development PC. Assume that I have already installed Microsoft Visual Studio 2005 already. Now I need to download and install MySQL Connector/Net 5.2 on a Development PC which is a library for connect to MySQL Server from .NET Application.
By default, the root account on MySQL Server has all privileges on every tables on MySQL Server but only localhost can have accessed (remote access is not allowed) and it is recommend to use other user account rather than root account to perform operations on MySQL Server (for security issue). Therefore, you should create a new user account on MySQL and grant at least privileges for the account as possible.
You can download example databases for MySQL at http://dev.mysql.com/doc (Scroll down to Example Databases section). By the time I’m writing the article, there are 4 sample databases available on the page. I choose the world database since it compatible with all MySQL version.
This section I’ll show how to setup MySQL Server on a database PC. You can see index of this series at Accessing MySQL on VB.NET using MySQL Connector/Net, Part I: 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.
This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 2.5 License.