如<appSettings>
<add key="server" value="127.0.0.1"/>
<add key="database" value="mydatabase"/>
<add key="username" value="me"/>
<add key="password" value="123"/>
</appSettings>
<connectionStrings>
<add name="Mydata.Properties.Settings.MydataConnectionString"
connectionString="Data Source=127.0.0.1;Initial Catalog=Mydata;Integrated Security=False;User Id=me;pwd=123"
providerName="System.Data.SqlClient" />
</connectionStrings>
我想用connectionString=="Data Source=" + server + ";Initial Catalog=" + database + ";Integrated Security=False;User Id=" + username + ";pwd=" + password如何实现呢?
那在应用程序中如何组合呀? providerName="System.Data.SqlClient"这个字段好像不能组合在连接语句里,有关系吗?
追答或者config里的Connectionstring删除,直接在代码里用:
string constr = string.Format("Data Source={0};Initial Catalog={1};Integrated Security=False;User Id={2};pwd={3}",
ConfigurationManager.AppSettings["server"],
ConfigurationManager.AppSettings["database"],
ConfigurationManager.AppSettings["username"],
ConfigurationManager.AppSettings["password"]);
connectionString="Data Source={0};Initial Catalog={1};Integrated Security=False;User Id={2};pwd={3}"
这句代码是什么意思呢?