C# ASP.NET MySQL Connection Tutorial with MySQL Connector

In order to connect to MySQL Server with .NET in C# or ASP.NET:

• You need to download MySQL Connector/Net .
• After you add a reference to your project, it is probably in C:\Program Files\MySQL\MySQL Connector Net 5.0.7\Binaries\.NET 2.0 folder, add the MySql.Data.dll file as a reference.
• Make your connection string, the following code will shows a standard MySQL connection string.

using MySql.Data.MySqlClient;
public static string GetConnectionString()
{
  string connStr = String.Format("server={0};user id={1}; password={2};" + 
    "database=yourdb; pooling=false", "yourserver",
    "youruser", "yourpass");

  return connStr;
}

• Then create an instance from MySql.Data.MySqlClient.MySqlConnection as shown below.

MySql.Data.MySqlClient.MySqlConnection mycon = 
  new MySqlConnection( GetConnectionString());

• Then try to open the MySqlConnection.

if(mycon .State != ConnectionState.Open)
try
{
  mycon .Open();
}
catch (MySqlException ex)
{
  throw (ex);
}

So simple as you see, It is always better to do this in data access layer also called DAL.