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


Row index in the model
Gets the data source row index for the specified row in the model.
Syntax
'Declaration
 
Public Function GetDataRowFromModelRow( _
   ByVal row As Integer _
) As Integer
'Usage
 
Dim instance As DefaultSheetDataModel
Dim row As Integer
Dim value As Integer
 
value = instance.GetDataRowFromModelRow(row)
public int GetDataRowFromModelRow( 
   int row
)

Parameters

row
Row index in the model

Return Value

Integer index of the row in the data source
Example
DataSet ds = new System.Data.DataSet(); 
DataTable name; 
DataTable city; 
name = ds.Tables.Add("Customers"); 
name.Columns.AddRange(new DataColumn[] {new DataColumn("LastName", typeof(string)), new DataColumn("FirstName", typeof(string)),
new DataColumn("ID", typeof(Int32))}); 
name.Rows.Add(new object[] {"Fielding", "William", 0}); 
name.Rows.Add(new object[] {"Williams", "Arthur", 1}); 
name.Rows.Add(new object[] {"Zuchini", "Theodore", 2}); 
city = ds.Tables.Add("City/State"); 
city.Columns.AddRange(new DataColumn[] {new DataColumn("City", typeof(string)), new DataColumn("Owner", typeof(Int32)), new
DataColumn("State", typeof(string))}); 
city.Rows.Add(new object[] {"Atlanta", 0, "Georgia"}); 
city.Rows.Add(new object[] {"Boston", 1, "Mass."}); 
city.Rows.Add(new object[] {"Tampa", 2, "Fla."}); 
ds.Relations.Add("City/State", name.Columns("ID"), city.Columns("Owner")); 
FarPoint.Web.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Web.Spread.Model.DefaultSheetDataModel(name.Rows.Count,
name.Columns.Count); 
dataModel.DataSource = ds; 
FpSpread1.ActiveSheetView.DataModel = dataModel; 
FpSpread1.ActiveSheetView.ExpandRow(0, true); 
int i; 
i = dataModel.GetDataRowFromModelRow(0);
Response.Write(i.ToString());
Dim ds = New System.Data.DataSet
Dim name As DataTable
Dim city As DataTable
name = ds.Tables.Add("Customers")
name.Columns.AddRange(New DataColumn() {New DataColumn("LastName", GetType(String)), New DataColumn("FirstName", GetType(String)),
New DataColumn("ID", GetType(Int32))})
name.Rows.Add(New Object() {"Fielding", "William", 0})
name.Rows.Add(New Object() {"Williams", "Arthur", 1})
name.Rows.Add(New Object() {"Zuchini", "Theodore", 2})
city = ds.Tables.Add("City/State")
city.Columns.AddRange(New DataColumn() {New DataColumn("City", GetType(String)), New DataColumn("Owner", GetType(Int32)),
New DataColumn("State", GetType(String))})
city.Rows.Add(New Object() {"Atlanta", 0, "Georgia"})
city.Rows.Add(New Object() {"Boston", 1, "Mass."})
city.Rows.Add(New Object() {"Tampa", 2, "Fla."})
ds.Relations.Add("City/State", name.Columns("ID"), city.Columns("Owner"))
Dim dataModel As New FarPoint.Web.Spread.Model.DefaultSheetDataModel(name.Rows.Count, name.Columns.Count)
dataModel.DataSource = ds
FpSpread1.ActiveSheetView.DataModel = dataModel
FpSpread1.ActiveSheetView.ExpandRow(0, True)
Dim i As Integer
i = dataModel.GetDataRowFromModelRow(0)
Response.Write(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

DefaultSheetDataModel Class
DefaultSheetDataModel Members

 

 


Copyright © GrapeCity, inc. All rights reserved.