25 November 2008

C# ASP.NET MySQL Connection Tutorial with MySQL Connector

In order to connect to MySQL Server with .NET in C# or ASP.NET does not matter actually,
  • 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 MySQL connection.
  • 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.
Connect Mysql in C# and ASP.NET.

10 comments:

roncansan said...

Thanks

moonshine said...

thanks for wonderful blog

moonshine said...

thanks for wonderful blog

Anonymous said...

You are so excellent and your this post is so mind blowing!

because i was search for connection string which connects mysql databse with asp.net!

Speaker-to-Animals said...

All good, except there is no MySqlException in package MySql.Data.MySqlClient.

Amol said...

Thanks dude... :)

Amol said...

Thanks dude

Godly Mathew said...

Thanks a Lot

Anonymous said...

Very good job....

wcdeich4 said...

I'm using Microsoft Visual Web Developer 2008 Express Edition & I keep getting an error at "using MySql.Data.MySqlClient;" - do I need to add something to the dependencies ?