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);
}
