C# 连接MYSQL数据库的3种方法及示例

1、c#连接MYSQL数据库的方法及示例连接MYSQL数据库的方法及示例方法一：using MySql.Datausing MySql.Data.MySqlClient;其他操作跟SQL是差不多，无非就是前缀变成MySql 了.补充：下面是连接字符串，供参考.MySqlConnection con = newMySql.Data.MySqlClient.MySqlConnection(HDatabase=,testdb;DataSource=,localhost;User ld=,db,;Password=,apple,;charset=,utf8,H);con.Open();MySqlCommand cmd = new MySqlCommand();cmd.Connection = con;使用 MYSQL 推出的 MySQL Connector/Net is an ADO.NET driver for MySQL该组件为MYSQL为ADO.NET访问MYSQL数据库设计的.NET访问组件。安装完成该组件后，引用命名空间MySql.Data.MySqlClient;使用命令行编译时：es

2、c /:MySql.Data.dll test.cs方法二：通过ODBC访问MYSQL数据库访问前要先下载两个组件：和MYSQL的ODBC驱动(MySQL Connector/ODBC(MyODBC) driver)目前为 3.51 版安装完成后，即可通过ODBC访问MYSQL数据库方法三：使用CoreLab推出的MYSQL访问组件，面向.NET安装完成后，引用命名空间：CoreLab.MySql;使用命令编译时：esc /:CoreLab.MySql.dll test.cs以下为访问MYSQL数据库实例编译指令：esc /r:CoreLab.MySql.dll /r:MySql.Data.dll test.csusing System;using System.Net;using System.Text;using CoreLab.MySql;using System.Data.Odbe;using MySql.Data.MySqlClient;class ConnectMySqlpublic void Connect_CoreLab()string constr = User Id

3、=root;Host=localhost;Database=qing;password=qing;MySqlConnection mycn = new MySqlConnection(constr);mycn.Open();MySqlCommand mycm = new MySqlCommand(select * from shop”,mycn);MySqlDataReader msdr = mycm.ExecuteReader();while(msdr.Read()if (msdr.HasRows)Console. WriteLine(msdr.GetString(O);msdr.Close();mycn.Close();public void Connect_Odbc()/string MyConString =DSN=MySQL;UID=root;PWD=qing;string MyConString = DRIVER=MySQL ODBC 3.51 Driver; +SERVER=localhost; +”DATABASE=test;” +UID=root; +PASSWORD

4、=qlng; +OPTION = 3;OdbcConnection MyConn = new OdbcConnection(MyConString);MyConn.Open();OdbcCommand mycm = new OdbcCommand(Hselect * from hello”,MyConn);OdbcDataReader msdr = mycm.ExecuteReader();while(msdr.Read()if (msdr.HasRows)Console. WriteLine(msdr.GetString(O);msdr.Close();MyConn.Close();public void Connect_Net()string myConnectionString = Database=test;Data Source=localhost;llser Id = root; Password=qing;MySqlConnection mycn = new MySqlConnection(myConnectionString);mycn.Open();MySqlComm

5、and mycm = new MySqlCommand(Hselect * from hello”,mycn);MySqlDataReader msdr = mycm.ExecuteReader();while(msdr.Read()if (msdr.HasRows)Console. WriteLine(msdr.GetString(O);msdr.Close();mycn.Close();public static void Main()ConnectMySql ms = new ConnectMySql();ms.Connect_CoreLab();ms.Connect_Odbc();Connect_Net();)1、用 MySQLDnverCS 连接 MySQL 数据库先卜载和安装MySQLDnverCS,地址：http:/ MySQLDriverCS-n-EasQueryTools-4.0.1-DotNet2-0.exe using System;using System.Collections.Generic;using System.ComponentModel;using

6、 System.Data;using System.Data.Odbe;using System.Drawing;using System.Linq:using System.Text;using System.Wiiidows.Fornis;using MySQLDrivei CS;namespace mysqlpublic partial class Form! : Formpublic Form 1()IiiitializeComponent();private void Forml_Load(object sender, EventArgs e)My S QLC oimection conn = null;coim = new MySQLCoimection(new MySQLCoiinectionStnng(Hlocalliost, HinvM, “root”，H831025n).AsStnng);conn. Open。；MySQLConunaiid conmm = new MySQLCoiniuand(Hset names gb2312”，comi);conmm.Execu

7、teNonQueiyO；string sql = select * from exchangeMySQLDataAdapter mda = new MySQLDataAdapter(sql, comi);DataSet ds = new DataSetQ;mda.Fill(ds, ntablelH);tlus.dataGnd 1 .DataSouice = ds.Tables,rtable 1;conn. Close。；2、通过ODBC访问mysql数据库:参考：http:www.micros0ft.coni/chinaJcommunity/Coh】mn/63.mspx1. 安装 Microsoft ODBC.net：我安装的是 mysql-comiectoi-odbc-3.51.22-win32.nisi2. 安装MDAC 2.7或者更高版本：我安装的是mdac_typ.exe 2.7简体中文版3. 安装MySQL的ODBC驱动程序：我安装的是odbc_net.nisi4. 管理工具- 数据源ODBC -配置DSN5. 解决方案管理中添加引用 Microsoft.Data.Odbc.

8、dll( 1.0.3300)6. 代码中增加引用 using Microsoft.Data.Odbc;using System;using System.Collections.Generic;using System.ComponentModel;using System.Drawing;using System.Linq; /vs2005好像没有这个命名空间，在c#2008 F测试自动生成的using System.Text;using System.Wiiidows.Foinis;using Microsoft.Data.Odbc;public partial class Forml : Formpublic Form 1()IiiitializeCompoiient();private void Forml_Load(object sender, EventArgs e)string MyConStriiig = ”DRTVER=MySQL ODBC 3.51 Driver)+HSERVER=localliost;H +HDATABASE=mv;H +“UID=root;” +,PASSWORD=831025;n +”OPTION=3”；OdbcComiection MyComiection = new OdbcComiection(MyConStimg);MyC omiection.Open();Console.WriteLme(Hii success, connected successfiillystring queiy = insert into test values( hello”，lucas”，OdbcConunand cmd = new OdbcConiiuand(queiy MyComiection);处理异常：插入重复记录有异常trycmd.ExecuteNonQueryQ;catch(Exception ex)Console.WriteLme(Mrecoid duplicate.); filially (cmd.Dispose();俨*用 read 方法读数据到 textbox*

《C# 连接MYSQL数据库的3种方法及示例》由会员壹****1分享，可在线阅读，更多相关《C# 连接MYSQL数据库的3种方法及示例》请在金锄头文库上搜索。