Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / BaseSheetAxisModel Class / SetSortIndicator Method
Row or column index
Sort indicator value
Example


In This Topic
    SetSortIndicator Method (BaseSheetAxisModel)
    In This Topic
    Sets the sort indicator for the specified row or column. (This implementation does nothing.)
    Syntax
    'Declaration
     
    Public Overridable Sub SetSortIndicator( _
       ByVal index As Integer, _
       ByVal value As SortIndicator _
    ) 
    'Usage
     
    Dim instance As BaseSheetAxisModel
    Dim index As Integer
    Dim value As SortIndicator
     
    instance.SetSortIndicator(index, value)
    public virtual void SetSortIndicator( 
       int index,
       SortIndicator value
    )

    Parameters

    index
    Row or column index
    value
    Sort indicator value
    Example
    This example returns the sort indicator for the specified column.
    DataTable tblMain = new DataTable();
    int i;
    tblMain = new DataTable();
    tblMain.Columns.Add("ColA");
    tblMain.Columns.Add("ColB");
    for (i = 1; i <=99; i++)
    {
       DataRow r = tblMain.NewRow();
       r[0] = "A " + i.ToString();
       r[1] = "B " + i.ToString();
       tblMain.Rows.Add(r);
    }
    FpSpread1.DataSource = tblMain;
    FpSpread1.ActiveSheetView.AllowSort = true;
     
    FarPoint.Web.Spread.Model.BaseSheetAxisModel b;
    FarPoint.Web.Spread.Model.SortIndicator si;
    b = (FarPoint.Web.Spread.Model.BaseSheetAxisModel)FpSpread1.ActiveSheetView.ColumnAxisModel;
    b.SetSortIndicator(0, FarPoint.Web.Spread.Model.SortIndicator.Descending);
    si = b.GetSortIndicator(0);
    Response.Write(si.ToString());
    
    Dim tblMain As New DataTable
    Dim i As Integer
    tblMain = New DataTable
    tblMain.Columns.Add("ColA")
    tblMain.Columns.Add("ColB")
    For i = 1 To 99
       Dim r As DataRow = tblMain.NewRow()
       r(0) = "A " + i.ToString()
       r(1) = "B " + i.ToString()
       tblMain.Rows.Add(r)
    Next i
    FpSpread1.DataSource = tblMain
    FpSpread1.ActiveSheetView.AllowSort = True
    
    Dim b As FarPoint.Web.Spread.Model.BaseSheetAxisModel
    Dim si As FarPoint.Web.Spread.Model.SortIndicator
    b = FpSpread1.ActiveSheetView.ColumnAxisModel
    b.SetSortIndicator(0, FarPoint.Web.Spread.Model.SortIndicator.Descending)
    si = b.GetSortIndicator(0)
    Response.Write(si.ToString()) 
    See Also