下面的代码是在MyWeb.aspx中找到的
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:kkConnectionString %>"
SelectCommand="SELECT * FROM table]"></asp:SqlDataSource>其中的kkConnectionString是从MyWeb.config中继承过来的 <add name="kkConnectionString" connectionString="data Source=192.168.0.1;database=DB;user id=sa;pwd=123" providerName="System.Data.SqlClient"></add>
我的问题是这个kkConnectionString能否在我的MyWeb.aspx.cs中引用,语法是什么?
因为我在每个网页中都是用字符串写的数据链接,如果更改数据源就得每个都要改一次,所以我想到了MyWeb.config的用途,请各位老师给指点一下
<connectionStrings>
<add name="kkConnectionString" connectionString="data Source=192.168.0.1;database=DB;user id=sa;pwd=123" providerName="System.Data.SqlClient" />
</connectionStrings>
ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings["kkConnectionString"];
if (settings != null)
{
Console.WriteLine(settings.ConnectionString);
}
<connectionStrings>
<add name="kkConnectionString" connectionString="data Source=192.168.0.1;database=DB;user id=sa;pwd=123" providerName="System.Data.SqlClient" />
</connectionStrings> 在代码中引用:ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings["kkConnectionString"];
if (settings != null)
{
Console.WriteLine(settings.ConnectionString);
}
看2,3楼