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

....
/NUMPAGES25
HYPERLINK"://blog.donews/monoer/archive/2006/06/06/904285.aspx"C#连接MYSQL数据库的方法与示例
连接MYSQL数据库的方法与示例方法一：

usingMySql.DatausingMySql.Data.MySqlClient;其他操作跟SQL是差不多,无非就是前缀变成MySql了.补充:下面是连接字符串,供参考.MySqlConnectioncon=newMySql.Data.MySqlClient.MySqlConnection("Database='testdb';DataSource='localhost';UserId='db';Password='apple';charset='utf8'");con.Open();MySqlCommandcmd=newMySqlCommand();cmd.Connection=con;使用MYSQL推出的MySQLConnector/NetisanADO.NETdriverforMySQL该组件为MYSQL为ADO.NET访问MYSQL数据库设计的.NET访问组件。安装完成该组件后，引用命名空间MySql.Data.MySqlClient;使用命令行编译时：csc/r:MySql.Data.dlltest.cs方法二：通过ODBC访问MYSQL数据库访问前要先下载两个组件：odbc.net和MYSQL的ODBC驱动(MySQLConnector/ODBC(MyODBC)driver)目前为3.51版安装完成后，即可通过ODBC访问MYSQL数据库方法三：使用CoreLab推出的MYSQL访问组件，面向.NET安装完成后，引用命名空间：CoreLab.MySql;使用命令编译时：csc/r:CoreLab.MySql.dlltest.cs以下为访问MYSQL数据库实例编译指令：csc/r:CoreLab.MySql.dll/r:MySql.Data.dlltest.csusingSystem;usingSystem.Net;usingSystem.Text;usingCoreLab.MySql;usingSystem.Data.Odbc;usingMySql.Data.MySqlClient;classConnectMySql{publicvoidConnect_CoreLab(){stringconstr="UserId=root;Host=localhost;Database=qing;password=qing";MySqlConnectionmycn=newMySqlConnection(constr);mycn.Open();MySqlCommandmycm=newMySqlCommand("select*fromshop",mycn);MySqlDataReadermsdr=mycm.ExecuteReader();while(msdr.Read()){if(msdr.HasRows){Console.WriteLine(msdr.GetString(0));}}msdr.Close();mycn.Close();}publicvoidConnect_Odbc(){//stringMyConString="DSN=MySQL;UID=root;PWD=qing";stringMyConString="DRIVER={MySQLODBC3.51Driver};"+"SERVER=localhost;"+"DATABASE=test;"+"UID=root;"+"PASSWORD=qing;"+"OPTION=3";OdbcConnectionMyConn=newOdbcConnection(MyConString);MyConn.Open();OdbcCommandmycm=newOdbcCommand("select*fromhello",MyConn);OdbcDataReadermsdr=mycm.ExecuteReader();while(msdr.Read()){if(msdr.HasRows){Console.WriteLine(msdr.GetString(0));}}msdr.Close();MyConn.Close();}publicvoidConnect_Net(){stringmyConnectionString="Database=test;DataSource=localhost;UserId=root;Password=qing";MySqlConnectionmycn=newMySqlConnection(myConnectionS