可以的,这是连接字符串:
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()
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()
解决方案 »
- C# 字符串处理 ...............................新手求解..在线等
- 求救!VS总是遇到问题,需要关闭
- visual stadio 2010 新建的表如何在工具箱内生成 tableadapter
- datetimepicker日期的问题
- 请教关于权限的问题
- C#怎么监控串口的收发数据?
- asp.net里数据库的操作
- DSOFramer.ocx 求稳定版 我的是 2.2.1.2 在线保存两次 ie就死
- sql2000里的 SET NOCOUNT ON 是什么意思呢:)
- 如何让应用程序只能运行一次
- 初学者的一个问题,如果下正确使用 DataGrid...
- 控件的使用问题?
DataSet ds=new DataSet("XMLProducts");
//连接SQL Server数据库
SqlConnection conn=new SqlConnection(@"server=glf;uid=sa;pwd=;database=northwind");
SqlDataAdapter da=new SqlDataAdapter("SELECT * FROM products",conn);
//绑定DataGrid控件
da.Fill(ds,"products");
string MyConString = "DRIVER={MySQL ODBC 3.51 Driver};" + "SERVER=localhost;" +
"DATABASE=test;" +"UID=venu;" +"PASSWORD=venu;" +"OPTION=3"; OdbcConnection MyConnection = new OdbcConnection(MyConString);
MyConnection.Open();
http://www.microsoft.com/china/community/Column/63.mspx
http://www.connectionstrings.com/