SetChildVisible Method

Sets whether to make the child view on this sheet visible when the parent row is expanded.

Syntax

Visual Basic
C#

'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);
}

Visual Basic

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 Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

SheetView Class
SheetView Members

User-Task Documentation

Working with Hierarchical Data Display