Accessing Data
Visual Studio .NET 2003
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.
