Load Datagridview from a MySQL Database in C#

Load Datagridview from a MySQL Database in C#

In this tutorial, I will show you how to load MySQL Database Value in DataGridView using C# in a simple way.

Let’s follow tutorial below.

Step 1:

Create Project And Add Reference To C# WinForms Project. (visit the link to the first tutorial on how to add reference to our C# project)

How to connect MySQL Database to C# Tutorial and Source code

Step 2:

Open MySQL Workbench, right click and create schema (new database), give database name as “sampledb” and create table in database and give a name as “information”, then create columns id, emp_id, name, designation, username and password and then insert data into table.

visit the link below on the tutorial on how to insert record in mysql and c#

Insert or Save Data into MySQL Database using C#

Load Datagridview from a MySQL Database in C# - Step 2 — Load Datagridview from a MySQL Database in C# – Step 2

Step 3:

Back to the windows forms application and design forms like this

txtemp_id
txtname
txtdesignation
txtusername
txtpassword
btnadd
btnedit
btndelete
DataGridView1

Load Datagridview from a MySQL Database in C# - Form Design — Load Datagridview from a MySQL Database in C# – Form Design

Step 4:

Double click form to show forms load events

Source code for Forms Load events:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

namespace CSHARP_FULL_COURSE_WITH_MYSQL_DATABASE
{
    public partial class information : Form
    {
public information ()
        {
            InitializeComponent();
        }
        private void fillcombobox_Load(object sender, EventArgs e)
        {
           MySqlConnection con = new MySqlConnection("datasource= localhost; database=sampledb;port=3306; username = root; password= db1234"); //open connection
           con.Open();
           DataGridView1.DataSource = null;
           MySqlDataAdapter adapter = new MySqlDataAdapter("select * from information",con);
           DataTable dt = new DataTable();
           adapter.Fill(dt);
           DataGridView1.DataSource = dt;
           con.Close();
   }
}
}

Code Explanation:

This code is for loading or viewing data from a database into DataGridView.

Result: