DataView.Table 属性

定义

命名空间:

System.Data

程序集:

System.Data.Common.dll

Source:

DataView.cs

获取或设置源 DataTable。

public:
 property System::Data::DataTable ^ Table { System::Data::DataTable ^ get(); void set(System::Data::DataTable ^ value); };

[System.ComponentModel.TypeConverter(typeof(System.Data.DataTableTypeConverter))]
public System.Data.DataTable? Table { get; set; }

[<System.ComponentModel.TypeConverter(typeof(System.Data.DataTableTypeConverter))>]
member this.Table : System.Data.DataTable with get, set

Public Property Table As DataTable

属性值

DataTable

为此视图提供数据的 DataTable。

属性

TypeConverterAttribute

示例

以下示例获取 DataTable 当前 DataView的 。

private static void DemonstrateDataViewTable()
{
    DataTable table = new DataTable();

    // add columns
    DataColumn column = table.Columns.Add("ProductID",
        typeof(int)	);
    column.AutoIncrement = true;
    column = table.Columns.Add("ProductName",
        typeof(string));

    // populate DataTable.
    for(int id=1; id<=5; id++)
    {
        table.Rows.Add(
            new object[]{ id, string.Format("product{0}", id) });
    }

    DataView view = new DataView(table);

    PrintTable(view.Table, "DataTable");
}

private static void PrintTable(DataTable table, string label)
{
    // This function prints values in the table or DataView.
    Console.WriteLine("\n" + label);
    foreach(DataRow row in table.Rows)
    {
        foreach(DataColumn column in table.Columns)
        {
            Console.Write("\table{0}", row[column]);
        }
        Console.WriteLine();
    }
}

Private Sub DemonstrateDataViewTable()
    Dim table As New DataTable()

    ' add columns
    Dim column As DataColumn = table.Columns.Add("ProductID", GetType(Integer))
    column.AutoIncrement = True
    column = table.Columns.Add("ProductName", GetType(String))

    ' populate DataTable.
    Dim id As Integer
    For id = 1 To 5
        table.Rows.Add(New Object() {id, String.Format("product{0}", id)})
    Next id

    Dim view As New DataView(table)

    PrintTable(view.Table, "DataTable")
End Sub

Private Sub PrintTable(ByVal table As DataTable, ByVal label As String)
    ' This function prints values in the table or DataView.
    Console.WriteLine("\n" + label)
    Dim row As DataRow
    Dim column As DataColumn
    For Each row In table.Rows
        For Each column In table.Columns
            Console.Write("\table{0}", row(column))
        Next column
    Next row
    Console.WriteLine()
End Sub

注解

还有 DataTable 一个 DefaultView 属性，该属性返回表的默认值 DataView 。 例如，如果要在表上创建自定义视图，请在 返回的 DefaultView上DataView设置 RowFilter 。

仅当当前值为 null 时，才能设置 Table 属性。

另请参阅

• DataTable
• 数据集、数据表和数据视图 (ADO.NET)