Insert or Save Data into MySQL Database using C#

Insert or Save Data into MySQL Database using C#

In this tutorial I will show you how to insert data in MySQL 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.

Insert or Save Data into MySQL Database using C# - Create Table — Insert or Save Data into MySQL Database using C# – Create Table

Step 3:

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

txtemp_id
txtname
txtdesignation
txtusername
txtpassword
btnadd

Insert or Save Data into MySQL Database using C# - Form Design — Insert or Save Data into MySQL Database using C# – Form Design

Step 4:

Source Code for Add button(btnadd) clicked 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 btnadd_Click(object sender, EventArgs e)
  {
  if (txtempid.Text == string.Empty || txtname.Text == string.Empty || txtdeisgnation.Text == string.Empty || txtusername.Text == string.Empty || txtpassword.Text == string.Empty)
  {
      MessageBox.Show("Empty Field", "VINSMOKE MJ", MessageBoxButtons.OK, MessageBoxIcon.Error);
      return;
  }
  else
  {
  MySqlConnection con = new MySqlConnection("datasource= localhost; database=sampledb;port=3306; username = root; password= db1234"); //open connection
                   con.Open();
         MySqlCommand cmd = new MySqlCommand("insert into information(emp_id,name,designation,username,password) values('" + txtempid.Text + "','" + txtname.Text + "','" + txtdeisgnation.Text + "','" + txtusername.Text + "','" + txtpassword.Text + "')",con);
         cmd.ExecuteNonQuery();
         cmd.Dispose();
         txtempid.Text = string.Empty;
         txtname.Text = string.Empty;
         txtdeisgnation.Text = string.Empty;
         txtusername.Text = string.Empty;
         txtpassword.Text = string.Empty;
        con.Close();
        MessageBox.Show("Successfully Added", "VINSMOKE MJ", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
   }
}
}

Code Explanation:

This code serves as saving data or information in the database using this code will help you to understand the simple way to insert data, proper open and close connection.

Result: