Click here to Skip to main content
11,630,646 members (78,755 online)
Click here to Skip to main content

Tagged as

How to Connect to MySQL Using C#

, 17 Jul 2012 CPOL 218.3K 45
Rate this:
Please Sign up or sign in to vote.
How to connect to a MySQL database using the MySQL Connector for .NET.


This article shows you how to connect to a MySQL database using the MySQL Connector for .NET. I will also show you how you can update MySQL database records using C#.


  • Install Visual Studio 2008 or Visual Studio 2010
  • Install MySQL database on your local machine
  • MySQL database admin tool that allows you to create a database and run SQL statements. I am using phpMyAdmin which is a web interface.
  • Download and install MySQL Connector.

Getting Started

Run the XAMPP application and it will automatically install Apache server, MySQL database, and FileZilla. After installing check whether these services are running or not. The following XAMPP control panel shows which of those services are currently running.

Now the following steps will show how to connect to a MySQL database using C#.

Step 1

Open MySQL Admin page and create a new database.

Step 2

After creating the new database, create a new table.

Step 3

After creating the new table, open Visual Studio and click on New Project and name the project. It will open the new project, then click on Solution Explorer (F4), right click on “Reference” to add a new reference into the project. Reference those two .dll files to the project (MySql.dll (Win apps), MySql.web.dll (Web apps)).

Step 4

Add namespace to the project.

Step 5

Create a MySQL connection string.

Step 6

The following code will insert the data into MySQL table.

Step 7

The following function will load the data from the table and bind it into a GridView.

Step 8

The final result is shown on the window form:


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Ravindra T C
Software Developer L&T IES Mysore
India India
I'm a software developer. I spent most of the time in learning new technologies. I've a keen interest in client-side technologies especially JavaScript and Jquery it is the most beautiful language ever seen.

I like sharing my knowledge and written some non-popular articles. I believe in quality and standards but blames myself for lagging them.

I believe in small things and they makes me happy!

You may also be interested in...

Comments and Discussions

Questionhelpful, but ordinary work Pin
Member 117989125-Jul-15 14:00
memberMember 117989125-Jul-15 14:00 
GeneralMy vote of 4 Pin
Nidhin David8-Mar-15 6:58
memberNidhin David8-Mar-15 6:58 
GeneralMy vote of 2 Pin
sam.hill13-Apr-14 16:38
membersam.hill13-Apr-14 16:38 
GeneralRe: My vote of 2 Pin
zamkinos18-Jun-15 20:35
memberzamkinos18-Jun-15 20:35 
Question[My vote of 1] No sample project Pin
msdevtech29-Dec-13 8:56
membermsdevtech29-Dec-13 8:56 
Questionthanks it was really helpful for me...!!! Pin
Member 1040181323-Nov-13 6:36
memberMember 1040181323-Nov-13 6:36 
QuestionExcellent! Pin
Dan Kudela12-Mar-13 1:08
memberDan Kudela12-Mar-13 1:08 
GeneralMy vote of 5 Pin
Dave Crump27-Oct-12 0:36
memberDave Crump27-Oct-12 0:36 
GeneralMy vote of 3 Pin
Rudolf Grauberger18-Sep-12 12:35
memberRudolf Grauberger18-Sep-12 12:35 
GeneralMy vote of 5 Pin
figgikim117-Sep-12 3:52
memberfiggikim117-Sep-12 3:52 
good article buddy!

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web03 | 2.8.150723.1 | Last Updated 17 Jul 2012
Article Copyright 2012 by Ravindra T C
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid