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

[zjh222]

？？？

[yespie]

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

[暗石绿]

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()

[江城老温]

太全了。