connectionstring

Question

谁能给我个例子，在web.config里设置connectionstring和程序中调用

Answer 1

string _ConnString = System.Configuration.ConfigurationSettings.AppSettings["connectionstring"];不能用吗?

Answer 2

<appSettings>
server=127.0.0.1;database=codematic;uid=sa;pwd=,上面设置为false -->
<add key="ConnectionString" value="server=localhost;database=testDB;uid=sa;pwd=sa"/>

Answer 3

<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=127.0.0.1;Initial Catalog=dbName;User ID=sa;Password=sa;" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>
public static readonly string SQLServerConnStr = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

Answer 4

System.Configuration.ConfigurationManager.AppSettings["ConnectionString"]<appSettings> 
<add key="ConnectionString" value="server=localhost;database=testDB;uid=sa;pwd=sa"/>

Answer 5

web.config
<connectionStrings>
<add name="DB_AdvertiseSysConnectionString" connectionString="Data Source=WUXIONG\SQLEXPRESS;Initial Catalog=DB_AdvertiseSys;User ID=sa;Password=sa" providerName="System.Data.SqlClient"/>
</connectionStrings>.cs调用
 string connStr = ConfigurationManager.ConnectionStrings["DB_AdvertiseSysConnectionString"].ConnectionString;