Spread Windows Forms 10.0 Product Documentation
GetChildSheets Method
Example 


Gets a list of child sheet views that have been created.
Syntax
'Declaration
 
Public Function GetChildSheets() As ArrayList
'Usage
 
Dim instance As SheetView
Dim value As ArrayList
 
value = instance.GetChildSheets()
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.
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();
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 Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

SheetView Class
SheetView Members

User-Task Documentation

Managing Data Binding

 

 


Copyright © GrapeCity, inc. All rights reserved.