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