Visual Basic (Declaration) | |
---|---|
Public Function GetChildVisible( _ ByVal child As SheetView _ ) As Boolean |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As SheetView Dim child As SheetView Dim value As Boolean value = instance.GetChildVisible(child) |
Parameters
- child
- Child view to show
Return Value
Boolean: true if the child sheet is displayed; false otherwiseIf 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.
This example illustrates the use of this member by returning whether the child view is visible.
C# | Copy Code |
---|---|
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(); } |
Visual Basic | Copy Code |
---|---|
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 |
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