asp.net几种数据库连接方式？

A.Access：

1 web.config中配置

<add name="MyConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\\dbwangke.mdb"/>

页面读取：

public static string connectionString = ConfigurationManager.ConnectionStrings

["MyConnectionString"].ConnectionString;

2 web.config中配置

<connectionStrings>

<add name="ConnStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="

providerName="System.Data.OleDb"/>

<add name="ConnStr1" connectionString="App_Data/XMXCMS.mdb" providerName="System.Data.OleDb"/>

</connectionStrings>

页面读取：

ConnStr = ConfigurationManager.ConnectionStrings["ConnStr"].ToString() +

System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.ConnectionStrings

["ConnStr1"].ToString());

B.SQL Server 2000与SQL Server2005：

web.config中配置

<appSettings>

<add key="ConnectionString" value="Server=.\shuang121;database=hnzbtb;u/>

</appSettings>

2000：<connectionStrings>

<add name="MyConnectionString" connectionString="server=.;u/>

</connectionStrings>

2005：<connectionStrings>

<add name="ConnString" connectionString="Data Source=3F997D393A77495;Initial

Catalog=MyOffice;Persist Security Info=True;User

providerName="System.Data.SqlClient"/>

</connectionStrings>

<add name="suSoftConString" connectionString="server=.\sqlexpress;u providerName="System.Data.SqlClient"/>

页面读取：

public static readonly string connstring =

System.Configuration.ConfigurationManager.AppSettings["SQLConnString1"];

public static string connectionString = ConfigurationManager.ConnectionStrings

["MyConnectionString"].ConnectionString;