Change the your password value to your real database password value.
your_ConnectionString
with your database information.your_ConnectionString
value:
NOTE: If your MySql database was created with the Allow Direct Database Access enabled, you can connect to the database from your development computer. If you did not enable Allow Direct Database Access, your MySql is in a secure environment and you cannot connect to the database from your development computer. A connection can only be successful when your code is deployed to the hosting Website.
MySql.Data.MySqlClient.MySqlConnection mySqlConnection = new
MySql.Data.MySqlClient.MySqlConnection();
mySqlConnection.ConnectionString = “your_ConnectionString”;
try
{
mySqlConnection.Open();
switch (mySqlConnection.State)
{
case System.Data.ConnectionState.Open:
// Connection has been made
break;
case System.Data.ConnectionState.Closed:
// Connection could not be made, throw an error
throw new Exception("The database connection state is Closed");
break;
default:
// Connection is actively doing something else
break;
}
// Place Your Code Here to Process Data //
}
catch (MySql.Data.MySqlClient.MySqlException mySqlException)
{
// Use the mySqlException object to handle specific MySql errors
}
catch (Exception exception)
{
// Use the exception object to handle all other non-MySql specific errors
}
finally
{
// Make sure to only close connections that are not in a closed state
if (mySqlConnection.State != System.Data.ConnectionState.Closed)
{
// Close the connection as a good Garbage Collecting practice
mySqlConnection.Close();
}
}