Columns Collection Editor
Allows 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 Dataset Designer. For more information, see How to: Create DataTables.
This dialog box appears when you are using the Properties window to configure an untyped dataset on a form or component and follow this sequence:
Edit the dataset's Tables collection.
Select a table in the Tables Collection Editor and edit its Columns property.
The Columns Collection Editor opens on top of the Table Collection Editor.
The editor is divided into two panes. In the left pane you add and remove columns, and in the right pane you set properties for an individual column. This includes the following:
ColumnName property, by which you refer to the column in code.
Unique property, which creates a unique constraint on the column. (This is an alternative to explicitly creating a unique constraint using the Unique Constraint Dialog Box dialog box.)
AutoIncrement, AutoIncrementSeed, and DefaultValue properties, which define pre-defined values for the column.
For more information about how to add and configurelose columns in dataset tables, see Designing DataTables.
Add
Creates a new column in the Columns collection. By default, the column DataColumnn, where n is a sequential number. You can rename the column by setting its ColumnName property in the properties grid.Remove
Deletes the selected column from the table.Warning
You cannot undo this action.
See Also
Concepts
Reference
Other Resources
Getting Started with Data Access
Connecting to Data in Visual Studio
Preparing Your Application to Receive Data
Fetching Data into Your Application
Displaying Data on Forms in Windows Applications