Asp.net的连接字符串

Asp.net的连接字符串

 

   <connectionStrings>
        <add name="HST_KSConnectionString" connectionString="DataSource=HST-6066516F4E7/SQLEXPRESS;Initial Catalog=HST_KS;IntegratedSecurity=True; User id=sa;password='sa'"providerName="System.Data.SqlClient"/>
    </connectionStrings>

获取此连接的方法：

    //从配置文件中获取连接信息
    public SqlConnection getConnection()
    {
        return newSqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["HST_KSConnectionString"].ConnectionString);
    }

 

 

        <add key="ConnectionString" value="server=HST-67355592395;uid=sa;pwd=sa;database=News"/>
    </appSettings>
    <connectionStrings/>

获取此连接的方法

string strConn = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];