WebConfig中设置好了SQLServer的连接字符串后,该怎么用? 加上using System.Configuration;ConfigurationSettings.AppSettings["sqlConnectionString"] 是你加的 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 在web.config中的记录如下<configuration> <appSettings> <add key="connectionString" value="Server=localhost;UID=sa;PWD=secret;Database=Webcreat" /> </appSettings></configuration>用的时候strconstring = Configurationsettings.Appsettings("connectionString") <sessionState mode="SQLServer" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="Password=ttdt;User ID=sa;Initial Catalog=appDataBase;Data Source=lserlohn; cookieless="false" timeout="20" />是将Session值储存于SQL Server中定义数据库连接字<appSettings> <add key="SQLConnectionString" value="data source=SQL1;initial catalog=ID_V;integrated security=SSPI;persist security info=False;workstation id=TH03D374;packet size=4096"/> <appSettings>代码引用:using System.Configuration;string conn = ConfigurationSettings.AppSettings["SQLConnectionString"];SqlDbConnection myConnection = new SqlDbConnection(conn); configurationsettings.Appsettings("yourkey") Dim configurationAppSettings As System.Configuration.AppSettingsReader = New System.Configuration.AppSettingsReader()Dim Cnnstr = CType(configurationAppSettings.GetValue("SqlConnection1.ConnectionString", GetType(System.String)), String) 在web.config中配置如下:<configuration> <appSettings> <add key="Repository" value= "Data Source=localhost;uid=sa;pwd=;database=Repository;"/> </appSettings></configuration>在WEB页中使用:using System.Configuration;.........String strConn=ConfigurationSettings.AppSettings["Repository"];Conn = new SqlConnection(strConn);这样应该没有问题,其中.AppSettings["Repository"]的"Repository"和你的add key="Repository"中的"Repository"对应起来就可以。 帮我做道面试题 在线等 复杂的存储过程,高手请进!(on line waiting...) 数据库里一个表有60多个字段对程序效率有影响吗? 如何实现异步发送邮件? 只显示标题的前几个字符,当鼠标放上去后,显示这个新闻标题的全部, 找合作伙拌(做web项目) 请问,软件开发的工序是怎样的 求救~gridview查询结果分页的问题 在dataGrid里绑定数据为什么总出现错误? 这个函数该怎么定义????? 怎么手动控制分页?使分页个性化 救火!!关于DataGrid
<configuration>
<appSettings>
<add key="connectionString"
value="Server=localhost;UID=sa;PWD=secret;Database=Webcreat" />
</appSettings>
</configuration>
用的时候
strconstring = Configurationsettings.Appsettings("connectionString")
mode="SQLServer"
stateConnectionString="tcpip=127.0.0.1:42424"
sqlConnectionString="Password=ttdt;User ID=sa;Initial Catalog=appDataBase;Data Source=lserlohn;
cookieless="false"
timeout="20"
/>
是将Session值储存于SQL Server中
定义数据库连接字
<appSettings>
<add key="SQLConnectionString" value="data source=SQL1;initial catalog=ID_V;integrated security=SSPI;persist security info=False;workstation id=TH03D374;packet size=4096"/>
<appSettings>
代码引用:
using System.Configuration;
string conn = ConfigurationSettings.AppSettings["SQLConnectionString"];
SqlDbConnection myConnection = new SqlDbConnection(conn);
Dim Cnnstr = CType(configurationAppSettings.GetValue("SqlConnection1.ConnectionString", GetType(System.String)), String)
<configuration>
<appSettings>
<add key="Repository" value=
"Data Source=localhost;uid=sa;pwd=;database=Repository;"/>
</appSettings>
</configuration>
在WEB页中使用:
using System.Configuration;
.........
String strConn=ConfigurationSettings.AppSettings["Repository"];
Conn = new SqlConnection(strConn);
这样应该没有问题,其中.AppSettings["Repository"]的"Repository"和你的add key="Repository"中的"Repository"对应起来就可以。