C# 连接MySQL

C# 连接MySQL其实也是比较方便的。

• 引用MySql.Data.dll到工程中。
• 像操作SQL Server一样连接MysQL。

namespace ConnectionMySql
{
    class Program
    {
        static string strMySqlConnectionString = "Server=localhost; Database=test; Uid=root; Pwd=123456"; 

        static void Main(string[] args)
        {
            Console.WriteLine(string.Format("Connect to MySql {0}", ConnectionMySql() ? "Success" : "fail"));
            Console.ReadKey();
        }

        private static bool ConnectionMySql()
        {
            MySqlConnection conn = new MySqlConnection(strMySqlConnectionString);
            try
            {
                conn.Open();
                if (!conn.State.Equals(ConnectionState.Open))
                {
                    return false;
                }

                MySqlCommand cmd = new MySqlCommand(" SELECT * FROM admin ", conn);
                MySqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                while (reader.Read())
                {
                    Console.WriteLine("{0},{1},{2},{3},{4},{5}", reader["id"], reader["adminaccount"], reader["adminpassword"], reader["adminname"], reader["validstatus"], reader["remarks"]);
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }
            finally
            {
                //conn.Close();
            }
            return true;
        }

    }
}

资源在于分享，技术在于交流。

资源下载

点击打开链接