Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / GetChildRelation Method
Index of relation (child view)
Example


In This Topic
    GetChildRelation Method (SheetView)
    In This Topic
    Gets the name of the child data relation at the specified index on the sheet.
    Syntax
    'Declaration
     
    Public Overridable Function GetChildRelation( _
       ByVal index As Integer _
    ) As String
    'Usage
     
    Dim instance As SheetView
    Dim index As Integer
    Dim value As String
     
    value = instance.GetChildRelation(index)
    public virtual string GetChildRelation( 
       int index
    )

    Parameters

    index
    Index of relation (child view)

    Return Value

    String containing the name of the child relation
    Example
    This example gets the name of the child data relation at the specified index.
    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(1, true);
    string s;
    s = fpSpread1.ActiveSheet.GetChildRelation(0);
    listBox1.Items.Add(s.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(1, True)
    Dim s As String
    s = FpSpread1.ActiveSheet.GetChildRelation(0)
    ListBox1.Items.Add(s.ToString())
    See Also