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.

Note

Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. 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.

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

Concepts

Preparing Your Application to Receive Data

Fetching Data into Your Application

Binding Controls to Data in Visual Studio

Editing Data in Your Application

Validating Data

Saving Data

Other Resources

Overview of Data Applications in Visual Studio

Connecting to Data in Visual Studio