1、下载 mysql-connector-net包；

2、引用 mysql-connector-net包中的MySql.Data.dll；

3、程序源代码：

 
  
  1. using System; 
  2. using System.Collections.Generic; 
  3. using System.Linq; 
  4. using System.Text; 
  5. using System.Data; 
  6. using MySql.Data.MySqlClient; 
  7.  
  8. namespace Document_convert.DB 
  9. { 
  10.     class MYSQL 
  11.     { 
  12.         #region  建立MySql数据库连接 
  13.         /// <summary> 
  14.         /// 建立数据库连接. 
  15.         /// </summary> 
  16.         /// <returns>返回MySqlConnection对象</returns> 
  17.         public MySqlConnection getmysqlcon() 
  18.         { 
  19.             string M_str_sqlcon = "server=localhost;user id=root;password=phpwind.net;database=phpcmsv9;charset=utf8"; //根据自己的设置 
  20.             MySqlConnection myCon = new MySqlConnection(M_str_sqlcon); 
  21.             return myCon; 
  22.         } 
  23.         #endregion 
  24.         //建立数据库连接字符串 
  25.         private static string connectionString = "Server=localhost;Uid=root;Pwd=phpwind.net;Database=phpcmsv9;Port=3306;charset=utf8"; 
  26.         //建立查询，返回DataSet数据集 
  27.         public static DataSet Query(string SQLString) 
  28.         { 
  29.             using (MySqlConnection connection = new MySqlConnection(connectionString)) 
  30.             { 
  31.                 DataSet ds = new DataSet(); 
  32.                 try 
  33.                 { 
  34.                     connection.Open(); 
  35.                     MySqlDataAdapter command = new MySqlDataAdapter(SQLString, connection); 
  36.                     command.Fill(ds); 
  37.                 } 
  38.                 catch (System.Data.SqlClient.SqlException ex) 
  39.                 { 
  40.                     throw new Exception(ex.Message); 
  41.                 } 
  42.                 finally 
  43.                 { 
  44.                     connection.Close(); 
  45.                 } 
  46.                 return ds; 
  47.             } 
  48.         } 
  49.         //建立查询，返回受影响的行数 
  50.         public static int ExecuteSql(string SQLString) 
  51.         { 
  52.             using (MySqlConnection connection = new MySqlConnection(connectionString)) 
  53.             { 
  54.                 using (MySqlCommand cmd = new MySqlCommand(SQLString, connection)) 
  55.                 { 
  56.                     try 
  57.                     { 
  58.                         connection.Open(); 
  59.                         int rows = cmd.ExecuteNonQuery(); 
  60.                         return rows; 
  61.                     } 
  62.                     catch (System.Data.SqlClient.SqlException e) 
  63.                     { 
  64.                         connection.Close(); 
  65.                         throw e; 
  66.                     } 
  67.                     finally 
  68.                     { 
  69.                         cmd.Dispose(); 
  70.                         connection.Close(); 
  71.                     } 
  72.                 } 
  73.             } 
  74.         } 
  75.         //建立数组查询arrSql=[sqlstr1,sqlstr2,sqlstr3],返回受影响的行数 
  76.         public static int ExecuteSql(string[] arrSql) 
  77.         { 
  78.             using (MySqlConnection connection = new MySqlConnection(connectionString)) 
  79.             { 
  80.  
  81.                 try 
  82.                 { 
  83.                     connection.Open(); 
  84.                     //MySqlCommand cmdEncoding = new MySqlCommand(SET_ENCODING, connection); 
  85.                     //cmdEncoding.ExecuteNonQuery(); 
  86.                     int rows = 0; 
  87.                     foreach (string strN in arrSql) 
  88.                     { 
  89.                         using (MySqlCommand cmd = new MySqlCommand(strN, connection)) 
  90.                         { 
  91.                             rows += cmd.ExecuteNonQuery(); 
  92.                         } 
  93.                     } 
  94.                     return rows; 
  95.                 } 
  96.                 catch (System.Data.SqlClient.SqlException e) 
  97.                 { 
  98.                     connection.Close(); 
  99.                     throw e; 
  100.                 } 
  101.                 finally 
  102.                 { 
  103.                     connection.Close(); 
  104.                 } 
  105.             } 
  106.         } 
  107.     } 
  108. }