比如说如下连接:
<appSettings>
<add key="ConnectionString" value="Provider=SQLOLEDB.1;Password=howareyou;Persist Security Info=True;User ID=sa;Initial Catalog=Northwind;Data Source=.">
</add>
</appSettings>
怎么分别都得到provider,password,uers id,Initial Catalog,data source这些属性等号右边的具体值?
<appSettings>
<add key="ConnectionString" value="Provider=SQLOLEDB.1;Password=howareyou;Persist Security Info=True;User ID=sa;Initial Catalog=Northwind;Data Source=.">
</add>
</appSettings>
怎么分别都得到provider,password,uers id,Initial Catalog,data source这些属性等号右边的具体值?
{
string[] _AttribValue =_Attrib[i].Split('=');
_AttribList.Add(_AttribValue[0], _AttribValue[1]);
}
string connString = System.Configuration.ConfigurationManager.AppSettings["ConnString"];
SqlConnectionStringBuilder sb = new SqlConnectionStringBuilder(connString); string DataSource = sb.DataSource;
string PersistSecurityInfo = sb.PersistSecurityInfo.ToString() ;
string Pwd = sb.Password;
string UserID = sb.UserID;
string InitialCatalog = sb.InitialCatalog;
<appSettings>
<add key="Provider" value="Provider=SQLOLEDB.1"> </add>
<add key="Server" value="localhost"> </add>
……
</appSettings> 其实本质都是读取XML,appSetting和connectionString 的读取,只是.net封装了读取它们的方法而已,自己也可以写的