我的 web.config 中的连接数据库是字符串是这样的<connectionStrings>
<add name="SqlConnectionString" connectionString="Data Source=S2003\SQLEXPRESS;Initial Catalog=cn07048;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>在我的程序 index.cs 中怎么才能取得此字符串呢?在 index.cs 中的命名空间中,默认有了 system.configuration; 空间我是这样做的:string strConn = ConfigurationManager.ConnectionStrings["SqlConnectionString"];这是vs.net 依然包错说:Message 1 Could not find schema information for the element 'http://schemas.microsoft.com/.NetConfiguration/v2.0:configuration'. e:\inetpub\wwwroot\testv2005\web.config 2 2 http://localhost/testv2005/Message 6 Could not find schema information for the attribute 'connectionString'. e:\inetpub\wwwroot\testv2005\web.config 5 41 http://localhost/testv2005/
这是怎么回事啊
在 vs.net 2005 里,到底要如何才能出得到 web.config 里的连接这字符串呢???
<add name="SqlConnectionString" connectionString="Data Source=S2003\SQLEXPRESS;Initial Catalog=cn07048;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>在我的程序 index.cs 中怎么才能取得此字符串呢?在 index.cs 中的命名空间中,默认有了 system.configuration; 空间我是这样做的:string strConn = ConfigurationManager.ConnectionStrings["SqlConnectionString"];这是vs.net 依然包错说:Message 1 Could not find schema information for the element 'http://schemas.microsoft.com/.NetConfiguration/v2.0:configuration'. e:\inetpub\wwwroot\testv2005\web.config 2 2 http://localhost/testv2005/Message 6 Could not find schema information for the attribute 'connectionString'. e:\inetpub\wwwroot\testv2005\web.config 5 41 http://localhost/testv2005/
这是怎么回事啊
在 vs.net 2005 里,到底要如何才能出得到 web.config 里的连接这字符串呢???
string connstr=ConfigurationSettings.AppSettings["SqlConnectionString"];vs.net 又担出警告:
e:\inetpub\wwwroot\testv2005\ConnectDataBase.aspx.cs(21,26): warning CS0618: 'System.Configuration.ConfigurationSettings.AppSettings' is obsolete: 'This method is obsolete, it has been replaced by System.Configuration!System.Configuration.ConfigurationManager.AppSettings'
public System.Data.SqlClient.SqlConnection GetConnection() //返回数据库连接字符串函数;GetConnection()
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationSettings.AppSettings["DbConnectionString"].ToString();
return conn; //返回数据库连接字符串;
}
后,随然 vs.net 2005 警告信息:
e:\inetpub\wwwroot\testv2005\ConnectDataBase.aspx.cs(21,26): warning CS0618: 'System.Configuration.ConfigurationSettings.AppSettings' is obsolete: 'This method is obsolete, it has been replaced by System.Configuration!System.Configuration.ConfigurationManager.AppSettings'但是却依然能够取得 web.config 中的内容。我想在 vs.net 2005中,最正规的写法好像应该是ConfigurationManager.AppSettings["SqlConnectionString"];
但是我这样写,也报错,实在不知道什么原因!!
<add key="sqllink" value="server=yfq-001;uid=ADM;pwd=sdadm;database=DBMT50"/>
<add key="link" value="server=blackhero;uid=sa;pwd=;database=blackhero"/>
</appSettings>vb.net:Dim str As String = System.Configuration.ConfigurationManager.AppSettings("sqllink")
Dim conn As New System.Data.SqlClient.SqlConnection(str)
conn.Open()c#:string str=System.Configuration.ConfigurationManager.AppSettings["Sqllink"];
SqlConnection conn =new SqlConnection(str);
conn.Open();
string str= ConfigurationManager.ConnectionString["SqlConnectionString"].ConnectionString;