MySQLDriverCSS下载地址:http://sourceforge.net/projects/mysqldrivercs/
其使用方法与上一篇中MySQL官方的mysql-connector-net操作MySQL的使用方法大同小异
首先下载安装MySQLDriverCS后得到动态链接库文件:
![](https://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLicGcq5yMjZGZ5kDNhZDNxATLmZzNh1SM3Y2MtITMjlTL4ADZ2kjYkJzLcJTNxYzLcRzNwAzLcRnbl1GajFGd0F2LcRWYvxGc19CXt92YuUWelRXauwGZvw1LcpDc0RHaiojIsJye.jpg)
将MySQLDriverCS.dll添加到工程的引用中:
在上一篇中我们已经在MySQL数据库中建立了测试数据,所以直接编写C#代码:
1 static void Main(string[] args)
2 {
3 MySQLConnection conn = new MySQLConnection(new MySQLConnectionString("127.0.0.1","student", "root", "root",3306).AsString);
4 conn.Open();
5
6 MySQLCommand cmd = new MySQLCommand("select * from stuinfo", conn);
7 DbDataReader reader = cmd.ExecuteReader();
8 while (reader.Read())
9 {
10 Console.WriteLine(reader.GetString(0) + " " + reader.GetString(1) + " " + reader.GetString(2) + " " + reader.GetString(3));//读出查询的结果
11 }
12 Console.ReadKey();
13 reader.Close();
14 conn.Close();//关闭连接
15 }
执行结果:
数据被成功读出。
与上一篇中使用mysql-connector-net一样。
转载于:https://www.cnblogs.com/hzy3774/archive/2012/10/06/2712970.html