string MySqlConnection="user id=sa;password=sinofindb;Database
=test;data source=127.0.0.1;Connect Timeout=30";
SqlConnection myConnection = new SqlConnection(MySqlConnection);
myConnection.Open();
二。用 OleDbConnection 连接
1.加入命名空间
using System.Data.OleDb;
2.连接 sql server
string MySqlConnection="Provider=SQLOLEDB;Data Source=localhost;Initial
Catalog=test;Integrated Security=SSPI;";
SqlConnection myConnection = new SqlConnection(MySqlConnection);
myConnection.Open();
3.连接 Access(可通过建立.udl 文件获得字符串)
string MySqlConnection="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\db2000.mdb;
Persist Security Info=False;
4.连接 Oracle(也可通过 OracleConnection 连接)
string MySqlConnection="Provider=MSDAORA;Data Source=db; user
id=sa;password=sinofindb";