Display Information from MySQL Database into Text Box using C#

Display Information from MySQL Database into Text Box using C#

In this Tutorial, I will show you how to display information from MySQL Database into TextBox, 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#

Display information from MySQL Database into Text Box using C# - Step 2 — Display information from MySQL Database into Text Box using C# – Step 2

Step 3:

Back to the windows forms application and design information forms like this (see below picture)

txtemp_id
txtname
txtdesignation
txtusername
txtpassword
btnadd

Display information from MySQL Database into Text Box using C# - Form Design — Display information from MySQL Database into Text Box using C# – Form Design

Step 4:

-> double click txtemp_id

Source code for Employee ID TextChanged(txtemp_id) event:

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 txtemp_id_TextChanged(object sender, EventArgs e)
        {
           MySqlConnection con = new MySqlConnection("datasource= localhost; database=sampledb;port=3306; username = root; password= db1234"); //open connection
           con.Open();
           MySqlCommand cmd = new MySqlCommand("select * from information where emp_id='"+ txtemp_id.Text +"'",con);
           MySqlDataReader reader = cmd.ExecuteReader();
            if (reader.Read())
            {
                txtname.Text = reader.GetString("name");
                txtdeisgnation.Text = reader.GetString("designation");
                txtusername.Text = reader.GetString("username");
                txtpassword.Text = reader.GetString("password");
            }
            else
            {    
                txtname.Text = string.Empty;
                txtdeisgnation.Text = string.Empty;
                txtusername.Text = string.Empty;
                txtpassword.Text = string.Empty;
            }    
   }
}
}

Code Explanation:

This code retrieves data from a database, those data are displayed in a textbox field.

Results: