ylbtech-ADO.NET:ADO.NET-Oracle|SQLServer|MySql|Access|Excel-dddd

ADO.NET:连接数据字符串

1.A，SqlServer

1.0, using System.Data.SqlClient; 

1.1,本地连接

SqlConnection con = null;public DBConnection(){con = new SqlConnection();con.ConnectionString = "server=.;database=db;integrated security=sspi";}public SqlConnection Con{get { return con; }set { con = value; }}

1.2,远程连接

SqlConnection con = null;public DBConnection(){con = new SqlConnection();con.ConnectionString = "server=.;database=db;uid=sa;pwd=";}public SqlConnection Con{get { return con; }set { con = value; }}

1.B，Oracle

 1.0,要添加引用——>添加 System.Data.OracleClient

 1.1,XE=10g; ORCL=11g

SqlConnection con = null;public DBConnection(){con = new SqlConnection();con.ConnectionString = "server=XE;uid=System;pwd=Oracle";// or con.ConnectionString = "server=ORCL;uid=System;pwd=Oracle";}public SqlConnection Con{get { return con; }set { con = value; }

1.C，Access

 

1，

小星儿已迷失在红尘之中，已不复存在，路新替代了他，变得有点世故、沉默 mar2，2 2010 by dreamoflan

作者： 出处： 本文版权归作者和博客园共有，欢迎转载，但未经作者同意必须保留此段声明，且在文章页面明显位置给出原文连接，否则保留追究法律责任的权利。