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) |
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.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.
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 Basic | Copy 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 |
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
Reference
SheetView ClassSheetView Members