Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / SetRowExpandable Method
Row index
True if the row can be expanded; false otherwise
Example


In This Topic
    SetRowExpandable Method
    In This Topic
    Sets whether the row on this sheet can be expanded to show the child view in the hierarchical display.
    Syntax
    'Declaration
     
    Public Sub SetRowExpandable( _
       ByVal row As Integer, _
       ByVal expandable As Boolean _
    ) 
    'Usage
     
    Dim instance As SheetView
    Dim row As Integer
    Dim expandable As Boolean
     
    instance.SetRowExpandable(row, expandable)
    public void SetRowExpandable( 
       int row,
       bool expandable
    )

    Parameters

    row
    Row index
    expandable
    True if the row can be expanded; false otherwise
    Exceptions
    ExceptionDescription
    Specified row is out of range; must be between 0 and the number of rows
    Example
    This example sets the first row of a hierarchy to not be expandable.
    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);
    
    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)
    See Also