Columns (1 based) to be sorted initially upon entry.

dbQP Abbr: isc
Version: All

Namespace:  Tornado
Assembly:  Tornado (in Tornado.dll) Version: 12.6.0.9 (1.0.0.0)

Syntax

C#
public string dbInitSortCols { get; set; }
Visual Basic (Declaration)
Public Property dbInitSortCols As String

Field Value

Obj.dbInitSortCols = "ColIndex, ColIndex-, ColName, ColName DESC"

Remarks

  • FieldName decend order must be 'Fields DESC'(Employeeid DESC). FieldOrdinal decend order must be 'number-'(2-).
  • Rememebr that 'Cols' ordinals is 1 based and ORDER BY field ordinals is 0 based. Fieldname is absolute and not affectd by any numbers.
  • Avoid using ORDERby in dbSQL when using dbInitSortCols
  • If all fieldnames are used, then dbInitSortCols and dbInitSortFlds has no difference.

Examples

CopyVB.NET
<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
Dim CS As New Tornado.z
  With CS
    .dbQP = "U=12| S=17|Gdf=0,1,2,3,4| D=Nwind| Q=Orders| Th=tit=Multi-Columns Sort with Automatic Lineup"
    .dbSortFlds = "0,1,employeeid,3"
    .dbSortColLeftJustify = True
    .dbInitSortCols = "employeeid DESC,1"
    .ASPdbNET()
  End With
End Sub
</script>

See Also