Spread Windows Forms 10.0 Product Documentation
GetModelRowFromViewRow Method
Example 


Gets the row index in the data model that corresponds to the specified row index in the sheet.
Overload List
OverloadDescription
GetModelRowFromViewRowGets the row index in the data model that corresponds to the specified row index in the sheet.  
Example
This example gets the model row index from the specified view row index.
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"]);
fpSpread1.ActiveSheet.DataSource = ds;  
fpSpread1.ActiveSheet.DataMember = "Customers";
fpSpread1.ActiveSheet.SetColumnWidth(2, 150); 
int i;
i = fpSpread1.ActiveSheet.GetModelRowFromViewRow(1);
listBox1.Items.Add(i.ToString());
Dim ds As 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", Type.GetType("System.String")), New DataColumn("FirstName",
Type.GetType("System.String")), New DataColumn("ID", Type.GetType("System.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", Type.GetType("System.String")), New DataColumn("Owner", Type.GetType("System.Int32")),
New DataColumn("State", Type.GetType("System.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"))
FpSpread1.ActiveSheet.DataSource = ds
FpSpread1.ActiveSheet.DataMember = "Customers"
FpSpread1.ActiveSheet.SetColumnWidth(2, 150)
Dim i As Integer
i = FpSpread1.ActiveSheet.GetModelRowFromViewRow(1)
ListBox1.Items.Add(i.ToString())
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

SheetView Class
SheetView Members

User-Task Documentation

Using Sheet Models

 

 


Copyright © GrapeCity, inc. All rights reserved.