asp.net2.0连接mysql数据库

1,确认安装mysql(本人用的5.1版本)

2,下载mysql-connector-net-5.2.3并安装,地址:http://dev.mysql.com/downloads/connector/net/5.2.html

  里面集成了MySQL Visual Studio Plugin,而mysql-connector-net-5.0不集成.

3,到这步为止,已经可以用vs菜单里"工具->连接到数据库"进行mysql连接测试了.

4,到C:/Program Files/MySQL/MySQL Connector Net 5.2.3/Binaries/.NET 2.0目录下,复制MySql.Data.dll

  到项目bin目录下,并引用.

5,到此我们已经可以的cs文件里引用MySql.Data.MySqlClient命名空间,并像连接mssql一样进行数据库连接了.如:

  MySqlConnection con = new MySqlConnection("data source=localhost;user id=root;password=ssh;initial catalog=books");
  MySqlDataAdapter adp = new MySqlDataAdapter("select * from book", con);