.net数据库连接（自行整理）

 

=====================关键字解释===================
1.  persist security info    在数据库连接成功后是否保存密码信息
2.  Integrated Security      Windows身份验证
3.  User Instance           

 

===============connectionStrings与appSettings区别=============

<connectionStrings>
<add name="" connectionString="" providerName="" />
<appSettings>
<add key="" value="" />

==================数据库连接实现方式===========

//Access数据库连接
<connectionStrings>
<add name="DBconnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|DB.mdb" providerName="System.Data.OleDb" />
</connectionSTrings>
<connectionStrings>
<add name="DBConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:/DB.mdb" providerName="System.Data.OleDb" />
</connectionSTrings>

<appSettings>
<add key="DBConnectionString" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|DB.mdb" />
</appSettings>

 

//本地VS2008自带数据库连接
<connectionStrings>
<add name="DBConnectionString" connectionString="Data Source=./SQLEXPRESS;AttachDbFilename=D:/DB.MDF;Integrated Security=True;Connect Timeout=30;User Instance=True" providerName="System.Data.SqlClient" />
</connectionStrings>

<appSettings>
<add key="DBConnectionString" value="server=./SQLEXPRESS;AttachDbFilename=D:/DB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" />
</appSettings>

 

//MSSQL数据库连接，Sql Server身份验证
<connectionStrings>
<add name="DBConnectionString" connectionString="Data Source=服务器名或IP;Initial Catalog=数据库名;Persist Security Info=True;User ID=用户名;Password=密码" providerName="System.Data.SqlClient" />
</connectionStrings>
<connectionStrings>
<add name="DBConnectionString" connectionString="Data Source=服务器名或IP;Initial Catalog=数据库名;User ID=用户名;Password=密码" providerName="System.Data.SqlClient" />
</connectionStrings>

<appSettings>
<add key="DBConnectionString" value="server=服务器名或IP；database=数据库名;uid=数据库名;password=密码">
</appSettings>

 
//MSSQL数据库连接,Windows身份验证
<connectionString>
<add name="DBConnectionString" connectionString="Data Source=服务器名或IP;Initial Catalog=数据库名;Integrated Security=True" providerName="System.Data.SqlClient" />
</connectionStrings>