在.NET中如何使用MySQL数据库的.NET驱动程序？

[jeoky]

我安装了MySQL数据库的.NET驱动程序,却不知道在Visual Studio .NET项目中如何使用，如何引用该驱动？

[ztx998]

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

[ztx998]

http://www.connectionstrings.com/

[listhome]

eInfoDesigns.dbProvider:

"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

[jeoky]

我是刚接触asp.net，不知道Visual Studio .NET项目中如何引用外部类库的，
在用

using ....
...
MySQLConnection myConn=new MySQLConnection();
...

也不清楚该using那个类。
编译是报错：缺少 using 指令或程序集引用

[wangsaokui]

using System;
using System.Data;
如果是ODBC
using System.Data.ODBC;
如果是OLEDB
using System.Data.OleDb;

[jeoky]

问题解决了，只需添加引用dll文件就可可以了。
可是各位都没答到点上，点数就平分啦。