Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / DefaultSheetDataModel Class / NextNonEmptyColumnInRow Method
Row index to search
Column index before the column to start searching (-1 to start at column 0)
Example


In This Topic
    NextNonEmptyColumnInRow Method (DefaultSheetDataModel)
    In This Topic
    Gets the index of the next column in a specified row that contains data.
    Syntax
    'Declaration
     
    Public Overrides Function NextNonEmptyColumnInRow( _
       ByVal row As Integer, _
       ByVal column As Integer _
    ) As Integer
    'Usage
     
    Dim instance As DefaultSheetDataModel
    Dim row As Integer
    Dim column As Integer
    Dim value As Integer
     
    value = instance.NextNonEmptyColumnInRow(row, column)
    public override int NextNonEmptyColumnInRow( 
       int row,
       int column
    )

    Parameters

    row
    Row index to search
    column
    Column index before the column to start searching (-1 to start at column 0)

    Return Value

    Integer column index for the next cell in the row containing a value, or -1 if no columns contain a value
    Remarks
    This method returns the index of the next column in the row that contains data.
    Example
    This example returns the index of the next column in a specified 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.NextNonEmptyColumnInRow(1, 2); 
    Response.Write(i.ToString());
    
    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.NextNonEmptyColumnInRow(1, 2)
    Response.Write(i.ToString())
    See Also