ChildViewCreated Event

Occurs when the user creates a child sheet.

Syntax

Visual Basic
C#

'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.

Property	Description
Pager	Gets or sets the page navigation.
SheetView	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;
     }
}

Visual Basic

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

Reference

FpSpread Class
FpSpread Members

Product Support Forum | Print this page