Question

怎么设置asp项目的数据库信息

在web.config文件中：
<add name="DB" connectionString="server=.\sqlexpress;database=StudentInfo;Integrated security =false;uid=sa;pwd=123;" />
<add name="DB" connectionString="server=.\sqlexpress;database=StudentInfo;Integrated security = true;" />这两种是一样的吗

Answer 1

第一种：
取连接字符串

string connString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["SqlConnStr"].ConnectionString;

或者

protected static string connectionString = ConfigurationManager.ConnectionStrings["SqlConnStr"].ConnectionString;

web.config文件:加在</configSections>后面

<connectionStrings>
<remove name="LocalSqlServer" />
<add name="SqlConnStr" connectionString="user id=xx;password=xx;initial catalog=database_name;data source=.\sqlxxxx" />
</connectionStrings>