字符串分割返回值

[yafun]

如何实现把以下字符串分割返回各个分号前的字段内容，不要{前的内容，也不要单个的'}',谢谢！

ConnectString={Persist Security Info=True;Provider=SQLOLEDB.1;User ID=xxx;Password=xxx;Data Source=xxx;Initial Catalog=xxx};UserName=xxx;UserID=xxx;

[weichangqing00]

LZ..你是想要这个链接的User ID等的属性值吧。。。
用ConfigurationManager的AppSettings就行
直接这样写就行了：

string connectionString = ConfigurationManager.AppSettings["ConnectionString"];
SqlConnectionStringBuilder csb = new SqlConnectionStringBuilder(connectionString);
string initial = csb.InitialCatalog;//数据库
string dataSource = csb.DataSource;//服务器
string userId = csb.UserID;//用户名
string password = csb.Password;//密码

[afeng124]

string ConnectString = "{Persist Security Info=True;Provider=SQLOLEDB.1;User ID=xxx;Password=xxx;Data Source=xxx;Initial Catalog=xxx}";
string[] tmpArray = ConnectString.Substring(1, ConnectString.Length - 2).Split(";".ToCharArray());

[xk1126]

string ConnectString = "{Persist Security Info=True;Provider=SQLOLEDB.1;User ID=xxx;Password=xxx;Data Source=xxx;Initial Catalog=xxx}";
string[] tmpArray = ConnectString.Substring(1, ConnectString.Length - 2).Split(";".ToCharArray());

[mngzilin]

string ss="";
string[] str = ss.Split(new char[] { ';', '}', '{' }, StringSplitOptions.RemoveEmptyEntries);

[wangwenzhuang]

string ConnectString = "{Persist Security Info=True;Provider=SQLOLEDB.1;User ID=xxx;Password=xxx;Data Source=xxx;Initial Catalog=xxx};UserName=xxx;UserID=xxx;";

List<string> list = ConnectString.Replace("{", "").Replace("}", "").Split(';').Where(s => s != string.Empty).ToList<string>();

[wangwenzhuang]

string ConnectString = "{Persist Security Info=True;Provider=SQLOLEDB.1;User ID=xxx;Password=xxx;Data Source=xxx;Initial Catalog=xxx};UserName=xxx;UserID=xxx;";

List<string> list = ConnectString.Replace("{", "").Replace("}", "").Split(';').Where(s => s != string.Empty).ToList<string>();

还是C#的代码好看

[Mark杨]

[Quote=引用 5 楼 wangwenzhuang 的回复:]
SQL code

string ConnectString = "{Persist Security Info=True;Provider=SQLOLEDB.1;User ID=xxx;Password=xxx;Data Source=xxx;Initial Catalog=xxx};UserName=xxx;UserID=xxx;";

List<string> list = Conn……
[/Quote]

顶一个

[KissXYL]

string yourStr = "ConnectString={Persist Security Info=True;Provider=SQLOLEDB.1;User ID=xxx;Password=xxx;Data Source=xxx;Initial Catalog=xxx};UserName=xxx;UserID=xxx;";
MatchCollection mc = Regex.Matches(yourStr,"[^;{}]+(?=;)");
foreach(Match m in mc)
{
    //m.Value就是你要的
}