public void Start() { this.connection = new SqlConnection(SQLHelpers.GetConnectionString(SQLServer, SQLUser, SQLPassword, SQLUseSQLAuth, SQLDatabase)); Grid sortGrid = new Grid { Value = config["SortGrid"] }; SortClause = ""; foreach (var row in sortGrid.Rows) { SortClause += " " + row["SortColumn"].ToString() + " " + row["SortOrder"] + ","; } if (!String.IsNullOrWhiteSpace(SortClause)) { SortClause = " ORDER BY " + SortClause.TrimEnd(','); } WhereClause = ""; if (Filters != "null" && !string.IsNullOrWhiteSpace(Filters)) { filterExpression = ExpressionReader.Evaluate(Filters); WhereClause = filterExpression.ConvertToSQL(); if (!string.IsNullOrWhiteSpace(WhereClause)) { WhereClause = "WHERE " + WhereClause; } } TopClause = MaxRows > 0 ? "TOP " + MaxRows : ""; }