protected CollectionBase GenerateQueryClauseCollectionFromReader(IDataReader returnData) { QueryClauseCollection queryCollection = new QueryClauseCollection(); while (returnData.Read()) { QueryClause newQueryClause = new QueryClause((string)returnData["BooleanOperator"], (string)returnData["FieldName"], (string)returnData["ComparisonOperator"], (string)returnData["FieldValue"], (SqlDbType)returnData["DataType"]); queryCollection.Add(newQueryClause); } return(queryCollection); }
//********************************************************************* // // BuildQuery Method // // This method builds a database query by iterating through each query clause. // //****************************************************************** QueryClauseCollection BuildQuery() { QueryClauseCollection colQueryClauses = new QueryClauseCollection(); foreach (PickQueryField ctlPickQuery in plhClauses.Controls) { QueryClause objQueryClause = ctlPickQuery.QueryClause; if (objQueryClause != null) { colQueryClauses.Add(objQueryClause); } } return(colQueryClauses); }