Spread for ASP.NET 11 Product Documentation
NextNonEmptyColumnInRow Method (DefaultSheetDataModel)
Example 


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)
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

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members