Spread Windows Forms 11.0 Product Documentation
GetModelRowFromDataRow Method (IDataSourceSupport)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > IDataSourceSupport Interface : GetModelRowFromDataRow Method
Data source row index to be converted
Converts the data source row index to the model row index.
Syntax
'Declaration
 
Function GetModelRowFromDataRow( _
   ByVal row As Integer _
) As Integer
'Usage
 
Dim instance As IDataSourceSupport
Dim row As Integer
Dim value As Integer
 
value = instance.GetModelRowFromDataRow(row)
int GetModelRowFromDataRow( 
   int row
)

Parameters

row
Data source row index to be converted

Return Value

Model row index
Example
This example converts the data source row index to the model row index.
FarPoint.Win.Spread.Model.IDataSourceSupport dss ;
DataTable dt = new DataTable("Testing");
int i;
dt.Columns.Add("Number");
dt.Columns.Add("Letter");
dt.Rows.Add(new Object[] {"1", "One"});
dt.Rows.Add(new Object[] {"2", "Two"});
dss = (FarPoint.Win.Spread.Model.IDataSourceSupport)fpSpread1.ActiveSheet.Models.Data;
fpSpread1.DataSource = dt;
i = dss.GetModelRowFromDataRow(1);
label1.Text = "The model row index is " + i.ToString();
Dim dss As FarPoint.Win.Spread.Model.IDataSourceSupport
Dim dt As New DataTable("Testing")
Dim i As Integer
dt.Columns.Add("Number")
dt.Columns.Add("Letter")
dt.Rows.Add(New Object() {"1", "One"})
dt.Rows.Add(New Object() {"2", "Two"})
dss = FpSpread1.ActiveSheet.Models.Data
FpSpread1.DataSource = dt
i = dss.GetModelRowFromDataRow(1)
Label1.Text = "The model row index is " & i.ToString()
See Also

Reference

IDataSourceSupport Interface
IDataSourceSupport Members