MySQL Database

This tutorial is a continuation of our our previous topic called “Creating MySQL Database tables using Visual Basic. Net”. This time, we're going to focus on displaying and dropping of MySQL Database Tables using Visual Basic.Net. In this application, we need to add two buttons and a datagridview.

In this tutorial, I’m going to show you how to create a MySQL database tables dynamically in a simple way. To start in this lesson, we need to understand first the concept of creating a MySQL database table. The creation of table command requires the following: Name of the table, Names of fields and Definitions for each field.

In this tutorial, It covers how to create a simple MySQL query builder using Visual basic. This application allows user to select MySQL database and when the “use” button is clicked, the program will then load all the tables existing from a specific database. And every time the user select the name of a table it will generate a query and display the result on the datagridview provided.

In this tutorial, it covers the basics of creating and dropping of MySQL Database with visual Basic. MySQL is a leading open source database management system, multi user and a multithreaded database management system. MySQL database is available on most important OS platforms. It is one part of the very popular LAMP platform. Linux, Apache, MySQL, MySQL, PHP. But in my case, I am using XAMPP. To begin in this course, open visual basic and create a new project and name it as “ManageDb”.

In one of our previous tutorials, we discuss on How to "Connect MySQL Database using Visual Basic.Net". We also discuss on How to "Insert and Read data from MySQL Database using Visual Basic".

In this lesson we will focus on completing the user CRUD tutorial or the Create, Read, Update and Delete user. So to start with, Open our last tutorial called "Part II: Inserting and Reading of Data in MySQL Database Using Visual Basic.Net" and select the Manage User form and add two buttons in it.

This tutorial is the continuation of Connecting MySQL Database using Visual Basic.NET. In this part we will focus on how to insert Data and to load data and display it in a form using DataGridview Object. To start with, we will set up first our database table.

Importing or Exporting a MySQL database sometimes using phpMyAdmin is a bit problematic especially if the size of your database exceed the maximum limit of PHP upload.