Visual Basic (Declaration) | |
---|---|
Public Function GetModelColumnFromDataColumn( _ ByVal datacolumn As Integer _ ) As Integer |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As DefaultSheetDataModel Dim datacolumn As Integer Dim value As Integer value = instance.GetModelColumnFromDataColumn(datacolumn) |
C# | |
---|---|
public int GetModelColumnFromDataColumn( int datacolumn ) |
Parameters
- datacolumn
- Index of the column in the data source
Return Value
Integer index of the column in the modelThis example returns the column in the model for the specified data source column.
C# | Copy Code |
---|---|
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.GetModelColumnFromDataColumn(0); Response.Write(i.ToString()); |
Visual Basic | Copy Code |
---|---|
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.GetModelColumnFromDataColumn(0) Response.Write(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