FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > IDataSourceSupport Interface : GetModelRowFromDataRow Method |
'Usage Dim instance As IDataSourceSupport Dim row As Integer Dim value As Integer value = instance.GetModelRowFromDataRow(row)
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.GetModelRowFromDataRow(2); Response.Write("The model 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.GetModelRowFromDataRow(2); Response.Write("The model row is " + i.ToString());
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