.NET Framework Class Library DataTable..::.NewRow Method Creates a new DataRow with the same schema as the table. (in System.Data.dll)
Syntax
Public Function NewRow As DataRow
public:
DataRow^ NewRow()
member NewRow : unit -> DataRow
Remarks
You must use the NewRow method to create new DataRow objects with the same schema as the DataTable. After creating a DataRow, you can add it to the DataRowCollection, through the DataTable object's Rows property. When you use NewRow to create new rows, the rows must be added to or deleted from the data table before you call Clear.
Examples
The following example creates a DataTable, adds two DataColumn objects that determine the table's schema, and creates several new DataRow objects using the NewRow method. Those DataRow objects are then added to the DataRowCollection using the Add method.
Private Sub MakeDataTableAndDisplay()
' Create new DataTable and DataSource objects.
Dim table As DataTable = New DataTable()
' Declare DataColumn and DataRow variables.
Dim column As DataColumn
Dim row As DataRow
Dim view As DataView
' Create new DataColumn, set DataType, ColumnName and add to DataTable.
column = New DataColumn()
column.DataType = System.Type.GetType("System.Int32")
column.ColumnName = "id"
table.Columns.Add(column)
' Create second column.
column = New DataColumn()
column.DataType = Type.GetType("System.String")
column.ColumnName = "item"
table.Columns.Add(column)
' Create new DataRow objects and add to DataTable.
Dim i As Integer
For i = 0 to 9
row = table.NewRow()
row("id") = i
row("item") = "item " & i
table.Rows.Add(row)
Next
' Create a DataView using the DataTable.
view = New DataView(table)
' Set a DataGrid control's DataSource to the DataView.
DataGrid1.DataSource = view
End Sub
private void MakeDataTableAndDisplay()
{
// Create new DataTable and DataSource objects.
DataTable table = new DataTable();
// Declare DataColumn and DataRow variables.
DataColumn column;
DataRow row;
DataView view;
// Create new DataColumn, set DataType, ColumnName and add to DataTable.
column = new DataColumn();
column.DataType = System.Type.GetType("System.Int32");
column.ColumnName = "id";
table.Columns.Add(column);
// Create second column.
column = new DataColumn();
column.DataType = Type.GetType("System.String");
column.ColumnName = "item";
table.Columns.Add(column);
// Create new DataRow objects and add to DataTable.
for(int i = 0; i < 10; i++)
{
row = table.NewRow();
row["id"] = i;
row["item"] = "item " + i.ToString();
table.Rows.Add(row);
}
// Create a DataView using the DataTable.
view = new DataView(table);
// Set a DataGrid control's DataSource to the DataView.
dataGrid1.DataSource = view;
}
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 DataTable..::.NewRow (Método) Crea un nuevo DataRow con el mismo esquema que la tabla. (en System.Data.dll)
Sintaxis
Public Function NewRow As DataRow
public:
DataRow^ NewRow()
member NewRow : unit -> DataRow
Comentarios
Se debe utilizar el método NewRow para crear nuevos objetos DataRow con el mismo esquema que DataTable. Después de crear DataRow, se puede agregar a DataRowCollection mediante la propiedad Rows del objeto DataTable. Al utilizar NewRow para crear nuevas filas, las filas se deben agregar a o eliminar de la tabla de datos antes de llamar a Clear.
Ejemplos
En el ejemplo siguiente se crea un DataTable, se agregan dos objetos DataColumn que determinan el esquema de la tabla y se crean varios objetos DataRow nuevos mediante el método NewRow. Esos objetos DataRow se agregan a DataRowCollection mediante el método Add.
Private Sub MakeDataTableAndDisplay()
' Create new DataTable and DataSource objects.
Dim table As DataTable = New DataTable()
' Declare DataColumn and DataRow variables.
Dim column As DataColumn
Dim row As DataRow
Dim view As DataView
' Create new DataColumn, set DataType, ColumnName and add to DataTable.
column = New DataColumn()
column.DataType = System.Type.GetType("System.Int32")
column.ColumnName = "id"
table.Columns.Add(column)
' Create second column.
column = New DataColumn()
column.DataType = Type.GetType("System.String")
column.ColumnName = "item"
table.Columns.Add(column)
' Create new DataRow objects and add to DataTable.
Dim i As Integer
For i = 0 to 9
row = table.NewRow()
row("id") = i
row("item") = "item " & i
table.Rows.Add(row)
Next
' Create a DataView using the DataTable.
view = New DataView(table)
' Set a DataGrid control's DataSource to the DataView.
DataGrid1.DataSource = view
End Sub
private void MakeDataTableAndDisplay()
{
// Create new DataTable and DataSource objects.
DataTable table = new DataTable();
// Declare DataColumn and DataRow variables.
DataColumn column;
DataRow row;
DataView view;
// Create new DataColumn, set DataType, ColumnName and add to DataTable.
column = new DataColumn();
column.DataType = System.Type.GetType("System.Int32");
column.ColumnName = "id";
table.Columns.Add(column);
// Create second column.
column = new DataColumn();
column.DataType = Type.GetType("System.String");
column.ColumnName = "item";
table.Columns.Add(column);
// Create new DataRow objects and add to DataTable.
for(int i = 0; i < 10; i++)
{
row = table.NewRow();
row["id"] = i;
row["item"] = "item " + i.ToString();
table.Rows.Add(row);
}
// Create a DataView using the DataTable.
view = new DataView(table);
// Set a DataGrid control's DataSource to the DataView.
dataGrid1.DataSource = view;
}
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
|