Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / GetRowExpandable Method
Row index
Example


In This Topic
    GetRowExpandable Method
    In This Topic
    Gets whether the row on this sheet is expandable in the hierarchical display.
    Syntax
    'Declaration
     
    Public Overridable Function GetRowExpandable( _
       ByVal row As Integer _
    ) As Boolean
    'Usage
     
    Dim instance As SheetView
    Dim row As Integer
    Dim value As Boolean
     
    value = instance.GetRowExpandable(row)
    public virtual bool GetRowExpandable( 
       int row
    )

    Parameters

    row
    Row index

    Return Value

    true if row is expandable; false otherwise
    Exceptions
    ExceptionDescription
    Specified row is out of range; must be between 0 and the number of rows
    Example
    This example returns if the specified row can be expanded.
    System.Data.DataSet ds = new System.Data.DataSet();
    DataTable name; 
    DataTable city; 
    name = ds.Tables.Add("Customers"); 
    name.Columns.AddRange(new DataColumn[] {new DataColumn("LastName", typeof(string)), new DataColumn("FirstName", typeof(string)),
    new DataColumn("ID", typeof(Int32))}); 
    name.Rows.Add(new object[] {"Fielding", "William", 0}); 
    name.Rows.Add(new object[] {"Williams", "Arthur", 1}); 
    name.Rows.Add(new object[] {"Zuchini", "Theodore", 2}); 
    city = ds.Tables.Add("City/State"); 
    city.Columns.AddRange(new DataColumn[] {new DataColumn("City", typeof(string)), new DataColumn("Owner", typeof(Int32)), new
    DataColumn("State", typeof(string))}); 
    city.Rows.Add(new object[] {"Atlanta", 0, "Georgia"}); 
    city.Rows.Add(new object[] {"Boston", 1, "Mass."}); 
    city.Rows.Add(new object[] {"Tampa", 2, "Fla."}); 
    ds.Relations.Add("City/State", name.Columns["ID"], city.Columns["Owner"]); 
    
    FpSpread1.DataSource = ds;
    FpSpread1.ActiveSheetView.SetRowExpandable(0, false);
    bool b;
    b = FpSpread1.ActiveSheetView.GetRowExpandable(0);
    Response.Write("The row can be expanded is " + b.ToString());
    
    Dim ds As New System.Data.DataSet
    Dim name As DataTable
    Dim city As DataTable
    name = ds.Tables.Add("Customers")
    name.Columns.AddRange(New DataColumn() {New DataColumn("LastName", Type.GetType("System.String")), New DataColumn("FirstName",
    Type.GetType("System.String")), New DataColumn("ID", Type.GetType("System.Int32"))})
    name.Rows.Add(New Object() {"Fielding", "William", 0})
    name.Rows.Add(New Object() {"Williams", "Arthur", 1})
    name.Rows.Add(New Object() {"Zuchini", "Theodore", 2})
    city = ds.Tables.Add("City/State")
    city.Columns.AddRange(New DataColumn() {New DataColumn("City", Type.GetType("System.String")), New DataColumn("Owner", Type.GetType("System.Int32")),
    New DataColumn("State", Type.GetType("System.String"))})
    city.Rows.Add(New Object() {"Atlanta", 0, "Georgia"})
    city.Rows.Add(New Object() {"Boston", 1, "Mass."})
    city.Rows.Add(New Object() {"Tampa", 2, "Fla."})
    ds.Relations.Add("City/State", name.Columns("ID"), city.Columns("Owner"))
    
    FpSpread1.ActiveSheetView.DataSource = ds
    FpSpread1.ActiveSheetView.SetRowExpandable(0, False)
    Dim b As Boolean
    b = FpSpread1.ActiveSheetView.GetRowExpandable(0)
    Response.Write("The row can be expanded is " & b.ToString())
    See Also