Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / FpSpread Class / ChildViewCreated Event
Example


In This Topic
    ChildViewCreated Event
    In This Topic
    Occurs when the user creates a child sheet.
    Syntax
    'Declaration
     
    Public Event ChildViewCreated As CreateChildViewEventHandler
    'Usage
     
    Dim instance As FpSpread
    Dim handler As CreateChildViewEventHandler
     
    AddHandler instance.ChildViewCreated, handler
    public event CreateChildViewEventHandler ChildViewCreated
    Event Data

    The event handler receives an argument of type CreateChildViewEventArgs containing data related to this event. The following CreateChildViewEventArgs properties provide information specific to this event.

    PropertyDescription
    Gets or sets the page navigation.  
    Gets the child sheet (SheetView object) being created.  
    Remarks
    The SpreadImage class is not supported in the ChildViewCreated event.
    Example
    This example illustrates the use of the event.
    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.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.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