.NET Framework 类库 |
不带参数初始化 DataTable 类的新实例。
[Visual Basic] Public Sub New() [C#] public DataTable(); [C++] public: DataTable(); [JScript] public function DataTable();
备注
构造函数为 DataTable 对象的所有属性设置初始值。下表显示这些属性及其默认值。当创建 DataTable 的实例时,以下读/写属性将被设置为初始值。
属性 | 默认值 |
---|---|
区分大小写 | 如果它属于一个,则与父级 DataSet 相同。否则为 false。 |
显示表达式 | 空字符串 ("") |
区域设置 | 与父级 DataSet 对象的 CultureInfo(由 Locale 属性返回)相同;如果不存在任何父对象,则默认为当前系统的 CultureInfo。 |
最小容量 | 25 行。 |
通过单独调用属性,可以更改这些属性值中的任何一个。
示例
[Visual Basic, C#, C++] 以下示例创建具有 DataColumn 和 DataRow 的新 DataTable,并在 DataGrid 控件中显示它。
[Visual Basic] Private Sub MakeDataTableAndDisplay() ' Create new DataTable. Dim myDataTable As New DataTable ' Declare DataColumn and DataRow variables. Dim myDataColumn As DataColumn Dim myDataRow As DataRow ' Create new DataColumn, set DataType, ColumnName and add to DataTable. myDataColumn = New DataColumn myDataColumn.DataType = System.Type.GetType("System.Int32") myDataColumn.ColumnName = "id" myDataTable.Columns.Add(myDataColumn) ' Create second column. myDataColumn = New DataColumn myDataColumn.DataType = Type.GetType("System.String") myDataColumn.ColumnName = "item" myDataTable.Columns.Add(myDataColumn) ' Create new DataRow objects and add to DataTable. Dim i As Integer For i = 0 To 10 myDataRow = myDataTable.NewRow myDataRow("id") = i myDataRow("item") = "item " & i myDataTable.Rows.Add(myDataRow) Next i ' Set to DataGrid.DataSource property to the table. DataGrid1.DataSource = myDataTable End Sub [C#] private void MakeDataTableAndDisplay(){ // Create new DataTable. DataTable myDataTable = new DataTable(); // Declare DataColumn and DataRow variables. DataColumn myDataColumn; DataRow myDataRow; // Create new DataColumn, set DataType, ColumnName and add to DataTable. myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.Int32"); myDataColumn.ColumnName = "id"; myDataTable.Columns.Add(myDataColumn); // Create second column. myDataColumn = new DataColumn(); myDataColumn.DataType = Type.GetType("System.String"); myDataColumn.ColumnName = "item"; myDataTable.Columns.Add(myDataColumn); // Create new DataRow objects and add to DataTable. for(int i = 0; i < 10; i++){ myDataRow = myDataTable.NewRow(); myDataRow["id"] = i; myDataRow["item"] = "item " + i; myDataTable.Rows.Add(myDataRow); } // Set to DataGrid.DataSource property to the table. dataGrid1.DataSource = myDataTable; } [C++] private: void MakeDataTableAndDisplay(){ // Create new DataTable. DataTable* myDataTable = new DataTable(); // Declare DataColumn and DataRow variables. DataColumn* myDataColumn; DataRow* myDataRow; // Create new DataColumn, set DataType, ColumnName and add to DataTable. myDataColumn = new DataColumn(); myDataColumn->DataType = System::Type::GetType(S"System.Int32"); myDataColumn->ColumnName = S"id"; myDataTable->Columns->Add(myDataColumn); // Create second column. myDataColumn = new DataColumn(); myDataColumn->DataType = Type::GetType(S"System.String"); myDataColumn->ColumnName = S"item"; myDataTable->Columns->Add(myDataColumn); // Create new DataRow objects and add to DataTable. for(int i = 0; i < 10; i++){ myDataRow = myDataTable->NewRow(); myDataRow->Item[S"id"] = __box(i); myDataRow->Item[S"item"] = String::Format( S"item {0}", __box(i)); myDataTable->Rows->Add(myDataRow); } // Set to DataGrid.DataSource property to the table. dataGrid1->DataSource = myDataTable; }
[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 命名空间 | DataTable 构造函数重载列表 | DataColumn | DataRow | DataView