.NET连接数据库字符串

access数据库：

1、web.config设置：

<connectionStrings>
     <add name="myorderConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\myorder.mdb;Persist Security Info=True"
         providerName="System.Data.OleDb" />
 </connectionStrings>

代码访问：

string cn = System.Configuration.ConfigurationManager.ConnectionStrings["myorderConnectionString"].ToString();

2、web.config设置：

  <appSettings>
    <add key="DbPath" value="~/App_Data/myorder.mdb" />
    <add key="MAIN" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" />
  </appSettings>

代码访问：

    public static string dbpath = HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["DbPath"].ToString());
    public static string connectionString = System.Configuration.ConfigurationManager.AppSettings["MAIN"].ToString() + dbpath + ";";

SQL2005数据库：

<appSettings>
    <add key="ConnectionString" value="server=LENOVO-356010C2\SQLEXPRESS;Uid=sa;pwd=sa;database=MMGO;" />
</appSettings>

string myStr = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"].ToString();