Spread ASP.NET 15
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / DefaultSheetDataModel Class / NextNonEmptyRow Method
Row index to start searching after (-1 to start at row 0)

In This Topic
    NextNonEmptyRow Method (DefaultSheetDataModel)
    In This Topic
    Gets the index of the next non-empty row after the specified row index.
    Public Overrides Function NextNonEmptyRow( _
       ByVal row As Integer _
    ) As Integer
    Dim instance As DefaultSheetDataModel
    Dim row As Integer
    Dim value As Integer
    value = instance.NextNonEmptyRow(row)
    public override int NextNonEmptyRow( 
       int 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
    This method returns the index of the next row that contains data.
    This example returns the index of the next row that contains data.
    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); 
    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)
    See Also