private void testConnectionToDatabaseButton_Click(object sender, EventArgs e)
{
try
{
string mySqlConnectionString = MySQLMethods.MakeMySqlConnectionString();
var conn = new MySqlConnection {
ConnectionString = mySqlConnectionString
};
conn.Open();
if (conn.Ping())
{
Console.WriteLine("You have successfully connected to your database!");
ConsoleWindow.WriteLine("You have successfully connected to your database!");
connectionDisplay.BackColor = Color.Chartreuse;
connectionDisplay.Text = ("Successfully Connected to Database.");
try
{
MySQLMethods.InitializeDatabases();
}
catch (Exception exception)
{
Console.WriteLine("Error Message: " + exception.Message);
ConsoleWindow.WriteLine("Error Message: " + exception.Message);
}
}
else
{
Console.WriteLine("You have unsuccessfully connected to your database!");
ConsoleWindow.WriteLine("You have unsuccessfully connected to your database!");
connectionDisplay.BackColor = Color.Red;
connectionDisplay.Text = ("Connection to Database Failed.");
}
conn.Close();
}
catch (MySqlException ex)
{
connectionDisplay.BackColor = Color.Red;
connectionDisplay.Text = ("Connection to Database Failed.");
Console.WriteLine("Error Code: " + ex.ErrorCode);
Console.WriteLine("Error Message " + ex.Message);
ConsoleWindow.WriteLine("Error Code: " + ex.ErrorCode);
ConsoleWindow.WriteLine("Error Message " + ex.Message);
}
}
private void initializeDatabaseToolStripMenuItem_Click(object sender, EventArgs e)
{
MySQLMethods.InitializeDatabases();
}
