|
Este artículo proviene de un motor de traducción automática. Mueva el puntero sobre las frases del artículo para ver el texto original. Más información.
|
Traducción
Original
|
DataTable (Clase)
System.ComponentModel.MarshalByValueComponent
System.Data.DataTable
System.Data.TypedTableBase<T>
Espacio de nombres: System.Data
Ensamblado: System.Data (en System.Data.dll)
El tipo DataTable expone los siguientes miembros.
| Nombre | Descripción | |
|---|---|---|
![]() ![]() | DataTable() | |
![]() ![]() | DataTable(String) | |
![]() | DataTable(SerializationInfo, StreamingContext) | |
![]() ![]() | DataTable(String, String) |
| Nombre | Descripción | |
|---|---|---|
![]() ![]() | CaseSensitive | |
![]() ![]() | ChildRelations | |
![]() ![]() | Columns | |
![]() ![]() | Constraints | |
![]() ![]() | Container | |
![]() ![]() | DataSet | |
![]() ![]() | DefaultView | |
![]() ![]() | DesignMode | |
![]() ![]() | DisplayExpression | |
![]() ![]() | Events | |
![]() ![]() | ExtendedProperties | |
![]() ![]() | HasErrors | |
![]() ![]() | IsInitialized | |
![]() ![]() | Locale | |
![]() ![]() | MinimumCapacity | |
![]() ![]() | Namespace | |
![]() ![]() | ParentRelations | |
![]() ![]() | Prefix | |
![]() ![]() | PrimaryKey | |
![]() | RemotingFormat | |
![]() ![]() | Rows | |
![]() ![]() | Site | |
![]() ![]() | TableName |
| Nombre | Descripción | |
|---|---|---|
![]() ![]() | AcceptChanges | |
![]() ![]() | BeginInit | |
![]() ![]() | BeginLoadData | |
![]() ![]() | Clear | |
![]() ![]() | Clone | |
![]() ![]() | Compute | |
![]() ![]() | Copy | |
![]() ![]() | CreateDataReader | |
![]() ![]() | CreateInstance | Infraestructura. |
![]() ![]() | Dispose() | |
![]() ![]() | Dispose(Boolean) | |
![]() ![]() | EndInit | |
![]() ![]() | EndLoadData | |
![]() ![]() | Equals(Object) | |
![]() ![]() | Finalize | |
![]() ![]() | GetChanges() | |
![]() ![]() | GetChanges(DataRowState) | |
![]() ![]() ![]() | GetDataTableSchema | |
![]() ![]() | GetErrors | |
![]() ![]() | GetHashCode | |
![]() | GetObjectData | |
![]() ![]() | GetRowType | Infraestructura. |
![]() ![]() | GetSchema | Infraestructura. |
![]() ![]() | 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 | Infraestructura. |
![]() ![]() | 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 | Infraestructura. |
![]() ![]() | 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) |
| Nombre | Descripción | |
|---|---|---|
![]() ![]() | ColumnChanged | |
![]() ![]() | ColumnChanging | |
![]() ![]() | Disposed | |
![]() ![]() | Initialized | |
![]() ![]() | RowChanged | |
![]() ![]() | RowChanging | |
![]() ![]() | RowDeleted | |
![]() ![]() | RowDeleting | |
![]() ![]() | TableCleared | |
![]() ![]() | TableClearing | |
![]() ![]() | TableNewRow |
| Nombre | Descripción | |
|---|---|---|
![]() | AsDataView | |
![]() | AsEnumerable |
| Nombre | Descripción | |
|---|---|---|
![]() ![]() | fInitInProgress | Infraestructura. |
| Nombre | Descripción | |
|---|---|---|
![]() ![]() ![]() | IListSource.ContainsListCollection | |
![]() ![]() ![]() | IListSource.GetList | |
![]() ![]() ![]() | IXmlSerializable.GetSchema | |
![]() ![]() ![]() | IXmlSerializable.ReadXml | |
![]() ![]() ![]() | IXmlSerializable.WriteXml |
Nota |
|---|
| Topic | Location |
|---|---|
| Cómo: Crear DataTables | Acceso a datos en Visual Studio |
| Cómo: Crear DataTables | Acceso a datos en 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 (no se admite el rol Server Core), Windows Server 2008 R2 (se admite el rol Server Core con SP1 o versiones posteriores; no se admite Itanium)
.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.

