This documentation is archived and is not being maintained.

Accessing Data

Most Visual Basic and Visual C# applications revolve around reading and updating information in databases. To allow data integration in distributed, scalable applications, Visual Studio .NET provides support for a new generation of data access technology: ADO.NET.

In This Section

Data Walkthroughs
Lists topics that illustrate how to perform common data-related tasks.
Code for Data Access
Provides code examples for common data tasks.
Troubleshooting Data Access in Visual Studio .NET
Suggests how to fix common problems that arise when working with data access in Visual Studio .NET.
Introduction to Distributed Applications and Data Integration
Provides a general introduction to the concepts of data access in applications you create with Visual Basic and Visual C#.
Connecting to Data Sources with ADO.NET
Provides topics about creating and working with connection objects in Visual Studio.
ADO.NET Data Adapters
Provides topics about defining the SQL statement or stored procedure calls that you use to fill datasets and write data back to the database.
ADO.NET Datasets
Provides topics about what datasets are and how to use them.
Filtering and Sorting in Datasets
Provides topics about viewing the data in a dataset in different ways by selecting subsets of records or sorting.
Relationships in ADO.NET Datasets
Provides topics about working with dataset tables that have a parent-child relationship.
Performing Database Operations Directly
Provides topics about how to execute SQL statements and stored procedures directly and work with the results they return.
Dataset Updates in Visual Studio .NET
Provides topics about making changes in datasets and then writing those changes back to a data source.
XML Schemas and Data
Provides topics about creating XML schemas that describe the structure of datasets.

Related Sections

Data Design
Provides topics that discuss the fundamental concepts of designing data storage and access for applications.
Visual Basic Code Example Topics
Lists quickstart-like code examples that help you perform common tasks in Visual Basic .NET.
Decision Chart
Provides an interactive guide to help you choose which approach or technology to use, as well as links to more information.
What's New in Data
Discusses data access features that are new in Visual Studio .NET.
Windows Forms Data Architecture
Provides topics on how data binding works in Windows Forms and how to bind controls to a data source.
Data Access in Web Forms Pages
Provides topics on the issues associated with data binding in Web Forms pages and how to bind controls to a data source.
Creating and Filling Datasets Example Topics
Presents a series of specific example code topics for common tasks in creating and filling datasets with Visual Basic .NET.
Manipulating Data Example Topics
Presents a series of specific example code topics for common tasks in working with data within your application using Visual Basic .NET.
Data Access Technologies
Describes factors to consider when deciding between ADO.NET, ADO, and OLE DB.
Debugging SQL
Provides information on debugging SQL Server stored procedures, functions, and triggers.
Common Tasks in Visual Basic and Visual C# (Data)
Lists the most common data tasks and provides links to more information.
Data Namespaces in Visual Studio
Lists the major namespaces for data and XML and provides links to .NET Framework reference topics about the types (classes, structures, enumerations, delegates, and interfaces) in the namespaces, as well as links to topics about using them in Visual Basic and Visual C# applications.
XML in Visual Studio
Provides links to sections of the Visual Studio documentation that discuss XML.
Overview of Visual Database Tools
Introduces the Query Designer and other data tools.
Crystal Reports
Provides links to the Crystal Reports for Visual Studio .NET documentation.
Performing Transactions
Introduces transactions for users of the .NET Framework SDK.
Modeling Your Application and Data
Provides an overview of how you identify and implement the data and process requirements for your application, including an overview of what tools you can use.
Deploying Applications and Components
Provides links to procedural, conceptual, and step-by-step topics about component deployment.