Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

Data Tab, Toolbox

Displays data objects you can add to a Visual Basic and C# forms and components. The Data tab of the Toolbox appears when you create a project that has an associated designer. The Toolbox appears by default in the Visual Studio integrated development environment; if you need to display the Toolbox, select Toolbox from the View menu.

To go directly to the .NET Framework reference topic for a component, press F1 on the item in the Toolbox or on the component item in the tray of the designer.

Name Description
DataSet Adds an instance of a typed or untyped dataset to the form or component. When you drop this object onto a designer, it displays a dialog box that allows you to select an existing typed dataset class or specify that you want to create a new, blank untyped dataset.

For more information, see Adding Existing Typed Datasets to a Form or Component and Adding Untyped Datasets to a Form or Component

Note   You do not use the DataSet object on the Toolbox to create a new typed dataset schema and class. For more information, see Creating Typed Datasets with the Component Designer.

OleDbDataAdapter Creates a data adapter of type OleDbDataAdapter, which allows you to execute SQL statements or stored procedures against an OLEDB-compatible data source. When you drop an OleDbDataAdapter object onto a designer, it launches the Data Adapter Configuration Wizard to help you create a connection and configure SQL statements or stored procedures to select, insert, delete, and update data in the data source.
OleDbConnection Creates an OleDbConnection object that allows you to communicate with an OLEDB-compatible data source. After adding the connection to the form or component, you can use the Properties window to specify connection string information.
OleDbCommand Creates an OleDbCommand object, which allows you to configure a single SQL statement or stored procedure that you can execute directly. A data command object requires that you also have available a connection object.
SqlDataAdapter Creates a data adapter of type SqlDataAdapter. This is similar to OleDbDataAdapter object (see above), but optimized for SQL Server version 7.0 or later.
SqlConnection Creates a connection object that allows you to communicate with SQL Server version 7.0 or later.
SqlCommand Create a data command object of type SqlCommand. This is similar to OleDbCommand (see above), but optimized for accessing SQL Server 7.0 or later.
OdbcDataAdapter Creates a data adapter of type OdbcDataAdapter. This is similar to OleDbDataAdapter object (see above), but optimized for ODBC data sources.
OdbcConnection Creates a connection object that allows you to communicate with ODBC data sources.
OdbcCommand Create a data command object of type OdbcCommand. This is similar to OleDbCommand (see above), but optimized for accessing ODBC data sources.
OracleDataAdapter Creates a data adapter of type OracleDataAdapter. This is similar to OleDbDataAdapter object (see above), but optimized for Oracle data sources
OracleConnection Creates a connection object that allows you to communicate with Oracle databases.
OracleCommand Create a data command object of type OracleCommand. This is similar to OleDbCommand (see above), but optimized for accessing Oracle data sources.
DataView Creates a data view, which allows you to specify filter and sort options in an object that controls can bind to.
Tip   You can drag database elements (tables, views, or columns) from Server Explorer onto a form or component. Doing so creates the appropriate data connections and data adapters. For more information, see Creating Data Adapters Using Server Explorer.

See Also

Creating ADO.NET Connection Objects | Creating Data Adapters | Creating Typed Datasets with the Component Designer | Adding Untyped Datasets to a Form or Component | Adding Data Views to a Form or Component | Adding Data Commands to a Form or Component

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft