Spread Windows Forms 6.0 Product Documentation
SetChildVisible Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : SetChildVisible Method


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

Glossary Item Box

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

Syntax

Visual Basic (Declaration) 
Public Sub SetChildVisible( _
   ByVal child As SheetView, _
   ByVal visible As Boolean _
) 
Visual Basic (Usage)Copy Code
Dim instance As SheetView
Dim child As SheetView
Dim visible As Boolean
 
instance.SetChildVisible(child, visible)
C# 
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

C#Copy Code
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 BasicCopy Code
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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.