当我失去互联网时，C# MySQL 连接失败

Question

我正在运行一个 C# 程序，该程序连接到其自己网络上的本地 MySQL 服务器。一切正常，直到我失去互联网，然后 C# 将无法连接到服务器，尽管有 IP 引用(请参见下面的代码)。

 public bool IsConnect()
    {
        bool result = true;
        if (Connection == null)
        {
            if (String.IsNullOrEmpty(databaseName))
                result = false;
            string connstring = string.Format("Server=192.168.0.254; database={0}; UID=show; password=", "");

            try
            {
                connection = new MySqlConnection(connstring);
                connection.Open();
                result = true;
            }
            catch (MySql.Data.MySqlClient.MySqlException ex)
            {
                switch (ex.Number)
                {
                    case 0:
                        // MessageBox.Show("Cannot connect to server.  Contact administrator");
                        break;
                    case 1045:
                        // MessageBox.Show("Invalid username/password, please try again");
                        break;
                }
            }

        }

        return result;
    }

Answer 1

您没有检查您的数据库名称。

public bool IsConnect()
    {
        bool result = true;
        if (Connection == null)
        {
            if (String.IsNullOrEmpty(databaseName))
                result = false;
            string connstring = string.Format("Server=192.168.0.254; database={0}; UID=show; password=", "");

            try
            {
            //Database name is not empty 
            if(result)
                {
                connection = new MySqlConnection(connstring);
                connection.Open();
                result = true;
                }
            }
            catch (MySql.Data.MySqlClient.MySqlException ex)
            {
                switch (ex.Number)
                {
                    case 0:
                        // MessageBox.Show("Cannot connect to server.  Contact administrator");
                        break;
                    case 1045:
                        // MessageBox.Show("Invalid username/password, please try again");
                        break;
                }
            }

        }

        return result;
    }