Read data from MySQL table and display in a table form using C#

how to retrieve data from MySQL dataTable and display it in a table format using C# windows application.

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 Windows Forms Application with C#.

For doing this we have to do two main things that are

• Creating a database table in MySQL workbench
• Fetching the data from MySQL table into C# WinForms in a table format

Creating a database table in MySQL workbench

First, we have to create a table in the MySQL database for this we have to follow these simple steps.

Step 1:

first, 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 will be good otherwise first you have to download and install them with all the required things then move to the next step.

Step 2:

Open your MySQL workbench > click on create schema > the 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.

Step 3:

Click 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 4:

Now add data into your table > from the left sidebar click on the table name in which you have to add data > from given three options choose last option that has a table icon > the table window will open > then type the data in given columns one by one adding the rows when you complete one row by entering the data in all fields just click on enter button so the cursor will move to next row. By doing this complete your table with the data you want to enter > click on apply button.

Step 5:

A new window of SQL script will open > click on apply > next click on finish. Our table is now successfully created containing data.

Fetching data from MySQL table into C# Windows forms

Open visual studio > go to File menu > New project > in visual C# > add Windows Form Application C# > add DataGridView control from toolbox by dragging it into form.

using System.Data;
using MySql.Data.MySqlClient;

private void Form1_Load(object sender, EventArgs e)
using System.Data;
using MySql.Data.MySqlClient;
{
this.BindGrid();
}
private void BindGrid()
{
string conString = @"Data Source=localhost;port=3306;Initial Catalog=AjaxSamples;User Id=Nida;password=pass@123";
using (MySqlConnection con = new MySqlConnection(conString))
{
using (MySqlCommand cmd = new MySqlCommand("SELECT * FROM employee", con))
{
cmd.CommandType = CommandType.Text;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd);
{
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
dataGridView1.DataSource = dt;
    }
   }
  }
 }
}

Output:

Now you can see that our table data is retrieving or fetching into our C# window form and set into Data Grid View.

By doing these steps we can simply connect our MySQL table with our C# WinForms and as result, the grid view will show the data of our MySQL table in c# in a table manner.