62,046
社区成员
发帖
与我相关
我的任务
分享
void Main()
{
string str=@"ConnectString={Persist Security Info=True;Provider=SQLOLEDB.1;User ID=sa;Password=123456;Data Source=XXXXX;Initial Catalog=DB8888};UserName=XX;UserID=XX;";
string result=Regex.Replace(Regex.Match(str,@"(?<={)[^}]+(?=})").Value,@"(?i)Provider[^;]+;","");
Console.WriteLine(result);
//Persist Security Info=True;User ID=sa;Password=123456;Data Source=XXXXX;Initial Catalog=DB8888
}
string str = "ConnectString={Persist Security Info=True;Provider=SQLOLEDB.1;User ID=sa;Password=123456;Data Source=XXXXX;Initial Catalog=DB8888};UserName=XX;UserID=XX;";
string str1 = str.Substring(str.IndexOf('{'));
string str2 = str1.Substring(0, str1.IndexOf('}')).Replace("Provider=SQLOLEDB.1", "");