当前页面位置: » 丰搜网 » 文档中心 » 详细内容
ado.net中数据库连接方式
在msdn中，.net的数据库连接字符串都有详细的说明，我这里以代码范例的方式罗列一些，具体的每一项代表的意义可以参看msdn.
ado.net 中数据库连接方式(微软提供)
微软提供了以下四种数据库连接方式：
system.data.oledb.oledbconnection
system.data.sqlclient.sqlconnection
system.data.odbc.odbcconnection
system.data.oracleclient.oracleconnection
下面我们以范例的方式，来依次说明：
system.data.sqlclient.sqlconnection
常用的一些连接字符串(c#代码)：
sqlconnection conn
= new sqlconnection( "server=(local);integrated security=sspi;database=pubs");
sqlconnection conn
= new sqlconnection("server=(local)\.netsdk;database=pubs;integrated security=sspi");
sqlconnection conn = new sqlconnection(
"data source=localhost;integrated security=sspi;initial catalog=northwind;");
sqlconnection conn = new sqlconnection(
" data source=(local);initial catalog=xr;integrated security=sspi;
persist security info=false;workstation id=xurui;packet size=4096; ");
sqlconnection myconn = new
system.data.sqlclient.sqlconnection("persist security info=false;integrated
security=sspi;database=northwind;server=mysqlserver");
sqlconnection conn = new sqlconnection(
" uid=sa;pwd=passwords;initial catalog=pubs;data source=127.0.0.1;connect timeout=900");
更多字符串连接说明请看msdn：
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatasqlclientsqlconnectionclassconnectionstringtopic.asp
system.data.oledb.oledbconnection
常用的一些连接字符串(c#代码)：
oledbconnection conn = new oledbconnection(@"provider=microsoft.jet.oledb.4.0;data source=d:\myweb\81\05\grocertogo.mdb");
oledbconnection conn = new oledbconnection(
@"provider=microsoft.jet.oledb.4.0;password=;
user id=admin;data source=grocertogo.mdb;");
oledbconnection conn = new oledbconnection(
"provider=msdaora; data source=oracle8i7;persist security info=false;integrated security=yes");
oledbconnection conn = new oledbconnection(
"provider=microsoft.jet.oledb.4.0; data source=c:\bin\localaccess40.mdb");
oledbconnection conn = new oledbconnection(
