ExpandImage Field

Specifies the identifier for the image for the expand icon in hierarchical displays in the component.

Syntax

Visual Basic
C#

'Declaration
 
Public Const ExpandImage As Integer

'Usage
 
Dim value As Integer
 
value = FpSpread.ExpandImage

public const int ExpandImage

Field Value

Integer identifier for the hierarchy expand image, 0

Example

System.Data.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.SetImage(FarPoint.Web.Spread.FpSpread.ExpandImage, "D:\\plus.bmp");
FpSpread1.SetImage(FarPoint.Web.Spread.FpSpread.CollapseImage, "D:\\minus.bmp");

Visual Basic

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
FpSpread1.SetImage(FarPoint.Web.Spread.FpSpread.ExpandImage, "D:\plus.bmp")
FpSpread1.SetImage(FarPoint.Web.Spread.FpSpread.CollapseImage, "D:\minus.bmp")

Remarks

This is always set to 0. For the SetImage method, you can either use the full name of this field or the constant value of 0 to identify the expand image.

Any of several parts of the graphical interface of the component can be customized. This one identifies the image in the hierarchy display that is clicked to expand the hierarchy. Refer to Customizing the Graphical Interface for more information.

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

FpSpread Class
FpSpread Members
SetImage Method

User-Task Documentation

Customizing the Graphical Interface