Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / GetChildVisible Method
Child view to show
Example


In This Topic
    GetChildVisible Method
    In This Topic
    Gets whether to show the child view on this sheet when the parent row is expanded.
    Syntax
    'Declaration
     
    Public Function GetChildVisible( _
       ByVal child As SheetView _
    ) As Boolean
    'Usage
     
    Dim instance As SheetView
    Dim child As SheetView
    Dim value As Boolean
     
    value = instance.GetChildVisible(child)
    public bool GetChildVisible( 
       SheetView child
    )

    Parameters

    child
    Child view to show

    Return Value

    Boolean: true if the child sheet is displayed; false otherwise
    Remarks
    If this method returns true and the parent row of the child view is expanded, the child view is displayed; otherwise, the child view is not displayed.
    Example
    This example illustrates the use of this member by returning whether the child view is visible.
    DataSet ds = new System.Data.DataSet();
    DataTable name; 
    DataTable city; 
    DialogResult dlg;
    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);
    dlg = MessageBox.Show("Do you want to see if the child is visible?", "GetChildVisible", MessageBoxButtons.YesNo);
    if (dlg == DialogResult.Yes)
    {
        bool b;
        FarPoint.Win.Spread.SheetView sv;
        sv = fpSpread1.ActiveSheet.GetChildView(1, 0);
        b = fpSpread1.ActiveSheet.GetChildVisible(sv);
        label1.Text = b.ToString();
    }
    Dim ds As New System.Data.DataSet()
    Dim name As DataTable
    Dim city As DataTable
    Dim dlg As DialogResult
    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)
    dlg = MessageBox.Show("Do you want to see if the child is visible?", "GetChildVisible", MessageBoxButtons.YesNo)
    If dlg = DialogResult.Yes Then
        Dim b As Boolean
        Dim sv As FarPoint.Win.Spread.SheetView
        sv = FpSpread1.ActiveSheet.GetChildView(1, 0)
        b = FpSpread1.ActiveSheet.GetChildVisible(sv)
        Label1.Text = b.ToString()
    End If
    See Also