DataTable.NewRow 方法
定义
public:
System::Data::DataRow ^ NewRow();
public System.Data.DataRow NewRow ();
member this.NewRow : unit -> System.Data.DataRow
Public Function NewRow () As DataRow
返回
与 DataTable 具有相同架构的 DataRow。A DataRow with the same schema as the DataTable.
示例
下面的示例创建了 DataTable ,并添加了两个 DataColumn 对象来确定表的架构,并使用方法创建了多个新的 DataRow 对象 NewRow 。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. DataRow然后,使用方法将这些对象添加到中 DataRowCollection Add 。Those DataRow objects are then added to the DataRowCollection using the Add method.
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;
}
Private Sub MakeDataTableAndDisplay()
' Create new DataTable and DataSource objects.
Dim table As 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
注解
您必须使用 NewRow 方法来创建新 DataRow 对象,其架构与相同 DataTable 。You must use the NewRow method to create new DataRow objects with the same schema as the DataTable. 创建后 DataRow ,可以 DataRowCollection 通过 DataTable 对象的属性将其添加到中 Rows 。After creating a DataRow, you can add it to the DataRowCollection, through the DataTable object's Rows property. 使用 NewRow 创建新行时,必须先在数据表中添加或删除行,然后再调用 Clear 。When you use NewRow to create new rows, the rows must be added to or deleted from the data table before you call Clear.