Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / CreateChildViewEventArgs Class / SheetView Property
Example


In This Topic
    SheetView Property (CreateChildViewEventArgs)
    In This Topic
    Gets the child sheet (SheetView object) being created.
    Syntax
    'Declaration
     
    Public ReadOnly Property SheetView As SheetView
    'Usage
     
    Dim instance As CreateChildViewEventArgs
    Dim value As SheetView
     
    value = instance.SheetView
    public SheetView SheetView {get;}

    Property Value

    SheetView object containing the sheet
    Example
    This example changes the color of the row in the child relation based on the relation name.
    System.Data.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.ActiveSheetView.DataSource = ds;
    
    private void FpSpread1ChildViewCreated(object sender, FarPoint.Web.Spread.CreateChildViewEventArgs e) 
    {
        if (e.SheetView.RelationName = "City/State")
        {
            e.SheetView.Rows(0).BackColor = Color.Yellow;
        }
    }
    
    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.ActiveSheetView.DataSource = ds
    
    Private Sub FpSpread1ChildViewCreated(ByVal sender As Object, ByVal e As FarPoint.Web.Spread.CreateChildViewEventArgs) Handles
    FpSpread1.ChildViewCreated
        If e.SheetView.RelationName = "City/State" Then
            e.SheetView.Rows(0).BackColor = Color.Yellow
        End If
    End Sub
    See Also