《C#-连接MYSQL数据库的3种方法及示例》由会员分享,可在线阅读,更多相关《C#-连接MYSQL数据库的3种方法及示例(16页珍藏版)》请在金锄头文库上搜索。
1、C# 连接MYSQL数据库的方法与示例连接MYSQL数据库的方法与示例 方法一:using MySql.Data using MySql.Data.MySqlClient; 其他操作跟SQL是差不多,无非就是前缀变成MySql了. 补充: 下面是连接字符串,供参考. MySqlConnection con = new MySql.Data.MySqlClient.MySqlConnection; con.Open; MySqlCommand cmd = new MySqlCommand; cmd.Connection = con; 使用MYSQL推出的MySQL Connector/Net i
2、s an ADO.NET driver for MySQL 该组件为MYSQL为ADO.NET访问MYSQL数据库设计的.NET访问组件. 安装完成该组件后,引用命名空间MySql.Data.MySqlClient; 使用命令行编译时:csc /r:MySql.Data.dll test.cs 方法二: 通过ODBC访问MYSQL数据库 访问前要先下载两个组件:和MYSQL的ODBC驱动MySQL Connector/ODBC driver目前为3.51版 安装完成后,即可通过ODBC访问MYSQL数据库 方法三: 使用CoreLab推出的MYSQL访问组件,面向.NET 安装完成后,引用命名
3、空间:CoreLab.MySql; 使用命令编译时:csc /r:CoreLab.MySql.dll test.cs 以下为访问MYSQL数据库实例 编译指令:csc /r:CoreLab.MySql.dll /r:MySql.Data.dll test.cs using System; using System.Net; using System.Text; using CoreLab.MySql; using System.Data.Odbc; using MySql.Data.MySqlClient; class ConnectMySql public void Connect_Core
4、Lab string constr = User Id=root;Host=localhost;Database=qing;password=qing; MySqlConnection mycn = new MySqlConnection; mycn.Open; MySqlCommand mycm = new MySqlCommand; MySqlDataReader msdr = mycm.ExecuteReader; whilemsdr.Read if Console.WriteLinemsdr.GetString; msdr.Close; mycn.Close; public void
5、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=qing; + OPTION=3; OdbcConnection MyConn = new OdbcConnection; MyConn.Open; OdbcCommand mycm = new OdbcCommand; OdbcDataReader
6、 msdr = mycm.ExecuteReader; whilemsdr.Read if Console.WriteLinemsdr.GetString; msdr.Close; MyConn.Close; public void Connect_Net string myConnectionString = Database=test;Data Source=localhost;User Id=root;Password=qing; MySqlConnection mycn = new MySqlConnection; mycn.Open; MySqlCommand mycm = new
7、MySqlCommand; MySqlDataReader msdr = mycm.ExecuteReader; whilemsdr.Read if Console.WriteLinemsdr.GetString; msdr.Close; mycn.Close; public static void Main ConnectMySql ms = new ConnectMySql; ms.Connect_CoreLab; ms.Connect_Odbc; Connect_Net; 1、用MySQLDriverCS连接MySQL数据库先下载和安装MySQLDriverCS,地址::/ MySQLD
8、riverCS-n-EasyQueryTools-using System;using System.Collections.Generic;using System ponentModel;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 Fo
9、rm1 InitializeComponent; private void Form1_Load MySQLConnection conn = null; conn = new MySQLConnectionnew MySQLConnectionString.AsString; conn.Open; MySQLCommand commn = new MySQLCommand; commn.ExecuteNonQuery; string sql = select * from exchange ; MySQLDataAdapter mda = new MySQLDataAdapter; Data
10、Set ds = new DataSet; mda.Fill; this.dataGrid1.DataSource = ds.Tablestable1; conn.Close; 2、通过ODBC访问mysql数据库:1. 安装Microsoft ODBC.net:我安装的是mysql-connector-odbc-win32.msi2. 安装MDAC 2.7或者更高版本:我安装的是mdac_typ.exe 2.7简体中文版3. 安装MySQL的ODBC驱动程序:我安装的是 odbc_net.msi4. 管理工具 - 数据源ODBC 配置DSN5. 解决方案管理中添加引用 Microsoft.D
11、ata.Odbc.dll6. 代码中增加引用 using Microsoft.Data.Odbc;using System;using System.Collections.Generic;using System ponentModel;using System.Drawing;using System.Linq; /vs2005好像没有这个命名空间,在c#2008下测试自动生成的using System.Text;using System.Windows.Forms;using Microsoft.Data.Odbc;namespace mysql public partial class Form1 : Form public Form1 InitializeComponent; private void Form1_Load string MyConString = DRIVER=MySQL ODBC 3.51 Driver; + SERVER=localhost; + DATABASE=inv; + UID=root; + PASSWORD=831025; +