1
//
清除命令字符串中的所有字符串
2
string
commandTextNoString
=
Regex.Replace(command.CommandText,
@"
['][\S]*[']
"
,
""
);
3![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
4
Regex regex
=
new
Regex(
@"
@[^,\s)]*
"
);
5
//
获取参数名列表
6
MatchCollection matchs
=
regex.Matches(commandTextNoString);
7
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
2
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
4
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
5
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
6
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
7
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
matchs里面包含了在CommandText中使用的所有参数名称