WPF C# 操作Mysql数据库

一、创建Mysql数据库

二、链接Mysql数据库函数、填充Mysql数据库函数、更新Mysql数据库函数

        public static String 任务Path = @"\\000.000.0.00\Record.mdb";
        public static String OLEVer = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source= ";
 /*链接Mysql数据库*/
        public static string GetRDSSqlconStr(string 库)
        {
            return string.Format("server=123（数据库网络地址，端口）;UID=123（数据库用户名）;password=123（数据库密码）;database={0};", 库);
        }

 /*填充Mysql*/
       public static DataTable FillDTFromMysql(String SQLStr, String tbname, String Path)
        {
            DataTable dt = new DataTable(tbname);
            try
            {
                using (MySqlConnection Connection = new MySqlConnection(Path))
                {
                    Connection.Open();
                    using (MySqlDataAdapter DSAdapter = new MySqlDataAdapter(SQLStr, Connection))
                    {
                        DSAdapter.Fill(dt);
                    };
                    Connection.Close();
                };
                return dt;
            }
            catch(Exception ex)
            {
                //Debug.WriteLine("无法访问(获取)SQL库:"+ex);
                MessageBox.Show("无法访问(获取)SQL库:" + ex);
                return null;
            }
        }

 /*更新Mysql*/
       public static bool UpDataDBMysql(String SQLStr, String Path)
        {
            try
            {
                using (MySqlConnection Connection = new MySqlConnection(Path))
                {
                    Connection.Open();
                    using (MySqlCommand MyCommand = new MySqlCommand(SQLStr, Connection))
                    {
                        MyCommand.ExecuteNonQuery();// '返回受影响行数                  
                    };
                    Connection.Close();
                };            
                return true;
            }
            catch(Exception ex)
            {               
                MessageBox.Show("无法访问(更新)SQL库:" + ex);
                return false;
            }
        }

三、使用函数

  return FillDTFromMysql(SQL, "Table", GetRDSSqlconStr("表1"));

  UpDataDBMysql(SQL, GetRDSSqlconStr("表1"));