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


Glossary Item Box

Gets a list of child sheet views that have been created.

Syntax

Visual Basic (Declaration) 
Public Function GetChildSheets() As ArrayList
Visual Basic (Usage)Copy Code
Dim instance As SheetView
Dim value As ArrayList
 
value = instance.GetChildSheets()
C# 
public ArrayList GetChildSheets()

Return Value

ArrayList containing a list of child sheet views

Example

This example copies the child sheets to an array list and returns the count of the array.
C#Copy Code
ArrayList al = new ArrayList(2);
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);
al.AddRange(new object[] {fpSpread1.ActiveSheet.GetChildSheets().ToArray()});
label1.Text = al.Count.ToString();
Visual BasicCopy Code
Dim al As New ArrayList(2)
Dim ds = 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", GetType(String)), New DataColumn("FirstName", GetType(String)),
New DataColumn("ID", GetType(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", GetType(String)), New DataColumn("Owner", GetType(Int32)),
New DataColumn("State", GetType(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)
al.AddRange(New Object() {fpSpread1.ActiveSheet.GetChildSheets().ToArray()})
label1.Text = al.Count.ToString()

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

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