Fetching Data into Your Application

Describes how to load data into datasets, and how to execute stored procedures, and execute queries against a database.

Provides details for loading data into datasets using TableAdapters and DataAdapters.

Provides details for creating and executing SQL statements that return rows using TableAdapter queries and Command objects.

Provides details for creating and executing SQL statements that return single values using TableAdapter queries and Command objects.

Provides details for creating and executing SQL statements that return no value using TableAdapter queries and Command objects.

Provides details for executing stored procedures that return rows using TableAdapter queries and Command objects.

Provides details for executing stored procedures that return single values using TableAdapter queries and Command objects.

Provides details for executing stored procedures that return no value using TableAdapter queries and Command objects.

Provides details for assigning values to parameters in queries and stored procedures, and reading values in parameters returned from executed commands.

Provides details for creating a dataset and populating it with data from a database.

Provides details for creating a Windows application that loads XML data into a dataset and then displays the dataset in a DataGridView control.

Represents an in-memory cache of data.

Represents one table of in-memory data.

Represents a row of data in a DataTable.

Represents a Transact-SQL statement or stored procedure to execute against a SQL Server database.

Represents an SQL statement or stored procedure to execute against a data source.

Represents an SQL statement or stored procedure to execute against an Oracle database.

Represents an SQL statement or stored procedure to execute against a data source.

Provides links to topics that explain how to create and edit TableAdapters with design-time tools.

Provides the steps to create a new TableAdapter.

Provides the steps to add a query to an existing TableAdapter.

Provides links to topics explaining what datasets are, how to create new datasets, and how to create and edit the individual objects they are made of.

Describes how to use a Command to issue INSERT, UPDATE, and DELETE commands against a data source, as well as how to perform catalog operations such as creating or altering tables.

Describes the ADO.NET Command object and how to use it to execute queries and commands against a data source.

Describes how to use parameters with the command properties of a DataAdapter, including how to map the contents of a column in a DataSet to a command parameter.

Describes how to map the contents of a column in a DataSet table to input and output parameters of a DataAdapter command property, including how to retrieve return values from stored procedures

Provides a detailed table showing the inferred .NET Framework type for data types from Microsoft SQL Server, OLE DB, and ODBC.

Provides links to topics that explain how to display data on Windows Forms through data-bound controls.

Provides links to topics on connecting your application to data with design time tools, and ADO.NET connection objects, using Visual Studio.

Provides links to topics on creating applications that work with data, using Visual Studio.