代码如下:
SqlConnection = New SqlConnection("&ConnectionStrings:yy960ConnectionString&");
SqlConnection.Open();
Label1.Text="数据库已打开!";
这一行该怎么写...
New SqlConnection("&ConnectionStrings:yy960ConnectionString&");
SqlConnection = New SqlConnection("&ConnectionStrings:yy960ConnectionString&");
SqlConnection.Open();
Label1.Text="数据库已打开!";
这一行该怎么写...
New SqlConnection("&ConnectionStrings:yy960ConnectionString&");
或session("connectionname")=connecionstring
SqlConnection = New SqlConnection(xxxxxxxx);
怎么把xxxxx替换成Web.Config的连接字串yy960ConnectionString啊Web.config
如下
<configuration>
<connectionStrings>
<add name="yy960ConnectionString" connectionString="Data Source=xxx;Initial Catalog=xxx;User ID=xxx;Password=xxx"
providerName="System.Data.SqlClient" />
</connectionStrings>
<appSettings>
而且在web.config中把name=改成key=;connectionString=改成value=;并用上双引号.
2、在web.config中添加如下代码:
<appSettings>
<add key="SqlConnection" value="server=.;database=crm;uid=sa;pwd="></add>
</appSettings>
3、之后要引用的语句是:
ConfigurationSettings.AppSettings["SqlConnection"].ToString()