Connect to MySQL using ADO.Net

1.       Install .Net Connector for MySQL

http://dev.mysql.com/downloads/connector/net/

2.       Use this Connection String in config file

using EID.MySqlClient;

MySqlConnection oMySqlConn = new MySqlConnection();

oMySqlConn.ConnectionString = "Data Source=localhost;" +

                              "Database=mySQLDatabase;" +

                              "User ID=myUsername;" +

                              "Password=myPassword;" +

                              "Command Logging=false";

oMySqlConn.Open();

3.       Connect to Database via UI

http://dev.mysql.com/doc/refman/5.0/en/connector-net-visual-studio-making-a-connection.html