c#连接MySQL数据库的三种方式

1、用MySQLDriverCS连接MySQL数据库

先下载和安装MySQLDriverCS，地址：

http://sourceforge.net/projects/mysqldrivercs/

在安装文件夹下面找到MySQLDriver.dll，然后将MySQLDriver.dll添加引用到项目中

注：我下载的是版本是 MySQLDriverCS-n-EasyQueryTools-4.0.1-DotNet2.0.exe



using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Data.Odbc;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using MySQLDriverCS;





namespace mysql

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }



        private void Form1_Load(object sender, EventArgs e)

        {



            MySQLConnection conn = null;

            conn = new MySQLConnection(new MySQLConnectionString("主机", "数据库名", "帐号", "密码").AsString);

            conn.Open();



            MySQLCommand commn = new MySQLCommand("set names gb2312", conn);

            commn.ExecuteNonQuery();



            string sql = "select * from exchange ";

            MySQLDataAdapter mda = new MySQLDataAdapter(sql, conn);



            DataSet ds = new DataSet();

            mda.Fill(ds, "table1");



            this.dataGrid1.DataSource = ds.Tables["table1"];

            conn.Close();



        }



  

    }

}



2、通过ODBC访问mysql数据库：


1.安装Microsoft ODBC.net：我安装的是mysql-connector-odbc-5.1.6-win32.msi


2. 管理工具 -> 数据源ODBC –>配置DSN…
配置DSN请参考我的文章：c#通过ODBC连接mysql数据库并用到NBear

3. 代码中增加引用 using System.Data.Odbc;



using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Drawing;

using System.Linq;   //vs2005好像没有这个命名空间，在c#2008下测试自动生成的

using System.Text;

using System.Windows.Forms;

using System.Data.Odbc;



namespace mysql

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }



        private void Form1_Load(object sender, EventArgs e)

        {



       string MyConString = "Driver={MySQL ODBC 5.1 Driver};

server=127.0.0.1;uid=root;password=123;database=dvs_web;port=3306";

 
          OdbcConnection MyConn=new OdbcConnection(MyConString);
            MyConn.Open();
        
OdbcCommand mycm = new OdbcCommand("select * from user",MyConn);
       OdbcDataReader msdr = mycm.ExecuteReader();
       
       while(msdr.Read())
         {
            if (msdr.HasRows)
            {
               string res = msdr.GetString(0);
               Console.WriteLine(msdr.GetString(0));

            }
         }
           msdr.Close();
           MyConn.Close();

      }
}
}

3.通过MySQL Connector Net访问mysql数据库：
a/首先安装MySQL Connector Net 6.0.2
b/在程序中应用安装程序中的MySql.Data.dll文件
c/
using MySql.Data.MySqlClient;
MySqlConnectionStringBuilder connBuilder = new MySqlConnectionStringBuilder();
        connBuilder.Add("Database", "dvs_web");
        connBuilder.Add("Data Source", "localhost");
        connBuilder.Add("User Id", "root");
        connBuilder.Add("Password", "123");

        MySqlConnection connection = new MySqlConnection(connBuilder.ConnectionString);
        MySqlCommand cmd = connection.CreateCommand();
      
        connection.Open();
        string sql = "select * from user ";

      
        MySqlDataAdapter mda = new MySqlDataAdapter(sql, connection);


        DataSet ds = new DataSet();

        mda.Fill(ds, "table1");


        connection.Close();