Export (0) Print
Expand All

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.

Filling Datasets and Querying Data Overview

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

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

How to: Create and Execute an SQL Statement that Returns Rows

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

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

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

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

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

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

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

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

Walkthrough: Reading XML Data into a Dataset

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

DataSet

Represents an in-memory cache of data.

DataTable

Represents one table of in-memory data.

DataRow

Represents a row of data in a DataTable.

SqlCommand

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

OleDbCommand

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

OracleCommand

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

OdbcCommand

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

TableAdapters

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

How to: Create TableAdapters

Provides the steps to create a new TableAdapter.

How to: Create TableAdapter Queries

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

Preparing Your Application to Receive Data

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.

Using Commands to Modify Data (ADO.NET)

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 (ADO.NET)

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

DataAdapter Parameters (ADO.NET)

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.

Modifying Data with Stored Procedures (ADO.NET)

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

Data Type Mappings in ADO.NET

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

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

Connecting to Data in Visual Studio

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

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

Community Additions

ADD
Show:
© 2014 Microsoft