marcandreher / mysqlexplorer Goto Github PK

void CloseConnection()
{
    if (sqlCon != null)
    {
        try
        {
            sqlCon.Close();
        }
        catch { }
    }
}

public bool connect(string server, string database, string username, string password)
{
    try
    {
        string conString = $"SERVER=${server};DATABASE={database};UID={username};PASSWORD={password};";
        CloseConnection();
        sqlCon = new MySqlConnection(conString);
        sqlCon.Open();
        return true;
    }
    catch (Exception ex)
    {
        errorMessage = ex.Message;
        return false;
    }
}

private void Form1_FormClosing(object sender, FormClosingEventArgs e)
{
    CloseConnection();
    Application.Exit();
}