1.C#连接连接Access
using System.Data;
using System.Data.OleDb;
..
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;Data Source=.//test.mdb;password=";
OleDbConnection objConnection=new OleDbConnection(strConnection);
..
objConnection.Open();
objConnection.Close();
2.C#连接SQL Server
using System.Data;
using System.Data.SqlClient;
..
string strConnection="user id=sa;pwd= ;Database=Northwind;Server=YourSQLServer;Connect Timeout=30";
SqlConnection objConnection=new SqlConnection(strConnection);
..
objConnection.Open();
objConnection.Close();
解释:
"user id=sa":连接数据库的验证用户名为sa.他还有一个别名"uid",所以这句我们还可以写成"uid=sa".
"password=":连接数据库的验证密码为空.他的别名为"pwd",所以我们可以写为"pwd=".
如果SQL Server设置为Windows登录,那么在这里就使用"Trusted_Connection=SSPI"来进行登录.
"Server=YourSQLServer":使用名为"YourSQLServer"的服务器.他的别名为"Data Source","Address","Addr".如果使用的是本地数据库且定义了实例名,则可以写为"Server=(local)/实例名";如果是远程服务器,则将"(local)"替换为远程服务器的名称或IP地址.
"Connect Timeout=30":连接超时时间为30秒.
3.C#连接Oracle
using System.Data.OracleClient;
using System.Data;
..
string ConnectionString="Data Source=dbName_serverIp;User Id=root;Password=123";
OracleConnection conn=new OracleConnection(ConnectionString);
4.C#连接MySQL
using MySQLDriverCS;
..
MySQLConnection DBConn;
DBConn = new MySQLConnection(new MySQLConnectionString("localhost","mysql","root","",3306).AsString);
DBConn.Open();