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 …
In this post, I’ll show how to setup MySQL Server on a database PC. Step-by-step to setup MySQL Server Download MySQL 5.1.30 Community Edition from mysql.com. Double-click the setup …
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 …
Create & Grant MySQL User Account By default, the root account on MySQL Server has all privileges on every tables on MySQL Server but only localhost can have accessed …
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 …
Create Connection 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 …
Perform SQL Operations 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, …
Display Result on GUI 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 …