字符截取！高手Look

[yzaiml]

exec sp_GetCustomerInfo @CityId,@CustomerName,@CustomerTel,@GroupId,@append,@pagesize,@pageindex,@docount字符截取
最终得到
@CityId
@CustomerName
@CustomerTel
或
这样
CityId
CustomerName
CustomerTel
的一个字符串数组 ???

select * from Customer where HomePhone=@Phone or OtherPhone=@Phone or MobilePhone=@Phone又如这样的???

[yzaiml]

C#如何实现?

[yzaiml]

自己顶下

[keystudio]

Regex re14 = new Regex(@"@(?<par>[^,\s]*)[,\s]");
MatchCollection mc1 = re14.Matches("exec sp_GetCustomerInfo @CityId,@CustomerName,@CustomerTel,@GroupId,@append,@pagesize,@pageindex,@docount ");
for (int j = 0; j < mc1.Count; j++)
{
Response.Write("</br>par:" + mc1[j].Groups["par"]);
}

[cpp2017]

用正则或直接用,分隔

[wapit]

没看明白.

[[e-mail]]

string sourceString = "exec sp_GetCustomerInfo @CityId,@CustomerName,@CustomerTel,@GroupId,@append,@pagesize,@pageindex,@docount";
System.Text.RegularExpressions.MatchCollection results = Regex.Matches(sourceString,@"@([^,]*)",System.Text.RegularExpressions.RegexOptions.IgnoreCase);
foreach(Match result in results)
{
WL(result.Groups[1].Value);
}

//////////////////////////////////////////////
MSN:[e-mail]请给我一个与您交流的机会！

[wxlwxlwxlwxl]

用“，”分隔，再用Split处理，挺好用的

[lvxianda]

string a = "1,2,3,4"
string s[] = a.split(',')

[Robin]

"SELECT c.*, u.UserName AS UserName, g.GroupName AS GroupName,City.CityName AS CityName ,c.Sex AS Sex FROM Customer c LEFT OUTER JOIN Users u ON u.UserId = c.UserId left JOIN CustomerGroup g ON c.GroupId = g.GroupId left JOIN City ON c.CityId = City.CityId WHERE (c.CustomerId = @CustomerId)
上面的方法这一串好像不行呀

[yzaiml]

不行

[逍遥的窝头]

在存储过程里调不行吗?为什么用C#实现?

学习中....关注

[keystudio]

Regex re14 = new Regex(@"@(?<par>[^,\s)]*)[,\s)]");
MatchCollection mc1 = re14.Matches("exec sp_GetCustomerInfo @CityId,@CustomerName,@CustomerTel,@GroupId,@append,@pagesize,@pageindex,@docount ");
for (int j = 0; j < mc1.Count; j++)
{
Response.Write("</br>par:" + mc1[j].Groups["par"]);
}


另外需要在待匹配的字符串最后加一个空格 :)

[wdzr_826]

还是不明白楼主的意思，能否详细点？