Gets the index of the next non-empty row after the specified row index.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Overrides Function NextNonEmptyRow( _
ByVal row As Integer _
) As Integer |
| C# | |
|---|
public override int NextNonEmptyRow(
int row
) |
Parameters
- row
- Row index to start searching after (-1 to start at row 0)
Return Value
Integer row index for the next row containing a value, or -1 if no rows contain a value
Remarks
Example
This example returns the index of the next row that contains data.
| C# |  Copy Code |
|---|
FarPoint.Web.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Web.Spread.Model.DefaultSheetDataModel();
DataSet ds = new DataSet();
DataTable name;
name = ds.Tables.Add("Name");
name.Columns.Add("FirstName", Type.GetType("System.String"));
name.Columns.Add("LastName", Type.GetType("System.String"));
name.Rows.Add(new object[] {"John", "Doe"});
name.Rows.Add(new object[] {"Sally ", "Jones"});
name.Rows.Add(new object[] {"Terry", "Hernandez"});
dataModel.DataSource = ds;
FpSpread1.ActiveSheetView.DataModel = dataModel;
dataModel.AddUnboundRows(1, 2);
name.Rows.Add(new object[] {"Jane", "Simpson"});
int i;
i = dataModel.NextNonEmptyRow(1);
Response.Write(i.ToString());
|
| Visual Basic | Copy Code |
|---|
Dim dataModel As New FarPoint.Web.Spread.Model.DefaultSheetDataModel
Dim ds As New DataSet
Dim name As DataTable
name = ds.Tables.Add("Name")
name.Columns.Add("FirstName", Type.GetType("System.String"))
name.Columns.Add("LastName", Type.GetType("System.String"))
name.Rows.Add(New Object() {"John", "Doe"})
name.Rows.Add(New Object() {"Sally ", "Jones"})
name.Rows.Add(New Object() {"Terry", "Hernandez"})
dataModel.DataSource = ds
FpSpread1.ActiveSheetView.DataModel = dataModel
dataModel.AddUnboundRows(1, 2)
name.Rows.Add(New Object() {"Jane", "Simpson"})
Dim i As Integer
i = dataModel.NextNonEmptyRow(1)
Response.Write(i.ToString()) |
Requirements
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
See Also
