DataSet.Relations Properti

Definisi

Ruang nama:

System.Data

Rakitan:

System.Data.Common.dll

Sumber:

DataSet.cs

Mendapatkan kumpulan relasi yang menautkan tabel dan mengizinkan navigasi dari tabel induk ke tabel anak.

public:
 property System::Data::DataRelationCollection ^ Relations { System::Data::DataRelationCollection ^ get(); };

public System.Data.DataRelationCollection Relations { get; }

member this.Relations : System.Data.DataRelationCollection

Public ReadOnly Property Relations As DataRelationCollection

Nilai Properti

DataRelationCollection

DataRelationCollection yang berisi kumpulan DataRelation objek. Koleksi kosong dikembalikan jika tidak ada DataRelation objek.

Contoh

Contoh berikut mencetak nama kolom semua tabel anak melalui Relations properti .

Private Sub PrintChildRelationRows()
   ' Declare variable to hold the row values.
   Dim rowValues As String
   Dim dataSet As DataSet

   ' Get the DataSet of a DataGrid that is displaying data 
   ' of at least two tables.
   Dim table As DataTable = CType(DataGrid1.DataSource, DataTable)

   ' Navigate using the Relations.
   Dim relation As DataRelation
   Dim row As DataRow
   Dim column As DataColumn

   ' Print the names of each column in each table.
   For Each relation In dataSet.Relations
      For Each column in relation.ChildTable.Columns
          rowValues &= column.ColumnName & " "
      Next
    Next

    ' Display results.
    Console.WriteLine(rowValues)
   End Sub

Lihat juga

• Menggunakan Himpunan Data di ADO.NET