How to Connect to MySQL Server?

Hi
I need to connect my 'Windows Form Application' to 'Remote MySQL Server'.

I have looked through many sites for the solution. At last I got a promising solution at

https://dev.mysql.com/downloads/connector/net/6.0.html

But on building the solution I the following in ErrorList

Error 40 The type or namespace name 'MySql' could not be found (are you missing a using directive or an assembly reference?) D:\DevOps\1\R3Connector\Handler.DB\Handler\MySQLManager.cs 6 7 Handler.DB

Error 41 The type or namespace name 'MySql' could not be found (are you missing a using directive or an assembly reference?) D:\DevOps\1\R3Connector\Handler.DB\Handler\MySQLManager.cs 7 7 Handler.DB

Error 42 The type or namespace name 'MySql' could not be found (are you missing a using directive or an assembly reference?) D:\DevOps\1\R3Connector\Handler.DB\Handler\MySQLManager.cs 8 7 Handler.DB

Error 43 The type or namespace name 'MySql' could not be found (are you missing a using directive or an assembly reference?) D:\DevOps\1\R3Connector\Handler.DB\Handler\MySQLManager.cs 9 7 Handler.DB

Error 44 The type or namespace name 'MySqlConnection' could not be found (are you missing a using directive or an assembly reference?) D:\DevOps\1\R3Connector\Handler.DB\Handler\MySQLManager.cs 27 29 Handler.DB

I can't understand why on build MySql namespace not detected where as it shows OK while coding and detects all the related classes and functions.

Somebody please help

3 Replies

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

Mageshwaran R6y ago
Hi,
Can you check with the below link:
https://www.a2hosting.in/kb/developer-corner/mysql/connect-to-mysql-from-the-command-line
Bharathi Raja8y ago
http://www.c-sharpcorner.com/UploadFile/brij_mcn/mysql-database-connectivity-with-Asp-Net/
Nanhe Siddique11y ago
hi habib
read this link

http://www.codeproject.com/Tips/355977/Csharp-ASP-NET-MySQL-Connection-Tutorial-with-MySQ

it may helps you