先下載和安裝MySQLDriverCS 
http://sourceforge.net/projects/mysqldrivercs/

在安裝文件夾下面找到MySQLDriver.dll，然后將MySQLDriver.dll添加引用到項目中

應(yīng)用程序配置文件：

App.config:

    <?xml version="1.0" encoding="utf-8" ?>  
    <configuration>  
      
      
      <connectionStrings>  
      
        <add name="server" connectionString="localhost"></add>  
        <add name="database" connectionString="housing"></add>  
        <add name="login" connectionString="root"></add>  
        <add name="password" connectionString="root"></add>  
      </connectionStrings>  
    </configuration>  

SqlHelper.cs內(nèi)容：

    using System;  
    using System.Collections.Generic;  
    using System.Linq;  
    using System.Text;  
    using System.Configuration;  
    using MySQLDriverCS;  
    using System.Data;  
      
    namespace Demo  
    {  
        class SqlHelper  
        {  
      
            private static string server = ConfigurationManager.ConnectionStrings["server"].ConnectionString;  
            private static string database = ConfigurationManager.ConnectionStrings["database"].ConnectionString;  
            private static string login = ConfigurationManager.ConnectionStrings["login"].ConnectionString;  
            private static string password = ConfigurationManager.ConnectionStrings["password"].ConnectionString;  
      
      
            public static int ExecuteNoQuery(String sql,MySQLParameter[] parameters)  
            {  
      
                using (MySQLConnection conn = new MySQLConnection(new MySQLConnectionString(server, database, login, password).AsString))  
                {  
      
                    conn.Open();  
      
                    
                    //防止亂碼  
                    MySQLCommand commn = new MySQLCommand("set names gb2312", conn);  
                    commn.ExecuteNonQuery();  
                    //連接語句和SQL  
                    MySQLCommand cmd = new MySQLCommand(sql, conn);  
                    //添加參數(shù)  
                    cmd.Parameters.AddRange( parameters);  
                    //返回執(zhí)行結(jié)果  
                    return cmd.ExecuteNonQuery();  
      
                }  
              
            }  
            public static object ExecuteScalar(String sql, MySQLParameter[] parameters)  
            {  
      
                using (MySQLConnection conn = new MySQLConnection(new MySQLConnectionString(server, database, login, password).AsString))  
                {  
      
                    conn.Open();  
                    //防止亂碼  
                    MySQLCommand commn = new MySQLCommand("set names gb2312", conn);  
                    commn.ExecuteNonQuery();  
      
                    MySQLCommand cmd = new MySQLCommand(sql, conn);  
                    //添加參數(shù)  
                    cmd.Parameters.AddRange(parameters);  
                      
                    return cmd.ExecuteNonQuery();  
                }  
              
            }  
      
            //較少的時候  
            public static DataTable ExecuteReaderEx(String sql, MySQLParameter[] parameters)  
            {  
      
                using (MySQLConnection conn = new MySQLConnection(new MySQLConnectionString(server, database, login, password).AsString))  
                {  
      
                    conn.Open();  
                    //防止亂碼  
                    MySQLCommand commn = new MySQLCommand("set names gb2312", conn);  
                    commn.ExecuteNonQuery();  
      
                    MySQLCommand cmd = new MySQLCommand(sql, conn);  
                    //添加參數(shù)  
                    cmd.Parameters.AddRange(parameters);  
      
                    MySQLDataAdapter mda = new MySQLDataAdapter(cmd);  
      
                    //查詢出的數(shù)據(jù)是存在DataTable中的，DataTable可以理解成為一個虛擬的表，DataTable中的一行為一條記錄，一列為一個數(shù)據(jù)庫字段    
      
      
                    DataTable dt = new DataTable();  
                    mda.Fill(dt);    
      
                    return dt;  
                }  
      
            }  
            public static DataSet ExecuteReaderEx2(String sql, MySQLParameter[] parameters)  
            {  
      
      
                using (MySQLConnection conn = new MySQLConnection(new MySQLConnectionString(server, database, login, password).AsString))  
                {  
      
                    conn.Open();  
                    //防止亂碼  
                    MySQLCommand commn = new MySQLCommand("set names gb2312", conn);  
                    commn.ExecuteNonQuery();  
      
                    MySQLCommand cmd = new MySQLCommand(sql, conn);  
                    //添加參數(shù)  
                    cmd.Parameters.AddRange(parameters);  
      
                    MySQLDataAdapter mda = new MySQLDataAdapter(cmd);  
      
                    //查詢出的數(shù)據(jù)是存在DataTable中的，DataTable可以理解成為一個虛擬的表，DataTable中的一行為一條記錄，一列為一個數(shù)據(jù)庫字段    
      
      
                    DataSet ds = new DataSet();  
                    mda.Fill(ds);  
                    return ds;  
                }  
      
            }  
      
      
      
      
        }  
    }  

使用示例：

    //sql語句  
                  string sql = "update tbl_sysuser set isActived=@isActived where id=@id";  
              
      
                  int number = SqlHelper.ExecuteNoQuery(sql, new MySQLParameter[]   
                  {  
                      new MySQLParameter("@isActived", "YES"),  
                      new MySQLParameter("@id", 2)  
                  });  
                   
      
                  Console.WriteLine("受影響的行數(shù):" + number);  

標簽： Mysql 數(shù)據(jù)庫

版權(quán)申明：本站文章部分自網(wǎng)絡(luò)，如有侵權(quán)，請聯(lián)系：west999com@outlook.com
特別注意：本站所有轉(zhuǎn)載文章言論不代表本站觀點！
本站所提供的圖片等素材，版權(quán)歸原作者所有，如需使用，請與原作者聯(lián)系。