我把连接信息写在db.Config里了如下所示:
?xml version="1.0" encoding="utf-8"
<appSettings>
<add key="SQLCONNECTIONSTRING" value="data source=test;uid=sa;pwd=lnjst1234sa;database=test;pooling=true"></add>
</appSettings>
?> 可是我用connStr=System.Configuration.ConfigurationSettings.AppSettings[DB.Config.SQLCONNECTIONSTRING];读取不到,这么做对吗?还需要引用什么吗?请大家指教,谢谢了!
?xml version="1.0" encoding="utf-8"
<appSettings>
<add key="SQLCONNECTIONSTRING" value="data source=test;uid=sa;pwd=lnjst1234sa;database=test;pooling=true"></add>
</appSettings>
?> 可是我用connStr=System.Configuration.ConfigurationSettings.AppSettings[DB.Config.SQLCONNECTIONSTRING];读取不到,这么做对吗?还需要引用什么吗?请大家指教,谢谢了!
string connStr=System.Configuration.ConfigurationSettings.AppSettings["SQLCONNECTIONSTRING"];
如果是2005的话,用法不同:
string connStr=System.Configuration.ConfigurationManager.ConnectionStrings["SQLCONNECTIONSTRING"].ToString();
</appSettings>
要改:
<connectionStrings>
<add name="TableConnectionString" connectionString="server=(local);database=db;
uid=sa;pwd=123" providerName="System.Data.SqlClient" />
</connectionStrings>