Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here.

Data User Interface Elements 

This section contains information about all the dialog boxes and wizards that you use when designing data access in your Visual Basic or Visual C# applications.


The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.

In This Section

Data Smart Tags

Provides information on some smart tag commands that are available for data.

Add Dataset Dialog Box

Puts an existing typed dataset or a new untyped dataset (an instance of the System.Data.Dataset class) onto a form or component.

Advanced SQL Generation Options Dialog Box

Allows you to control how SQL statements or stored procedures are created for a data adapter by specifying options for updates, optimistic concurrency, and refreshing the dataset.

Choose a Data Source Instance Dialog Box

Allows you to select the desired dataset from a list of datasets in your project..

Choose a Data Source to Merge with Dialog Box

Allows you to select which data source to merge with when multiple data sources are available.

Choose Key Dialog Box

Allows you select a key when a column participates in a multi-key constraint.

Collection Editors

Provides links to topics about different collection editors that allow you to create and edit individual members of a collection.

Connections Missing

Informs you when a dataset contains a reference to a connection string that is not in application settings.

Data Adapter Configuration Error Dialog Box

Displays one or more errors that occurred while Visual Studio was attempting to create an instance of a data adapter and set its properties.

Data Adapter Configuration Wizard

Configures SQL commands or stored procedures that a data adapter uses to read data into a dataset from a database and write it back again. The topic describes how to run the wizard and what to do after the wizard has completed.

Data Adapter Preview Dialog Box

Allows you to see how data will be filled into a dataset by a data adapter, which is useful for testing that the adapter is returning the data you expect, that table mappings work properly, and the effect of different parameter values.

Data Source Login Dialog Box

Allows you to request access to a data source (typically a database) for which you have not already been authenticated.

DataSet Tab, Toolbox

Displays the objects you can add to a typed dataset.

Do you want to include the password in the connection string Dialog Box

Allows you to control whether a password is embedded into the connection string.

Edit Key Dialog Box

Allows you to define and edit keys.

Foreign Key Constraint Dialog Box

Allows you to place a foreign key constraint on one or more columns in a dataset table that is related to another table.

Generate Dataset Dialog Box

Allows you to generate a new typed dataset from information provided by one or more data adapters and to add tables to an existing dataset.

Multiple BindingSources Dialog Box

Allows you to select which BindingSource to use when more than one BindingSource is available.

Preview Data Dialog Box

Allows you to review the data returned by queries in your project.

Preview SQL Script Dialog Box

Appears as part of the Data Adapter Configuration Wizard to allow you to see the SQL script the wizard will use to create stored procedures to read and write data.

Relation Dialog Box

Allows you to create a relationship (a DataRelation object) that maintains information about parent-child records in two data tables in a dataset.

Search Criteria Builder Dialog Box

Allows you to create a parameterized query on a data-bound Windows Form, and automatically add the controls required to run the query.

Table Mappings Dialog Box

Allows you to specify which columns in a database table or other data source are equivalent to columns in a dataset table.

Unique Constraint Dialog Box

Allows you to place a unique constraint on one or more columns in a table in an untyped dataset.

XML Designer

Provides a set of visual tools for working with XML Schemas, ADO.NET datasets, and XML documents.

Related Sections

Accessing Data

Provides links to topics that describe how to access data in your Visual Basic and Visual C# applications.

Reference(Visual Database Tools)

Provides links to reference topics about working with Visual Database Tools.

See Also

Community Additions

© 2015 Microsoft