Spread for ASP.NET 9.0 Product Documentation
ShowParentRow Property
Example 


Gets or sets whether the parent row of the hierarchy is shown on the hierarchy bar in the Spread component.
Syntax
'Declaration
 
Public Property ShowParentRow As Boolean
'Usage
 
Dim instance As HierBarInfo
Dim value As Boolean
 
instance.ShowParentRow = value
 
value = instance.ShowParentRow
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
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;
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 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

HierBarInfo Class
HierBarInfo Members

 

 


Copyright © GrapeCity, inc. All rights reserved.