Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / BaseSheetAxisModel Class / GetSortIndicator Method
Row or column index
Example


In This Topic
    GetSortIndicator Method (BaseSheetAxisModel)
    In This Topic
    Gets the sort indicator for the specified row or column. (This implementation always returns None.)
    Syntax
    'Declaration
     
    Public Overridable Function GetSortIndicator( _
       ByVal index As Integer _
    ) As SortIndicator
    'Usage
     
    Dim instance As BaseSheetAxisModel
    Dim index As Integer
    Dim value As SortIndicator
     
    value = instance.GetSortIndicator(index)
    public virtual SortIndicator GetSortIndicator( 
       int index
    )

    Parameters

    index
    Row or column index

    Return Value

    This one returns None.
    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