C SHARP AND MYSQL DATABASE CRUD TUTORIAL 19 How To Create New MySql Database PHPMyAdmin

C# AND MYSQL DATABASE CRUD TUTORIAL #19 – How To Create New MySql Database – PHPMyAdmin

VIDEO TUTORIAL

C# AND MYSQL DATABASE CRUD TUTORIAL #19 – How To Create New MySql Database – PHPMyAdmin

This Tutorial Shows How To Create New MySql Database – PHPMyAdmin In C Sharp .Net Windows Forms Application using visual studio 2010.

Start xampp control panel.

If you have shortcut click it to start xampp.

If you don’t, Start xampp from installation location.

How To Create New MySql Database Using PHPMyAdmin - Xampp Location
How To Create New MySql Database Using PHPMyAdmin – Xampp Location

Start both Apache and Mysql.

How To Create New MySql Database Using PHPMyAdmin - Start Xampp
How To Create New MySql Database Using PHPMyAdmin – Start Xampp

Both services are now running.

How To Create New MySql Database Using PHPMyAdmin - Start apache and mysql
How To Create New MySql Database Using PHPMyAdmin – Start apache and mysql

Click Admin next to mysql to stat PHPMyadmin GUI. On your browser.

How To Create New MySql Database Using PHPMyAdmin - Admin Next To mysql
How To Create New MySql Database Using PHPMyAdmin – Admin Next To mysql

Click New To create new database.

How To Create New MySql Database Using PHPMyAdmin  - phpmyadmin Homepage
How To Create New MySql Database Using PHPMyAdmin – phpmyadmin Homepage

Enter database name and click create button.

How To Create New MySql Database Using PHPMyAdmin - Enter Database Name
How To Create New MySql Database Using PHPMyAdmin – Enter Database Name

The database is created without any table inside.

How To Create New MySql Database Using PHPMyAdmin - Database Created
How To Create New MySql Database Using PHPMyAdmin – Database Created

On the left pane under created database, click on new, to create new table.

Enter table name and add required columns and their datatypes.

How To Create New MySql Database Using PHPMyAdmin - Create New Table
How To Create New MySql Database Using PHPMyAdmin – Create New Table

To check the table structure click on structure tab.

How To Create New MySql Database Using PHPMyAdmin - Table Structure
How To Create New MySql Database Using PHPMyAdmin – Table Structure

To run a query for selecting all data from the table click on “SQL” tab.

Enter query in the text area.

How To Create New MySql Database Using PHPMyAdmin - Select All
How To Create New MySql Database Using PHPMyAdmin – Select All
How To Create New MySql Database Using PHPMyAdmin - All Table Data Selected
How To Create New MySql Database Using PHPMyAdmin – All Table Data Selected

C# SOURCE CODE

Leave a Reply

Your email address will not be published. Required fields are marked *