Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / Group Class / Rows Property
Example


In This Topic
    Rows Property (Group)
    In This Topic
    Gets the array of rows in the group.
    Syntax
    'Declaration
     
    Public ReadOnly Property Rows As ArrayList
    'Usage
     
    Dim instance As Group
    Dim value As ArrayList
     
    value = instance.Rows
    public ArrayList Rows {get;}

    Property Value

    ArrayList of rows in the group
    Example
    This example returns the row.
    FarPoint.Web.Spread.Model.GroupDataModel gm = new FarPoint.Web.Spread.Model.GroupDataModel(FpSpread1.ActiveSheetView.DataModel);
    FarPoint.Web.Spread.SortInfo[] sort = new FarPoint.Web.Spread.SortInfo[1];
    sort[0] = new FarPoint.Web.Spread.SortInfo(0, true);
    gm.Group(sort, System.Collections.Comparer.Default);
    FpSpread1.ActiveSheetView.DataModel = gm;
    
    FarPoint.Web.Spread.Model.Group dg = new FarPoint.Web.Spread.Model.Group(gm, (FarPoint.Web.Spread.Model.Group)gm.Groups[0], "Harris" 0, true);
    int i = dg.Rows;
    String msg = i.ToString();
    Response.Write("alert('" + msg + "')");
    
    Dim gm As New FarPoint.Web.Spread.Model.GroupDataModel(FpSpread1.ActiveSheetView.DataModel)
    Dim sort(0) As FarPoint.Web.Spread.SortInfo
    sort(0) = New FarPoint.Web.Spread.SortInfo(0, True)
    gm.Group(sort)
    FpSpread1.ActiveSheetView.DataModel = gm
    
    Dim dg As New FarPoint.Web.Spread.Model.Group(gm, gm.Groups(0), "Harris" 0, True)
    Dim i As Integer = dg.Rows
    Dim msg As String = i.ToString()
    Response.Write("alert('" & msg & "')")
    
    See Also