DataTable.NewRow 方法

来源:互联网 发布:韩顺平php老吗 编辑:程序博客网 时间:2024/06/10 05:50
.NET Framework 类库 

DataTable.NewRow 方法

创建与该表具有相同架构的新 DataRow

[Visual Basic]Public Function NewRow() As DataRow[C#]public DataRow NewRow();[C++]public: DataRow* NewRow();[JScript]public function NewRow() : DataRow;

返回值

DataRow,其架构与 DataTable 的架构相同。

备注

必须使用 NewRow 方法才能创建与 DataTable 具有相同架构的新 DataRow 对象。在创建 DataRow 之后,可以通过 DataTable 对象的 Rows 属性将其添加到 DataRowCollection 中。

示例

[Visual Basic, C#, C++] 以下示例创建一个 DataTable、添加两个用于确定表的架构的 DataColumn 对象、使用 NewRow 方法创建几个新的 DataRow 对象。然后使用 Add 方法将这些 DataRow 对象添加到 DataRowCollection 中。

[Visual Basic] Private Sub MakeDataTableAndDisplay()   ' Create new DataTable and DataSource objects.   Dim myDataTable As DataTable = New DataTable()   ' Declare DataColumn and DataRow variables.   Dim myColumn As DataColumn    Dim myRow As DataRow    Dim myDataView As DataView    ' Create new DataColumn, set DataType, ColumnName and add to DataTable.       myColumn = New DataColumn()   myColumn.DataType = System.Type.GetType("System.Int32")   myColumn.ColumnName = "id"   myDataTable.Columns.Add(myColumn)   ' Create second column.   myColumn = New DataColumn()   myColumn.DataType = Type.GetType("System.String")   myColumn.ColumnName = "item"   myDataTable.Columns.Add(myColumn)   ' Create new DataRow objects and add to DataTable.       Dim i As Integer   For i = 0 to 9       myRow = myDataTable.NewRow()      myRow("id") = i      myRow("item") = "item " & i      myDataTable.Rows.Add(myRow)   Next   ' Create a DataView using the DataTable.   myDataView = New DataView(myDataTable)   ' Set a DataGrid control's DataSource to the DataView.   DataGrid1.DataSource = myDataViewEnd Sub[C#] private void MakeDataTableAndDisplay(){   // Create new DataTable and DataSource objects.   DataTable myDataTable = new DataTable();   // Declare DataColumn and DataRow variables.   DataColumn myColumn;   DataRow myRow;    DataView myDataView;   // Create new DataColumn, set DataType, ColumnName and add to DataTable.       myColumn = new DataColumn();   myColumn.DataType = System.Type.GetType("System.Int32");   myColumn.ColumnName = "id";   myDataTable.Columns.Add(myColumn);   // Create second column.   myColumn = new DataColumn();   myColumn.DataType = Type.GetType("System.String");   myColumn.ColumnName = "item";   myDataTable.Columns.Add(myColumn);   // Create new DataRow objects and add to DataTable.       for(int i = 0; i < 10; i++){      myRow = myDataTable.NewRow();      myRow["id"] = i;      myRow["item"] = "item " + i.ToString();      myDataTable.Rows.Add(myRow);   }   // Create a DataView using the DataTable.   myDataView = new DataView(myDataTable);   // Set a DataGrid control's DataSource to the DataView.   dataGrid1.DataSource = myDataView;}[C++] private: void MakeDataTableAndDisplay(){    // Create new DataTable and DataSource objects.    DataTable* myDataTable = new DataTable();    // Declare DataColumn and DataRow variables.    DataColumn* myColumn;    DataRow* myRow;     DataView* myDataView;    // Create new DataColumn, set DataType, ColumnName and add to DataTable.        myColumn = new DataColumn();    myColumn->DataType = System::Type::GetType(S"System.Int32");    myColumn->ColumnName = S"id";    myDataTable->Columns->Add(myColumn);     // Create second column.    myColumn = new DataColumn();    myColumn->DataType = Type::GetType(S"System.String");    myColumn->ColumnName = S"item";    myDataTable->Columns->Add(myColumn);     // Create new DataRow objects and add to DataTable.        for(int i = 0; i < 10; i++){       myRow = myDataTable->NewRow();       myRow->Item[S"id"] = __box(i);       myRow->Item[S"item"] = String::Format( S"item {0}", __box(i));       myDataTable->Rows->Add(myRow);    }     // Create a DataView using the DataTable.    myDataView = new DataView(myDataTable);    // Set a DataGrid control's DataSource to the DataView.    dataGrid1->DataSource = myDataView; }

[JScript] 没有可用于 JScript 的示例。若要查看 Visual Basic、C# 或 C++ 示例,请单击页左上角的“语言筛选器”按钮 语言筛选器

要求

平台: Windows 98, Windows NT 4.0, Windows ME, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 系列, .NET Framework 精简版

请参见

DataTable 类 | DataTable 成员 | System.Data 命名空间 | AcceptChanges | Add | DataColumnCollection | DataColumn | DataRowCollection