Spread for ASP.NET 8.0 Product Documentation
GetDataRowFromModelRow Method (IDataSourceSupport)
Example 


Model row index to be converted
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());
Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

IDataSourceSupport Interface
IDataSourceSupport Members

 

 


Copyright © GrapeCity, inc. All rights reserved.