Part II: Inserting and Reading of Data in MySQL Database Using Visual Basic.Net

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. To do this make sure that you have installed XAMPP this software is free and open source cross-platform web server solution stack package, consisting mainly of the Apache HTTP Server, MySQL database, and interpreters for scripts written in the PHP and Pearl programming languages. If not installed you can download it to the web and install it into your computer. After you have successfully installed it on your computer just simply run the Apache Server and MySQL database using the XAMPP Control Panel Application. Next step open any browser available in your local computer. For example “google chrome” and on the address bar just type http://localhost/phpmyadmin/ and press enter. After this on the List of the Database then Select “test” Database as default the test database don’t have any table(s) available inside it. And on the “menus” Select the SQL tab and paste this code: So this code will create a table named “users” and it has a field such as user_id, fullname, username and password. Now the users table will look like as shown below. Now it’s time to proceed to our main goal of this tutorial, to do this let’s open the first Part and the title of this is “Connecting MySQL Database using Visual Basic.Net” and the project name of this is “VBMYSQL”. After this step Go to Solution Explorer->right click the Project name->Click Add->Select Windows Form and automatically new form will open and the default name of this is “Form2”.

Designing the User Interface

In the User Interface just add two Buttons, three Textbox, three Labels, one Groupbox and one Datagridview.

Object			Property			Settings

Form2			Name				manage_user
			Text				Manage User
Button1   		Name				btncreate
			Text				Create User
Button2   		Name				btnRead
			Text				Read User
Textbox1		Name				txtfullname
Textbox2		Name				txtusername
Textbox3		Name				txtpassword
Label1   		Text				Full Name
Label2  		Text				Username		
Label3			Text				Password
GroupBox1		Text				User Info
DataGridView1		Name				dtguser

And the design looks like as shown below. Hence we have designed our User Interface let’s proceed to add functionality one of our button specifically the “Create User”, to do this just Double Click “Create User” button after this you be redirected to the code view. And add again we’re going to do something we have done in our first tutorial that we put an Imports MySql.Data.MySqlClient above Public class so that we can have access to our MySQL Objects. Then we need also to copy and paste our declaration of our object the MySqlConnection Dim con As New MySqlConnection and together with this declaration we need also to add declaration and the code now will like as shown below. This time we will try to test if our code is working properly. But before this, we need to set first that when the program runs it run first the “Manage User” Form. To do this, Go to Solution Explorer->right click and select Properties. And on the properties choose the “Application Tab” and under the “Startup form” choose the “manage_user” like as shown below. Then just press f5 to run your application. And you test it by writing something in the textbox provided and after just simply click “Create User” button. After this you can view the result in phpmyadmin if you really successfully saved your user inputted. So we are designing and adding of code to our “Create User” we only need is to display all the user saved in the database to our datagridview. To do this, double click “Read user” and Add this code. After this add another sub procedure like this. And finally try to run your application and the final output will be look like as shown below. these are all the source code in this tutorial. So that is for now folks. My Part III of my Tutorial will be focusing on completing the User CRUD or the CREATE, READ, UPDATE AND DELETE.