Collection Editors

You use collection editors to modify lists of entities of various types. For example, you can use collection editors to modify the list of columns in a dataset or the list of parameters to a stored procedure. This topic describes each type of collection editor.

Types of Collection Editors

Collection Editor

Notes

Columns Collection Editor

Enables you to create and configure columns (DataColumn objects) in a dataset DataTable object.

Note

You can use this dialog box to create columns only in an untyped dataset. For typed datasets, you create tables and columns by using the Creating and Editing Typed Datasets. For more information, see How to: Create Data Tables.

Constraints Collection Editor

Enables you to create and configure constraints (Constraint objects) in a DataTable object. Constraints are rules that help preserve the integrity of data in a table. You can create two types of constraints:

Parameters Collection Editor

Enables you to create and configure parameters (OleDbParameter, SqlParameter, OdbcParameter, and OracleParameter objects) associated with a SQL statement or stored procedure in TableAdapters and data adapters.

Relations Collection Editor

Enables you to create, edit, and delete the Relations property of an untyped dataset, which contains a collection of DataRelation objects.

Note

You can use this collection editor to create DataRelation objects only in an untyped dataset. For typed datasets, you create tables and columns using the Creating and Editing Typed Datasets. For more information, see How to: Create DataRelations with the Dataset Designer.

Tables Collection Editor

Enables you to add and remove DataTable objects to or from an untyped dataset. This dialog box appears when you are using the Properties window to edit the Tables property of an untyped dataset on a form or component.

XMLField Collection Editor

Enables you to add or remove <field> elements to the current <key> element. The XmlField Collection Editor appears when you are using the XmlKeyConstraint Collection Editor and click the ellipsis button next to the fields property of an existing key.

XmlImport Collection Editor

Enables you to add or remove <import> elements to the current XML Schema. The <import> element identifies the namespace and location of imported schemas. The XmlImport Collection Editor appears when you are using the Properties window and click the ellipsis button next to the import property of an XML Schema.

XmlInclude Collection Editor

Enables you to add or remove <include> elements to the current XML Schema. The <include> element specifies the location of a schema document in the target namespace. The XmlInclude Collection Editor appears when you are using the Properties window and click the ellipsis button next to the include property of an XML Schema.

XmlKeyConstraint Collection Editor

Enables you to add or remove <key> and <unique> elements to the current XML Schema. The XmlKeyConstraint Collection Editor appears when you are using the Properties window and click the ellipsis button next to the key property of an XML Schema.

XmlNameSpace Collection Editor

Enables you to add or remove namespace declarations to the <schema> element of the current XML Schema. The namespace declarations reference schemas are used by this schema. The XmlNameSpace Collection Editor appears when you are using the Properties window and click the ellipsis button next to the NameSpace property of an XML Schema.