Open your MySQL workbench > click on create schema > Apply to SQL script page will open >give the name to your schema > click on apply > again click on apply now the SQL script page will show you the output that “ your SQL script is successfully applied to the database”> close the SQL script.Ĭlick on the schema/Database which you have named in the above step it will be showing on the left side of the screen > just right click on the schema/database > right-click on Tables > click on create table > give the name to your table > double click under the white section of table name > add columns and give the name and data type for those columns > click on apply.
Step 1:įirst, we have to create a table in our MySQL workbench if you have the MySQL workbench and MySQL server installed in your system then it’s good otherwise first download and install them with all the required things then move to the next step.
Here, we will see how to use Data Grid View along with data from SQL Server Database using SQL Data Adapter and Data Table in VB.NET Application.įor doing this we have to do two main things that are How to retrieve data from MySQL dataTable and display it in a table format using VB.NET windows application.