| 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
本文转自ylbtech博客园博客，原文链接：http://www.cnblogs.com/ylbtech/p/3623018.html，如需转载请自行联系原作者