桦山涧

桦山涧
Asp.net ---->知识改变命运!
posts - 261, comments - 171, trackbacks - 6, articles - 3
  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

在web.config中连接各种数据库代码

Posted on 2006-08-11 14:26 桦林 阅读(...) 评论(...) 编辑 收藏
1<?xml version="1.0"?>
 2<configuration>
 3 <connectionStrings>
 4    <!--
 5    This connection is inherited from the ASP.NET Quickstart Web.config file
 6    Uncomment this section to edit the sample locally
 7

 8    <add name="Pubs" connectionString="Server=(local)\SQLExpress;Integrated Security=True;Database=pubs;Persist Security Info=True"
 9      providerName="System.Data.SqlClient" />


10    <add name="Northwind" connectionString="Server=(local)\SQLExpress;Integrated Security=True;Database=Northwind;Persist Security Info=True"
11      providerName="System.Data.SqlClient" />

12    <add name="Contacts" connectionString="Server=(local)\SQLExpress;Integrated Security=True;Database=Contacts;Persist Security Info=True"
13     providerName="System.Data.SqlClient" />
14    -->
15

    <add name="NorthwindOLEDB" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Northwind.mdb;"
16     providerName="System.Data.OleDb" />
17

    <add name="ContactsDatabase" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=true;"
18     providerName="System.Data.SqlClient" />

19 </connectionStrings>
20    <system.web>
21        <pages styleSheetTheme="Default"/>
22        <caching>
23            <sqlCacheDependency enabled="true" pollTime="1000">
24                <databases>
25                    <add name="Pubs" connectionStringName="Pubs"/>
26                </databases>
27            </sqlCacheDependency>
28        </caching>
29        </system.web>
30</configuration>
31