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 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 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
Reference
SheetView ClassSheetView Members
SetRowExpandable Method
IsRowExpanded Method