.net中数据库连接

web.config中的写法---oledb

<connectionStrings>
    <add name="mdbConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|/web _ db .mdb"
     providerName="System.Data.OleDb" />

    <add name="ConnectionString" connectionString="Provider=SQLOLEDB;Data Source=(local);Password=sa;User ID=sa;Initial Catalog=ibier"
     providerName="System.Data.OleDb" />
  </connectionStrings> 

页面中的读取方式

  string connstr = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();