Spread ASP.NET 6.0 Product Documentation
ShowParentRow Property
See Also  Example Send Feedback
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > HierBarInfo Class : ShowParentRow Property


Glossary Item Box

Gets or sets whether the parent row of the hierarchy is shown on the hierarchy bar in the Spread component.

Syntax

Visual Basic (Declaration) 
Public Property ShowParentRow As Boolean
Visual Basic (Usage)Copy Code
Dim instance As HierBarInfo
Dim value As Boolean
 
instance.ShowParentRow = value
 
value = instance.ShowParentRow
C# 
public bool ShowParentRow {get; set;}

Property Value

true if the parent row displays; false otherwise

Remarks

This is the information about the row above, and thus the parent of, the child sheet in the hierarchy.

Example

C#Copy Code
FpSpread1.HierarchicalView = false;

FarPoint.Web.Spread.HierBarInfo hb;
hb = FpSpread1.HierBar;
hb.Align = HorizontalAlign.Right;
hb.BackColor = Color.Yellow;
hb.Font.Bold = true;
hb.Font.Name = "Comic Sans MS";
hb.ForeColor = Color.Green;
hb.ShowParentRow = true;
hb.ShowWholePath = true;

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.DataSource = ds;
Visual BasicCopy Code
FpSpread1.HierarchicalView = False

Dim hb As FarPoint.Web.Spread.HierBarInfo
hb = FpSpread1.HierBar
hb.Align = HorizontalAlign.Right
hb.BackColor = Color.Yellow
hb.Font.Bold = True
hb.Font.Name = "Comic Sans MS"
hb.ForeColor = Color.Green
hb.ShowParentRow = True
hb.ShowWholePath = True

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.DataSource = ds

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2002-2012 GrapeCity, Inc. All Rights Reserved.