C#连接数据库小结

来源：互联网发布：网上挣钱软件编辑：程序博客网时间：2024/06/14 17:41

连接Access数据库

string connStr = @"Data Source=D:\database.mdb; Provider=Microsoft.Jet.OleDb.4.0;"; //数据库连接字符串OleDbConnection conn = new OleDbConnection(connStr);

连接Oracle数据库

//数据库和客户端在同一台机器上  using System.Data.OracleClient;  string connStr = "data source=orcl;user=user;password=pwd;";  OracleConnection conn = new OracleConnection(connStr);//客户端和数据库不在同一台机器，可以使用下面的连接方式using System.Data.OleDb;//HOST是Oracle数据库服务器地址，PORT是Oracle数据库端口，SERVICE_NAME是数据库名称string connStr = "Provider=OraOLEDB.Oracle.1;Data Source=(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = orcl)));User ID=message;Password=message;";OleDbConnection conn = new OleDbConnection(connStr);

连接SqlServer数据库

using System.Data.SqlClient;string connStr = "data source=127.0.0.1;initial catalog=database;user id=sa;pwd=sa";SqlConnection conn = new SqlConnection(connStr);