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

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

Connect C# to MySQL

This article show step by step manner on how to use and connect C# with MySQL using MySQL Connect/NET

Download MySQL Connector/NET

First make sure you have downloaded and installed the MySQL Connector/NET from this link https://dev.mysql.com/downloads/connector/net/ MySQL official website

Add Reference

Before you connect application to MySQL, you need to add MySQL reference in your project.

To do this, right click reference and click Add Reference and Choose “MySQL.Data.dll”

How to connect MySQL Database to C# - Add Reference
How to connect MySQL Database to C# – Add Reference

Next, add MySQL library to your project.

using Mysql.Data.MysqlClient;

C# MySQL connection string

string connectionstring = “datasource=localhost;database=sampledb;port=3306;username=root;password=db123”;

For multiple Server this is the connection string if the server in a replicated server configuration

“datasource=localhost;database=dbname1,dbname2;port=3306;username=root;password=db123”;

I created a simple form with a button in it, our connection will be established when the button is clicked

How to connect MySQL Database to C# - Form Design
How to connect MySQL Database to C# – Form Design

Now the code for the button clicked event:

using System;
using System.Windows.Forms;
using MySql.Data.MySqlClient;
namespace WindowsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        private void button1_Click(object sender, EventArgs e)
        {
string connectionstring=“datasource=localhost;database=sampledb;port=3306;username=root;password=db123”;            MySqlConnection con = new MySqlConnection(connectionstring);         
            try
            {
                con.Open();
                MessageBox.Show ("Connected");
                con.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Connection Not Established");
            }
        }
    }
}

Code Explanation:

These code serve as the connection from MySQL Database to the C# Project

How to connect MySQL Database to C# Free Download Source code

Mark Jaylo

[email protected]

link: https://www.youtube.com/watch?v=CFobuYUDXe0&list=PLyrZdI7gZW7qhN-RwK1b5EqIzfHz5fh9F

You may visit our facebook page for more information, inquiries and comments.

Hire our team to do the project.

Comments

comments

, , ,

Post navigation