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

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


    Model row index to be converted

    Return Value

    Integer index of the row in the data source
    This example binds the model to a data set.
    string strConn  = "data source =;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();
    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 =;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
    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