Spread Windows Forms 8.0 Product Documentation
SetChildVisible Method
Example 


Child view to show
Whether to make it visible when parent row is expanded
Sets whether to make the child view on this sheet visible when the parent row is expanded.
Syntax
'Declaration
 
Public Sub SetChildVisible( _
   ByVal child As SheetView, _
   ByVal visible As Boolean _
) 
'Usage
 
Dim instance As SheetView
Dim child As SheetView
Dim visible As Boolean
 
instance.SetChildVisible(child, visible)
public void SetChildVisible( 
   SheetView child,
   bool visible
)

Parameters

child
Child view to show
visible
Whether to make it visible when parent row is expanded

Return Value

If visible is set to true, the child view is displayed when the parent row of the child view is expanded. If visible is set to false or the parent row is not expanded, the child view is not displayed.
Remarks
If this is set to true, the child view is displayed when the parent row of the child view is expanded. If this is set to false or the parent row is not expanded, the child view is not displayed.
Example
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.ActiveSheet.DataSource = ds;
fpSpread1.ActiveSheet.DataMember = "Customers";
fpSpread1.ActiveSheet.SetColumnWidth(2, 150);
fpSpread1.ActiveSheet.ExpandRow(0, true);

private void button1_Click(object sender, System.EventArgs e)
{
FarPoint.Win.Spread.SheetView sv;
sv = fpSpread1.ActiveSheet.GetChildView(1, 0);
fpSpread1.ActiveSheet.SetChildVisible(sv, 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.ActiveSheet.DataSource = ds
FpSpread1.ActiveSheet.DataMember = "Customers"
FpSpread1.ActiveSheet.SetColumnWidth(2, 150)
FpSpread1.ActiveSheet.ExpandRow(0, True)

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e
As System.EventArgs) Handles Button1.Click
Dim sv As FarPoint.Win.Spread.SheetView
sv = FpSpread1.ActiveSheet.GetChildView(1, 0)
FpSpread1.ActiveSheet.SetChildVisible(sv, False)
End Sub
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

Reference

SheetView Class
SheetView Members

User-Task Documentation

Working with Hierarchical Data Display

 

 


Copyright © GrapeCity, inc. All rights reserved.