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();