Spread for ASP.NET 9.0 Product Documentation
GetRowExpandable Method
Example 


Row index
Gets whether the row on this sheet is expandable in the hierarchical display.
Syntax
'Declaration
 
Public Overridable Function GetRowExpandable( _
   ByVal row As Integer _
) As Boolean
'Usage
 
Dim instance As SheetView
Dim row As Integer
Dim value As Boolean
 
value = instance.GetRowExpandable(row)
public virtual bool GetRowExpandable( 
   int row
)

Parameters

row
Row index

Return Value

true if row is expandable; false otherwise
Exceptions
ExceptionDescription
System.ArgumentOutOfRangeException Specified row is out of range; must be between 0 and the number of rows
Example
This example returns if the specified row can be expanded.
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.ActiveSheetView.SetRowExpandable(0, false);
bool b;
b = FpSpread1.ActiveSheetView.GetRowExpandable(0);
Response.Write("The row can be expanded is " + b.ToString());
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.ActiveSheetView.DataSource = ds
FpSpread1.ActiveSheetView.SetRowExpandable(0, False)
Dim b As Boolean
b = FpSpread1.ActiveSheetView.GetRowExpandable(0)
Response.Write("The row can be expanded is " & b.ToString())
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

SheetView Class
SheetView Members
SetRowExpandable Method
IsRowExpanded Method

User-Task Documentation

Handling Row Expansion

 

 


Copyright © GrapeCity, inc. All rights reserved.