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)
![](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中使用的所有参数名称