Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / IDataSourceSupport Interface / GetDataRowFromModelRow Method
Model row index to be converted
Example


In This Topic
    GetDataRowFromModelRow Method (IDataSourceSupport)
    In This Topic
    Converts the model row index to the data source row index.
    Syntax
    'Declaration
     
    Function GetDataRowFromModelRow( _
       ByVal row As Integer _
    ) As Integer
    'Usage
     
    Dim instance As IDataSourceSupport
    Dim row As Integer
    Dim value As Integer
     
    value = instance.GetDataRowFromModelRow(row)
    int GetDataRowFromModelRow( 
       int row
    )

    Parameters

    row
    Model row index to be converted

    Return Value

    Integer index of the row in the data source
    Example
    This example binds the model to a data set.
    string strConn  = "data source = 127.0.0.1;initial catalog=Pubs; integrated security = SSPI";
    string sqlStr = "SELECT * FROM Authors; Select * From Titles";
    
    System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(sqlStr, strConn);
    DataSet ds = new DataSet();
    da.Fill(ds);
    
    FarPoint.Web.Spread.Model.IDataSourceSupport dss;
    dss = (FarPoint.Web.Spread.Model.IDataSourceSupport)FpSpread1.ActiveSheetView.DataModel;
    dss.AutoGenerateColumns = true;
    dss.DataSource = ds;
    dss.DataMember = "Table";
    dss.DataKeyField = "auid";
    
    int i;
    i = dss.GetDataRowFromModelRow(2);
    Response.Write("The data row is " + i.ToString());
    
    Dim strConn As String = "data source = 127.0.0.1;initial catalog=Pubs; integrated security = SSPI"
    Dim sqlStr As String = "SELECT * FROM Authors; Select * From Titles"
    
    Dim da As New System.Data.SqlClient.SqlDataAdapter(sqlStr, strConn)
    Dim ds As New DataSet
    da.Fill(ds)
    
    Dim dss As FarPoint.Web.Spread.Model.IDataSourceSupport
    dss = FpSpread1.ActiveSheetView.DataModel
    dss.AutoGenerateColumns = True
    dss.DataSource = ds
    dss.DataMember = "Table"
    dss.DataKeyField = "auid"
    
    Dim i As Integer
    i = dss.GetDataRowFromModelRow(2);
    Response.Write("The data row is " + i.ToString());
    See Also