(1)装MyODBC,然后通过OleDBConnection 连接 (2)使用ADO.NET Provider for MySQL http://crlab.com/mysqlnet/
using eInfoDesigns.dbProvider.MySqlClient; MySqlConnection oMySqlConn = new MySqlConnection(); oMySqlConn.ConnectionString = "my connectionstring"; oMySqlConn.Open();
conn=new SqlConnection("SERVER=计算机名"+
";UID=Sa"+
";password="+ ";persist security info=False;initial catalog=“数据库”)"
conn.Open();
(2)使用ADO.NET Provider for MySQL
http://crlab.com/mysqlnet/
MySqlConnection oMySqlConn = new MySqlConnection();
oMySqlConn.ConnectionString = "my connectionstring";
oMySqlConn.Open();