Creating MySQL Database tables using Visual Basic. Net

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. The generic syntax of creating a MySQL table is like as shown below: This time, let’s start building our application. First open Visual basic and create a new project and Name it as “tblcreator”. After creating a new project, we will then add objects to our form and these objects are the following: three labels, three buttons, two combobox, one textbox, one datagridview and a groupbox. Then arrange all objects looks like as shown below. Next, for datagridview1 we need to add 6 columns. And these are: Field, type, Length/Values, Null, Index and Auto. Here’s the settings for datagridview columns:

Selected Columns	Properties		Settings
Field			Header Text		Field
			DatapropertyName	n_field
			Name			n_field
			ColumnType		DataGridViewTextBoxColumn
type			Header Text		type
			DatapropertyName	n_type
			Name			n_type
			ColumnType		DataGridViewComboBoxColumn
			Items			INT
VARCHAR
TEXT
DATE
Lenght/Values		Header Text		Lenght/Values
			DatapropertyName	n_Lenght
			Name			n_Lenght
			ColumnType		DataGridViewTextBoxColumn
NULL			Header Text		Null
			DatapropertyName	n_null
			Name			n_null
			ColumnType		DataGridViewCheckBoxColumn
			Truevalue 		NOT NULL
			Falsevalue		NULL
Index			Header Text		Index
			DatapropertyName	n_index
			Name			n_index
			ColumnType		DataGridViewComboBoxColumn
Items			PRIMARY KEY
UNIQUE	
INDEX
FULLTEXT
Auto Increment		Header Text		Auto Increment
			DatapropertyName	n_ai
Truevalue		AUTO_INCREMENT
			Name			n_ai
			ColumnType		DataGridViewCheckBoxColumn

After we set the datagriview columns, here are few items need explanation: • Field Attribute NOT NULL is being used because we do not want this field to be NULL. So if user will try to create a record with NULL value, then MySQL will raise an error. • Field Attribute NOT NULL is being used because we do not want this field to be NULL. So if user will try to create a record with NULL value, then MySQL will raise an error. • Field Attribute AUTO_INCREMENT tells MySQL to go ahead and add the next available number to the id field. • Keyword PRIMARY KEY is used to define a column as primary key. You can use multiple columns separated by comma to define a primary key. This time, lets add functionality to our application. To do this, double click the form and add the following code below public class. Then, on the form1_load add the following code. This will populate the combobox with database name. Next, we need to display all the MySQL Database tables on the combobox provided for table name based on the Database selected. To do this, double click the “use” button and add the following code: Then in order to enable the “create” button, we need to pass first to “Add” button. To do this, add the following code: next, double click our “create” button and add the following code: And here’s all the code use for this application. To test this program, press “F5”.