Udostępnij za pośrednictwem


Data Access (How Do I in C#)

This topic links to help about widely used data access tasks that use ADO.NET types directly in your application. For more information about how to access data by using LINQ to SQL or LINQ to DataSet, see LINQ (How Do I in C#).

To view other categories of popular tasks covered in Help, see How Do I in C#.

General

Connecting to Data in Visual Studio

Creating and Designing Typed Datasets

TableAdapters

  • TableAdapter Overview
    Provides an overview of TableAdapters which provides communication between your application and a database.

  • Walkthrough: Creating a TableAdapter with Multiple Queries
    Provides a procedure to create a TableAdapter in a dataset by using the Data Source Configuration Wizard. The walkthrough shows how to create a second query in the TableAdapter by using the TableAdapter Query Configuration Wizard in the Dataset Designer.

Filling Datasets and Executing Queries

Displaying Data on Windows Forms

Databinding

Editing Data in Datasets (DataTables)

Validating Data

  • Data Validation Overview
    Provides an overview of validating data, the process of confirming that the values being entered into data objects conform to the constraints in a dataset's schema and the rules established for your application.

  • Walkthrough: Adding Validation to a Dataset
    Explains how to use the ColumnChanging event to verify that an acceptable value is being entered into the record.

Saving Data

Data Resources

  • Data User Interface Elements
    Contains information about all the dialog boxes and wizards that you use when you design data access in your applications.

  • ADO.NET Data Adapters
    Provides information about ADO.NET data-adapter objects and how to work with them in Visual Studio.

Creating SQL Server 2005 Objects in Managed Code

  • SQL Server Projects
    Explains how to use .NET languages and the Transact-SQL programming language to create database objects such as stored procedures and triggers, and to retrieve and update data for Microsoft SQL Server 2005 databases.

  • Walkthrough: Creating a Stored Procedure in Managed Code
    Provides step by step instructions for the following procedures:

    Creating a stored procedure in managed code.

    Deploying the stored procedure to a SQL Server 2005 database.

    Create a script to test the stored procedure on the database.

    Query data in the database to confirm the stored procedure executed correctly.

Additional Resources

The following sites require an Internet connection.

See Also

Concepts

How Do I in C#