Spread Windows Forms 11.0 Product Documentation
GetDataView Method (SheetView)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : GetDataView Method
Whether to re-create the DataView
Gets the DataView object on this sheet.
Syntax
'Declaration
 
Public Function GetDataView( _
   ByVal create As Boolean _
) As DataView
'Usage
 
Dim instance As SheetView
Dim create As Boolean
Dim value As DataView
 
value = instance.GetDataView(create)
public DataView GetDataView( 
   bool create
)

Parameters

create
Whether to re-create the DataView

Return Value

DataView object containing the view of the data table
Example
This example illustrates the use of this member by returning the parent table of the relation in the data view.
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);
fpSpread1.ActiveSheet.ExpandRow(0, true);
label1.Text = "The parent table of the data relation for the sheet is - " + fpSpread1.ActiveSheet.GetDataView(false).DataViewManager.DataSet.Relations["City/State"].ParentTable.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)
FpSpread1.ActiveSheet.ExpandRow(0, True)
Label1.Text = "The parent table of the data relation for the sheet is - " & FpSpread1.ActiveSheet.GetDataView(False).DataViewManager.DataSet.Relations("City/State").ParentTable.ToString()
See Also

Reference

SheetView Class
SheetView Members

User-Task Documentation

Managing Data Binding