Spread for ASP.NET 11 Product Documentation
ShowParentRow Property
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > HierBarInfo Class : ShowParentRow Property
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
See Also

Reference

HierBarInfo Class
HierBarInfo Members