Visual Basic (Declaration) | |
---|---|
Public Overridable Function GetRowExpandable( _ ByVal row As Integer _ ) As Boolean |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As SheetView Dim row As Integer Dim value As Boolean value = instance.GetRowExpandable(row) |
Parameters
- row
- Row index
Return Value
true if row is expandable; false otherwiseException | Description |
---|---|
System.ArgumentOutOfRangeException | Specified row is out of range; must be between 0 and the number of rows |
This example returns if the specified row can be expanded.
C# | Copy Code |
---|---|
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()); |
Visual Basic | Copy Code |
---|---|
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()) |
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
Reference
SheetView ClassSheetView Members
SetRowExpandable Method
IsRowExpanded Method