用C#如何连接和操作MYSQL数据库呢？

Question

？？？

Answer 1

ODBC 
 Local database:
"Driver={mySQL};Server=mySrvName;Option=16834;Database=mydatabase;" 
 Remote database:
"Driver={mySQL};Server=data.domain.com;Port=3306;Option=131072;Stmt=;Database=my-database;Uid=username;Pwd=password;" 
 OLEDB, OleDbConnection (.NET) 
 Standard:
"Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd;" 
 MySqlConnection (.NET) 
 EID:
"Data Source=server;Database=mydb;User ID=username;Password=pwd;Command Logging=false" 
This one is used with eInfoDesigns dbProvider, an add-on to .NET
 Declare the MySqlConnection:C#:
using EID.MySqlClient;
MySqlConnection oMySqlConn = new MySqlConnection();
oMySqlConn.ConnectionString = "my connectionstring";
oMySqlConn.Open(); VB.NET:
Imports EID.MySqlClient
Dim oMySqlConn As MySqlConnection = New MySqlConnection()
oMySqlConn.ConnectionString = "my connectionstring"
oMySqlConn.Open()

Answer 2

http://community.csdn.net/Expert/topic/4866/4866725.xml?temp=.2308924