Extending Reporting Services - Professional SQL Server 2005 Reporting Services - page 560

Match fieldMatch= null;
//regex used for getting keywords
Regex keywordSplit = new Regex(@”(Select|From|Where| Order[ \s] +By)”,
RegexOptions.IgnoreCase| RegexOptions.Multiline
| RegexOptions.IgnorePatternWhitespace | RegexOptions.Compiled);
// regex used for splitting out fields
Regex fieldSplit = new Regex(@”([^ ,\s]+)”,
RegexOptions.IgnoreCase | RegexOptions.Multiline
| RegexOptions.Compiled|RegexOptions.IgnorePatternWhitespace);
//constants
const int selectPosition = 0;
const int fromPosition = 1;
const int wherePosition = 2;
const int orderPosition = 3;
const string tempTableName = “TempTable”;
//internal variables
int keyWordCount=0;
bool filtering = false;
bool sorting = false;
bool useDefaultTable = false;
VB.NET
'property variables
Private m_cmdTimeOut As Integer = 0
Private m_commandText As String = String.Empty
Private m_connection As DataSetConnection
Private m_parameters As DataSetParameterCollection = Nothing
'dataset variables
Private tableName As String = String.Empty
Private dataSet As FCLData.DataSet
Friend dataView As FCLData.DataView
'regex variables
Private kwc As MatchCollection
Private fieldMatch As Match
Private tableMatch As Match
Private keywordSplit As Regex = New Regex(“(Select|From|Where| Order[ \s] +By)”,
RegexOptions.IgnoreCase Or RegexOptions.Multiline Or
RegexOptions.IgnorePatternWhitespace Or RegexOptions.Compiled)
Private fieldSplit As Regex = New Regex(“([^ ,\s]+)”, RegexOptions.IgnoreCase Or
RegexOptions.Multiline Or RegexOptions.Compiled Or
RegexOptions.IgnorePatternWhitespace)
'Constants
Private tempTableName As String = “TempTable”
Private selectPosition As Integer = 0
Private fromPosition As Integer = 1
Private wherePosition As Integer = 2
Private orderPosition As Integer = 3
'internal variables