|
Dieser Artikel wurde maschinell übersetzt. Bewegen Sie den Mauszeiger über die Sätze im Artikel, um den Originaltext anzuzeigen. Weitere Informationen
|
Übersetzung
Original
|
DataTable-Klasse
System.ComponentModel.MarshalByValueComponent
System.Data.DataTable
System.Data.TypedTableBase<T>
Namespace: System.Data
Assembly: System.Data (in System.Data.dll)
Der DataTable-Typ macht die folgenden Member verfügbar.
| Name | Beschreibung | |
|---|---|---|
![]() ![]() | DataTable() | |
![]() ![]() | DataTable(String) | |
![]() | DataTable(SerializationInfo, StreamingContext) | |
![]() ![]() | DataTable(String, String) |
| Name | Beschreibung | |
|---|---|---|
![]() ![]() | CaseSensitive | |
![]() ![]() | ChildRelations | |
![]() ![]() | Columns | |
![]() ![]() | Constraints | |
![]() ![]() | Container | |
![]() ![]() | DataSet | |
![]() ![]() | DefaultView | |
![]() ![]() | DesignMode | |
![]() ![]() | DisplayExpression | |
![]() ![]() | Events | |
![]() ![]() | ExtendedProperties | |
![]() ![]() | HasErrors | |
![]() ![]() | IsInitialized | |
![]() ![]() | Locale | |
![]() ![]() | MinimumCapacity | |
![]() ![]() | Namespace | |
![]() ![]() | ParentRelations | |
![]() ![]() | Prefix | |
![]() ![]() | PrimaryKey | |
![]() | RemotingFormat | |
![]() ![]() | Rows | |
![]() ![]() | Site | |
![]() ![]() | TableName |
| Name | Beschreibung | |
|---|---|---|
![]() ![]() | AcceptChanges | |
![]() ![]() | BeginInit | |
![]() ![]() | BeginLoadData | |
![]() ![]() | Clear | |
![]() ![]() | Clone | |
![]() ![]() | Compute | |
![]() ![]() | Copy | |
![]() ![]() | CreateDataReader | |
![]() ![]() | CreateInstance | Infrastruktur. |
![]() ![]() | Dispose() | |
![]() ![]() | Dispose(Boolean) | |
![]() ![]() | EndInit | |
![]() ![]() | EndLoadData | |
![]() ![]() | Equals(Object) | |
![]() ![]() | Finalize | |
![]() ![]() | GetChanges() | |
![]() ![]() | GetChanges(DataRowState) | |
![]() ![]() ![]() | GetDataTableSchema | |
![]() ![]() | GetErrors | |
![]() ![]() | GetHashCode | |
![]() | GetObjectData | |
![]() ![]() | GetRowType | Infrastruktur. |
![]() ![]() | GetSchema | Infrastruktur. |
![]() ![]() | GetService | |
![]() ![]() | GetType | |
![]() ![]() | ImportRow | |
![]() ![]() | Load(IDataReader) | |
![]() ![]() | Load(IDataReader, LoadOption) | |
![]() ![]() | Load(IDataReader, LoadOption, FillErrorEventHandler) | |
![]() ![]() | LoadDataRow(Object[], Boolean) | |
![]() ![]() | LoadDataRow(Object[], LoadOption) | |
![]() ![]() | MemberwiseClone | |
![]() ![]() | Merge(DataTable) | |
![]() ![]() | Merge(DataTable, Boolean) | |
![]() ![]() | Merge(DataTable, Boolean, MissingSchemaAction) | |
![]() ![]() | NewRow | |
![]() ![]() | NewRowArray | Infrastruktur. |
![]() ![]() | NewRowFromBuilder | |
![]() ![]() | OnColumnChanged | |
![]() ![]() | OnColumnChanging | |
![]() ![]() | OnPropertyChanging | |
![]() | OnRemoveColumn | |
![]() ![]() | OnRowChanged | |
![]() ![]() | OnRowChanging | |
![]() ![]() | OnRowDeleted | |
![]() ![]() | OnRowDeleting | |
![]() ![]() | OnTableCleared | |
![]() ![]() | OnTableClearing | |
![]() ![]() | OnTableNewRow | |
![]() ![]() | ReadXml(Stream) | |
![]() ![]() | ReadXml(String) | |
![]() ![]() | ReadXml(TextReader) | |
![]() ![]() | ReadXml(XmlReader) | |
![]() ![]() | ReadXmlSchema(Stream) | |
![]() ![]() | ReadXmlSchema(String) | |
![]() ![]() | ReadXmlSchema(TextReader) | |
![]() ![]() | ReadXmlSchema(XmlReader) | |
![]() ![]() | ReadXmlSerializable | Infrastruktur. |
![]() ![]() | RejectChanges | |
![]() ![]() | Reset | |
![]() ![]() | Select() | |
![]() ![]() | Select(String) | |
![]() ![]() | Select(String, String) | |
![]() ![]() | Select(String, String, DataViewRowState) | |
![]() ![]() | ToString | |
![]() ![]() | WriteXml(Stream) | |
![]() ![]() | WriteXml(String) | |
![]() ![]() | WriteXml(TextWriter) | |
![]() ![]() | WriteXml(XmlWriter) | |
![]() ![]() | WriteXml(Stream, Boolean) | |
![]() ![]() | WriteXml(Stream, XmlWriteMode) | |
![]() ![]() | WriteXml(String, Boolean) | |
![]() ![]() | WriteXml(String, XmlWriteMode) | |
![]() ![]() | WriteXml(TextWriter, Boolean) | |
![]() ![]() | WriteXml(TextWriter, XmlWriteMode) | |
![]() ![]() | WriteXml(XmlWriter, Boolean) | |
![]() ![]() | WriteXml(XmlWriter, XmlWriteMode) | |
![]() ![]() | WriteXml(Stream, XmlWriteMode, Boolean) | |
![]() ![]() | WriteXml(String, XmlWriteMode, Boolean) | |
![]() ![]() | WriteXml(TextWriter, XmlWriteMode, Boolean) | |
![]() ![]() | WriteXml(XmlWriter, XmlWriteMode, Boolean) | |
![]() ![]() | WriteXmlSchema(Stream) | |
![]() ![]() | WriteXmlSchema(String) | |
![]() ![]() | WriteXmlSchema(TextWriter) | |
![]() ![]() | WriteXmlSchema(XmlWriter) | |
![]() ![]() | WriteXmlSchema(Stream, Boolean) | |
![]() ![]() | WriteXmlSchema(String, Boolean) | |
![]() ![]() | WriteXmlSchema(TextWriter, Boolean) | |
![]() ![]() | WriteXmlSchema(XmlWriter, Boolean) |
| Name | Beschreibung | |
|---|---|---|
![]() ![]() | ColumnChanged | |
![]() ![]() | ColumnChanging | |
![]() ![]() | Disposed | |
![]() ![]() | Initialized | |
![]() ![]() | RowChanged | |
![]() ![]() | RowChanging | |
![]() ![]() | RowDeleted | |
![]() ![]() | RowDeleting | |
![]() ![]() | TableCleared | |
![]() ![]() | TableClearing | |
![]() ![]() | TableNewRow |
| Name | Beschreibung | |
|---|---|---|
![]() | AsDataView | |
![]() | AsEnumerable |
| Name | Beschreibung | |
|---|---|---|
![]() ![]() | fInitInProgress | Infrastruktur. |
| Name | Beschreibung | |
|---|---|---|
![]() ![]() ![]() | IListSource.ContainsListCollection | |
![]() ![]() ![]() | IListSource.GetList | |
![]() ![]() ![]() | IXmlSerializable.GetSchema | |
![]() ![]() ![]() | IXmlSerializable.ReadXml | |
![]() ![]() ![]() | IXmlSerializable.WriteXml |
Hinweis |
|---|
| Topic | Location |
|---|---|
| Gewusst wie: Erstellen von DataTables | Datenzugriff in Visual Studio |
| Gewusst wie: Erstellen von DataTables | Datenzugriff in Visual Studio |
// Put the next line into the Declarations section. private System.Data.DataSet dataSet; private void MakeDataTables() { // Run all of the functions. MakeParentTable(); MakeChildTable(); MakeDataRelation(); BindToDataGrid(); } private void MakeParentTable() { // Create a new DataTable. System.Data.DataTable table = new DataTable("ParentTable"); // Declare variables for DataColumn and DataRow objects. DataColumn column; DataRow row; // Create new DataColumn, set DataType, // ColumnName and add to DataTable. column = new DataColumn(); column.DataType = System.Type.GetType("System.Int32"); column.ColumnName = "id"; column.ReadOnly = true; column.Unique = true; // Add the Column to the DataColumnCollection. table.Columns.Add(column); // Create second column. column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "ParentItem"; column.AutoIncrement = false; column.Caption = "ParentItem"; column.ReadOnly = false; column.Unique = false; // Add the column to the table. table.Columns.Add(column); // Make the ID column the primary key column. DataColumn[] PrimaryKeyColumns = new DataColumn[1]; PrimaryKeyColumns[0] = table.Columns["id"]; table.PrimaryKey = PrimaryKeyColumns; // Instantiate the DataSet variable. dataSet = new DataSet(); // Add the new DataTable to the DataSet. dataSet.Tables.Add(table); // Create three new DataRow objects and add // them to the DataTable for (int i = 0; i<= 2; i++) { row = table.NewRow(); row["id"] = i; row["ParentItem"] = "ParentItem " + i; table.Rows.Add(row); } } private void MakeChildTable() { // Create a new DataTable. DataTable table = new DataTable("childTable"); DataColumn column; DataRow row; // Create first column and add to the DataTable. column = new DataColumn(); column.DataType= System.Type.GetType("System.Int32"); column.ColumnName = "ChildID"; column.AutoIncrement = true; column.Caption = "ID"; column.ReadOnly = true; column.Unique = true; // Add the column to the DataColumnCollection. table.Columns.Add(column); // Create second column. column = new DataColumn(); column.DataType= System.Type.GetType("System.String"); column.ColumnName = "ChildItem"; column.AutoIncrement = false; column.Caption = "ChildItem"; column.ReadOnly = false; column.Unique = false; table.Columns.Add(column); // Create third column. column = new DataColumn(); column.DataType= System.Type.GetType("System.Int32"); column.ColumnName = "ParentID"; column.AutoIncrement = false; column.Caption = "ParentID"; column.ReadOnly = false; column.Unique = false; table.Columns.Add(column); dataSet.Tables.Add(table); // Create three sets of DataRow objects, // five rows each, and add to DataTable. for(int i = 0; i <= 4; i ++) { row = table.NewRow(); row["childID"] = i; row["ChildItem"] = "Item " + i; row["ParentID"] = 0 ; table.Rows.Add(row); } for(int i = 0; i <= 4; i ++) { row = table.NewRow(); row["childID"] = i + 5; row["ChildItem"] = "Item " + i; row["ParentID"] = 1 ; table.Rows.Add(row); } for(int i = 0; i <= 4; i ++) { row = table.NewRow(); row["childID"] = i + 10; row["ChildItem"] = "Item " + i; row["ParentID"] = 2 ; table.Rows.Add(row); } } private void MakeDataRelation() { // DataRelation requires two DataColumn // (parent and child) and a name. DataColumn parentColumn = dataSet.Tables["ParentTable"].Columns["id"]; DataColumn childColumn = dataSet.Tables["ChildTable"].Columns["ParentID"]; DataRelation relation = new DataRelation("parent2Child", parentColumn, childColumn); dataSet.Tables["ChildTable"].ParentRelations.Add(relation); } private void BindToDataGrid() { // Instruct the DataGrid to bind to the DataSet, with the // ParentTable as the topmost DataTable. dataGrid1.SetDataBinding(dataSet,"ParentTable"); }
Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core-Rolle wird nicht unterstützt), Windows Server 2008 R2 (Server Core-Rolle wird mit SP1 oder höher unterstützt; Itanium wird nicht unterstützt)
.NET Framework unterstützt nicht alle Versionen sämtlicher Plattformen. Eine Liste der unterstützten Versionen finden Sie unter Systemanforderungen für .NET Framework.

