Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / Expandable Property
Example


In This Topic
    Expandable Property
    In This Topic
    Gets or sets whether the rows are expandable.
    Syntax
    'Declaration
     
    Public Overridable Property Expandable As Boolean
    'Usage
     
    Dim instance As SheetView
    Dim value As Boolean
     
    instance.Expandable = value
     
    value = instance.Expandable
    public virtual bool Expandable {get; set;}
    Example
    This example uses the Expandable property.
    System.Data.DataSet ds = new System.Data.DataSet();
    System.Data.DataTable name;
    System.Data.DataTable city;
    name = ds.Tables.Add("Customers");
    name.Columns.AddRange(new System.Data.DataColumn[] { new System.Data.DataColumn("LastName", typeof(string)), new System.Data.DataColumn("FirstName", typeof(string)), new System.Data.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 System.Data.DataColumn[] { new System.Data.DataColumn("City", typeof(string)), new System.Data.DataColumn("Owner", typeof(Int32)), new System.Data.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.Sheets[0].Expandable = false;
    FpSpread1.DataSource = ds;
    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.Sheets(0).Expandable = False
    FpSpread1.ActiveSheetView.DataSource = ds
    See Also