Creating Client Data Applications

Most applications involve reading and updating information in databases. To enable data integration in applications, Visual Studio provides tools and support for working with data using ADO.NET and Windows Forms Data Binding.

In This Section

• Getting Started with Data Access
  Provides links to topics about how to use Visual Studio to create applications that work with data.

• Using SQL Server Compact 3.5 (Visual Studio)
  Provides links to topics about how to incorporate SQL Server Compact 3.5 databases into applications.

• Object Relational Designer (O/R Designer)
  Provides links to topics about how to create LINQ to SQL classes by using the O/R Designer.

• Hierarchical Update
  Provides links to topics about how to save related tables in a typed dataset by using the TableAdapterManager component.

• N-Tier Data Applications
  Provides links to topics about how to use Visual Studio features to help you create n-tier applications.

• Occasionally Connected Applications
  Provides links to topics about how to incorporate Microsoft Synchronization Services for ADO.NET into applications.

• TableAdapters
  Provides links to topics about how to use TableAdapters to provide communication between your application and a database.

• Connecting to Data in Visual Studio
  Provides links to topics about how to use Visual Studio to connect your application to data with design time tools and ADO.NET connection objects.

• Preparing Your Application to Receive Data
  Provides links to topics that explain what datasets are, how to create new datasets, and how to create and modify the individual objects they are made of.

• Fetching Data into Your Application
  Provides links to topics that describe how to load data into datasets, and how to execute SQL statements and stored procedures.

• Displaying Data on Forms in Windows Applications
  Provides links to topics that explain how to display data on Windows Forms through data-bound controls.

• Editing Data in Your Application
  Provides links to topics that describe how to manipulate the data in the data tables of a dataset.

• Validating Data
  Provides links to topics that describe how to add validation to a dataset during column and row changes.

• Saving Data
  Provides links to topics that explain how to send updated data from an application to the database.

• Data Resources
  Provides links to additional data associated sections. Includes data related dialog boxes and data adapters.

Reference

• System.Data
  Describes the System.Data namespace and provides a table of relevant classes.

• ADO.NET
  Provides links to topics that explain the data access features in the .NET Framework.

Related Sections

• Language-Integrated Query (LINQ)
  Provides an overview of LINQ technologies.

• LINQ to SQL
  Provides links to topics about how to incorporate LINQ to SQL into applications.

• TableAdapterManager Overview
  Describes the concepts of saving related data in a typed dataset by using the TableAdapterManager component.

• Visual Database Tools
  Describes the tools available for creating and maintaining databases.

• Accessing Data with ASP.NET
  Provides links to topics about how to access data from ASP.NET applications.

• Data Access (C+)
  Provides links to topics about how to access data from Visual C++ applications.

• Data Access Using ADO.NET (C++/CLI)
  Provides links to topics about how to access data from Visual C++ applications.

• Data in Office Solutions
  Provides links to topics about how to access data by using Visual Studio Tools for Office.

• Working with Data in Managed Device Projects
  Provides links to topics about how to access data from managed device projects.

• Creating SQL Server 2005 Objects in Managed Code
  Provides links to topics associated with SQL Server projects.