Data Access in Client and Middle-Tier Programming

Fetching Data into Your Application

You load data into your application by executing TableAdapter queries, or by calling the Fill method of a data adapter. You execute SQL statements and stored procedures by calling TableAdapter queries, or by executing methods on Command objects. The following topics describe how to fetch data and how to execute SQL statements and stored procedures.

In This Section

Filling Datasets and Querying Data Overview [ http://msdn.microsoft.com/en-us/library/ms171919(VS.80).aspx ]: Describes how to load data into datasets, and how to execute stored procedures, and execute queries against a database.

How to: Fill a Dataset with Data [ http://msdn.microsoft.com/en-us/library/ms171920(VS.80).aspx ]: Provides details for loading data into datasets using TableAdapters and DataAdapters.

How to: Create and Execute an SQL Statement that Returns Rows [ http://msdn.microsoft.com/en-us/library/fksx3b4f(VS.80).aspx ]: Provides details for creating and executing SQL statements that return rows using TableAdapter queries and Command objects.

How to: Create and Execute an SQL Statement that Returns a Single Value [ http://msdn.microsoft.com/en-us/library/eeb84awz(VS.80).aspx ]: Provides details for creating and executing SQL statements that return single values using TableAdapter queries and Command objects.

How to: Create and Execute an SQL Statement that Returns No Value [ http://msdn.microsoft.com/en-us/library/0k7hxwz6(VS.80).aspx ]: Provides details for creating and executing SQL statements that return no value using TableAdapter queries and Command objects.

How to: Execute a Stored Procedure that Returns Rows [ http://msdn.microsoft.com/en-us/library/d7125bke(VS.80).aspx ]: Provides details for executing stored procedures that return rows using TableAdapter queries and Command objects.

How to: Execute a Stored Procedure that Returns a Single Value [ http://msdn.microsoft.com/en-us/library/37hwc7kt(VS.80).aspx ]: Provides details for executing stored procedures that return single values using TableAdapter queries and Command objects.

How to: Execute a Stored Procedure that Returns No Value [ http://msdn.microsoft.com/en-us/library/ms171921(VS.80).aspx ]: Provides details for executing stored procedures that return no value using TableAdapter queries and Command objects.

How to: Set and Get Parameters for Command Objects [ http://msdn.microsoft.com/en-us/library/80x06z3b(VS.80).aspx ]: Provides details for assigning values to parameters in queries and stored procedures, and reading values in parameters returned from executed commands.

Walkthrough: Filling a Dataset with Data [ http://msdn.microsoft.com/en-us/library/ms233773(VS.80).aspx ]: Provides details for creating a dataset and populating it with data from a database.

Walkthrough: Reading XML Data into a Dataset [ http://msdn.microsoft.com/en-us/library/ekw4dh3f(VS.80).aspx ]: Provides details for creating a Windows application that loads XML data into a dataset and then displays the dataset in a DataGridView [ http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview(VS.80).aspx ] control.

Reference

DataSet [ http://msdn.microsoft.com/en-us/library/system.data.dataset(VS.80).aspx ]: Represents an in-memory cache of data.

DataTable [ http://msdn.microsoft.com/en-us/library/system.data.datatable(VS.80).aspx ]: Represents one table of in-memory data.

DataRow [ http://msdn.microsoft.com/en-us/library/system.data.datarow(VS.80).aspx ]: Represents a row of data in a DataTable.

SqlCommand [ http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand(VS.80).aspx ]: Represents a Transact-SQL statement or stored procedure to execute against a SQL Server database.

OleDbCommand [ http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbcommand(VS.80).aspx ]: Represents an SQL statement or stored procedure to execute against a data source.

OracleCommand [ http://msdn.microsoft.com/en-us/library/system.data.oracleclient.oraclecommand(VS.80).aspx ]: Represents an SQL statement or stored procedure to execute against an Oracle database.

OdbcCommand [ http://msdn.microsoft.com/en-us/library/system.data.odbc.odbccommand(VS.80).aspx ]: Represents an SQL statement or stored procedure to execute against a data source.

Related Sections

TableAdapters [ http://msdn.microsoft.com/en-us/library/7zt3ycf2(VS.80).aspx ]: Provides links to topics that explain how to create and edit TableAdapters with design-time tools.

How to: Create TableAdapters [ http://msdn.microsoft.com/en-us/library/6sb6kb28(VS.80).aspx ]: Provides the steps to create a new TableAdapter.

How to: Create TableAdapter Queries [ http://msdn.microsoft.com/en-us/library/kda44dwy(VS.80).aspx ]: Provides the steps to add a query to an existing TableAdapter.

Preparing Your Application to Receive Data [ http://msdn.microsoft.com/en-us/library/ms171895(VS.80).aspx ]: 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.

Performing Database Operations and Modifying Data [ http://msdn.microsoft.com/en-us/library/0fx37fx7(VS.80).aspx ]: 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.

Executing a Command [ http://msdn.microsoft.com/en-us/library/tyy0sz6b(VS.80).aspx ]: Describes the ADO.NET Command object and how to use it to execute queries and commands against a data source.

Using Parameters with a DataAdapter [ http://msdn.microsoft.com/en-us/library/bbw6zyha(VS.80).aspx ]: 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.

Input and Output Parameters, and Return Values [ http://msdn.microsoft.com/en-us/library/59x02y99(VS.80).aspx ]: 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

Mapping .NET Framework Data Provider Data Types to .NET Framework Data Types [ http://msdn.microsoft.com/en-us/library/4e5xt97a(VS.80).aspx ]: Provides a detailed table showing the inferred .NET Framework type for data types from Microsoft SQL Server, OLE DB, and ODBC.

Displaying Data on Forms in Windows Applications [ http://msdn.microsoft.com/en-us/library/ms171923(VS.80).aspx ]: Provides links to topics that explain how to display data on Windows Forms through data-bound controls.

Connecting to Data in Visual Studio [ http://msdn.microsoft.com/en-us/library/ms171886(VS.80).aspx ]: Provides links to topics on connecting your application to data with design time tools, and ADO.NET connection objects, using Visual Studio.

Getting Started with Data Access [ http://msdn.microsoft.com/en-us/library/ms171883(VS.80).aspx ]: Provides links to topics on creating applications that work with data, using Visual Studio.