private void FillControls() { if (CurrentRowIndex == -1) { ClearForm(); return; } var dr = SqlHelper.ExecuteReader(DBDataUtility.GetPagedSelectStatement(TableInfo, SortExpression, CurrentRowIndex, 1, UserCondition)); if (!dr.Read()) { dr.Close(); CurrentKeyValue = null; return; } FillFromReader(dr); dr.Close(); }
public static string GetSql(this DataSourceRequest request, string fieldsList, string fromClaues, string where, string orderBy) { return(DBDataUtility.GetPagedSelectStatement(fromClaues, fieldsList, orderBy, where, (request.Page - 1) * request.PageSize, request.PageSize)); }