.NET Framework Class Library DataView..::.Table Property
Namespace:
System.Data
Assembly:
System.Data (in System.Data.dll)
Syntax
Public Property Table As DataTable
Get
Set
public DataTable Table { get; set; }
public:
property DataTable^ Table {
DataTable^ get ();
void set (DataTable^ value);
}
member Table : DataTable with get, set
Remarks
The DataTable also has a DefaultView property which returns the default DataView for the table. For example, if you want to create a custom view on the table, set the RowFilter on the DataView returned by the DefaultView. You can only set the Table property if the current value is null.
Examples
The following example gets the DataTable of the current DataView.
Private Sub DemonstrateDataViewTable()
Dim table As DataTable = 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 DataView = 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
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();
}
}
Version Information
.NET FrameworkSupported in: 4, 3.5, 3.0, 2.0, 1.1, 1.0 .NET Framework Client ProfileSupported in: 4, 3.5 SP1
Platforms
Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows XP SP2 x64 Edition, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role not supported), Windows Server 2003 SP2
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
See Also
|
Biblioteca de clases de .NET Framework DataView..::.Table (Propiedad)
Espacio de nombres:
System.Data
Ensamblado:
System.Data (en System.Data.dll)
Sintaxis
Public Property Table As DataTable
Get
Set
public DataTable Table { get; set; }
public:
property DataTable^ Table {
DataTable^ get ();
void set (DataTable^ value);
}
member Table : DataTable with get, set
Comentarios
DataTable también tiene una propiedad DefaultView que devuelve el DataView predeterminado para la tabla. Por ejemplo, si desea crear una vista personalizada en la tabla, establezca la propiedad RowFilter en el objeto DataView que devuelve la propiedad DefaultView. Sólo se puede establecer la propiedad Table si el valor actual es nulo.
Ejemplos
En el ejemplo siguiente se obtiene el DataTable del DataView actual.
Private Sub DemonstrateDataViewTable()
Dim table As DataTable = 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 DataView = 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
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();
}
}
Información de versión
.NET FrameworkCompatible con: 4, 3.5, 3.0, 2.0, 1.1, 1.0 .NET Framework Client ProfileCompatible con: 4, 3.5 SP1
Plataformas
Windows 7, Windows Vista SP1 o posterior, Windows XP SP3, Windows XP SP2 x64 Edition, Windows Server 2008 (no se admite Server Core), Windows Server 2008 R2 (se admite Server Core con SP1 o posterior), Windows Server 2003 SP2
.NET Framework no admite todas las versiones de todas las plataformas. Para obtener una lista de las versiones compatibles, vea Requisitos de sistema de .NET Framework.
Vea también
|