/// <summary>
/// Strips ORDER-BY clauses from SelectCommand and adds a new one based
/// on SortKeyField
/// </summary>
private void AdjustSelectCommand(bool addCustomSortInfo)
{
// Truncate where ORDER BY is found
var temp = SelectCommand.ToLower();
var pos = temp.IndexOf("order by", StringComparison.Ordinal);
if (pos > -1)
{
SelectCommand = SelectCommand.Substring(0, pos);
}
// Add new ORDER BY info if SortKeyField is specified
if (SortField != "" && addCustomSortInfo)
{
SelectCommand += " ORDER BY " + SortField;
}
}
