VB.net 通过 ADO.net 连接MySQL数据库 趟坑

坑1：首先下载安装 MySQL connector/Net （http://dev.mysql.com/downloads/connector/net/）
然后在Project中引入MySQL.data.dll。运行代码，报错原因：MySQL.data.dll的版本与.net Framework的版本不匹配
措施：下载MySql.Data.dll v4.0 取代电脑上的此文件，运行ok

坑2：连接MySQL时报错：The given key was not present in the dictionary.
措施：Dim constr As String = “server=” & “localhost” & “;uid=” & “root” & “;pwd=” & “密码” & “;database= 数据库名;pooling=false;”
后加上charset=utf8，变为Dim constr As String = “server=” & “localhost” & “;uid=” & “root” & “;pwd=” & “222310” & “;database= buyer;pooling=false;charset=utf8”
连接成功。