MySqlConnection HELP!

Steve

16y16.9kSQL

Hi, I am getting very very annoyed trying to find the refrence for MySqlConnection. I am trying to connect to my database, but everytime I use MySqlConnection I getting the following error:

The type or namespace name 'MySqlConnection' could not be found (are you missing a using directive or an assembly reference?) C:\Documents and Settings\NAME\Local Settings\Application Data\Temporary Projects\WindowsFormsApplication1\Form1.cs 25 13 WindowsFormsApplication1

Yes I know that I am missing a refrence but I honestly have NO CLUE what I ned to correct this error. Thanks for any help.

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shahan Ayyub15y ago
@ Sam

I should have consider your seniority and respect your opinion. I will take care of this from next time.

Thanks.
Sam Hobbs15y ago
I believe you, Shahan. I do appreciate that you are trying to help and you do help. I just want to ensure that Steve and other members get the best possible help and I apologize if I try too hard.
Shahan Ayyub15y ago
@Sam

no problem. My aim is not to hurt you. we are the part of same platform.
Sam Hobbs15y ago
I am sorry Shahan that I did not read closer.

In your first message, you said to use "using System.Data.SqlClient;", correct? That sure looked incorrect to me.

In your second message, you said to use SqlConnection instead of MySqlConnection, correct? If my understanding is incorrect, then I apoloigize for misunderstanding.
Shahan Ayyub15y ago
@Sam

I said this:
>>>there is no MySqlConnection class that MSDN and .Net offers

In a sense that I was guiding @Steve for "Add Reference" so if its a 3rd party .dll it will be available to him only(which he didn't declare yet) not comes with .net library.
Shahan Ayyub15y ago
@Sam

I have already posted the same link if you have been read my comment carefully and I have provided the solution for that also.
Sam Hobbs15y ago
Steve: What are you looking at that shows use of MySqlConnection? That article or whatever should tell you where it is. If not, then search the internet as in:

http://www.bing.com/search?q=MySqlConnection&go=&form=QBLH&qs=n&sk=&sc=6-15

Some of the results of that are:
Note that you might need to download the relevant library to get the MySqlConnection class and related software.
Sam Hobbs15y ago
Shahan: C# and the Common Language Infrastructure (CLI) are designed to be extensible, so saying "there is no MySqlConnection class that MSDN and .Net offers" is not helpful when someting does exist from somewhere else. See MySqlConnection Class for the somewhere else. Note that if you are not familiar with the CLI, .Net is the Windows implementation of it.
Shahan Ayyub15y ago
MoreOver there is no MySqlConnection class that MSDN and .Net offers directly used SqlConnection instead and appropriate connectionstring for that.

If you have used some other assembly like this one:
http://www.devart.com/dotconnect/mysql/docs/Devart.Data.MySql~Devart.Data.MySql.MySqlConnection_members.html

then

"Add Reference" from "Solution Explorer" and then add refernece of Devart.Data.MySql.dll

then in code/Form1.cs

right Click on the word "MySqlConnection", in the menu find Resolve and click on the first item.(if casing of MySqlConnection will be correct you will get item)

I hope it will help you.
Shahan Ayyub15y ago
Hi!

Are you sure you have this line at start of "Form1.cs"

using System.Data.SqlClient;
If yes then please verify in "solution explorer" under "References" folder, that it should include "System.Data"
Gomathi Palaniswamy16y ago
Hi Friend,

First create the folder with in your application and give the sqlconnection like

sqlconnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFileName="+Application.StartupPath.Remove(Application.StartupPath.Length-10,10)+@"\db\PAM.mdf;Integrated Security=True;User Instance=True");

by the above maintain the database any where