连接字符串的几种方式

View Code

由于Access是文件数据库，所以在ASP.NET需要能映射访问到Access文件： 
方式一：appSettings中设置连接字符串

web.config的配置

 方式一
  <appSettings>
    <add key="provider" value="Provider=Microsoft.Jet.OLEDB.4.0;data source="/>
    <add key="dbPath" value="~/App_Data\PF.mdb"/>
  </appSettings>


通过Server.Map()拼接数据库

    方式一
    private static readonly String connStr =
        System.Configuration.ConfigurationManager.AppSettings["provider"].ToString()+
        System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dbPath"])+";";

————————————————————————————————————————————————————

连接字符串方式二：SqlDataSource连接access

  <connectionStrings>
   <add name="WebSiteConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;
         Data Source=|DataDirectory|PF.mdb;Persist Security Info=true;" />

  </connectionStrings>


 private static readonly string conStr = System.Configuration.ConfigurationManager.ConnectionStrings["ACCDB"].ConnectionString;

-------------------------------------

Access数据库 连接字符串全解析（Asp.net）

密码：
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Financing_db.mdb;Persist Security Info=False;Jet OLEDB:Database Password=xxxxxx


用户名和密码：
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Financing_db.mdb;Persist Security Info=False;User Id=admin;Jet OLEDB:Database Password=xxxxxx

通常：
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Financing_db.mdb


其中:
|DataDirectory|系统被解析到App_Data文件夹下。

————————————————————————————

sql 连接字符串设置

web.config 文件

<configuration>
<!--连接字符串-->
<connectionStrings>
<add name="sql2005" connectionString="Data Source=.;Initial catalog=MySchool;uid=sa;pwd=221221"/>
</connectionStrings>
<system.web>
<compilation debug="true" targetFramework="4.0"/>
</system.web>
</configuration>

 

————————————————————————————


 private readonly static String connStr = "Data Source=.\\sqlexpress;Initial catalog=ShoppingCart;User ID=sa;Password=221221";
private static readonly String conStr=System.Configuration.ConfigurationManager.ConnectionStrings["sql2005"].ConnectionString; 

public static SqlConnection GetConnection
{
get{return new SqlConnection(conStr);}
}

DBHelper windows安全登陆机制

DBHelper windows安全登陆机制 public class DBHelper
    {
        const String connStr = "Data Source=STU01;Initial catalog=MySchool;UID=sa;Pwd=sa";

        // 获取连接对象
        public static SqlConnection GetConnection()
        {
            return new SqlConnection(connStr);
        }
    }

_____________________________________________________

string   conn= "Data   Source=你的服务器名;Initial   Catalog=数据库名;Integrated   Security=True ";

 

转载于:https://www.cnblogs.com/lijie007jh/archive/2012/06/24/2560011.html