connecting with MYSQl using C#

Question

0.00/5 (No votes)

See more:

hi
I am creating a desktop application using C# in .net 3.5 and MySql as database. I am very new to MySql and do not know how to connect .net application with MySql database.

Please reply me as soon as possible.

Thanks in advance.

Posted 2-Mar-11 5:35am

irfankhan200

Updated 2-Mar-11 11:52am

thatraja

v4

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Dylan Morley · Answer 1 · 2011-03-02T05:42:00

Solution 1

Download the .Net provider for MySQL

http://www.mysql.com/products/connector/[^]

Once downloaded, set a reference to the dll in your project

Create a connection string for the provider & open your connection!

Connection Strings
http://www.connectionstrings.com/mysql#p28[^]

Create Connection Samples
http://bitdaddys.com/MySQL-ConnectorNet.html[^]

Posted 2-Mar-11 5:42am

Dylan Morley

Updated 2-Mar-11 5:44am

v2

Comments

Sandeep Mewara 2-Mar-11 13:47pm

Good answer. 5!

Yusuf · Answer 2 · 2011-03-02T05:43:00

Solution 2

Good you asked. There are plenty of resources out there. For starters let us look at this CP article
Connecting to MySQL database from your .NET applications.[^]

Then of course there is this http://dev.mysql.com/tech-resources/articles/dotnet/index.html[^], and yes, don't forget this valuable tool [^]as well.

Posted 2-Mar-11 5:43am

Yusuf

Comments

Sandeep Mewara 2-Mar-11 13:47pm

Good answer. 5!