Accessing Data in Visual Basic Applications

Visual Basic includes several new features to assist in developing applications that access data. Data-bound forms for Windows applications are created by dragging items from the Data Sources Window onto the form. You bind controls to data by dragging items from the Data Sources Window onto existing controls.

Related Sections

• Creating Data Applications
  Provides links to pages that discuss incorporating data access functionality into your applications.

• Data Walkthroughs
  Provides links to pages about particular scenarios related to data access.

• Overview of Data Applications in Visual Studio
  Provides links to pages on creating applications that work with data, using Visual Studio.

• LINQ in Visual Basic
  Provides links to topics that describe how to use LINQ with Visual Basic.

• LINQ to SQL [LINQ to SQL]
  Provides information about LINQ to SQL. Includes programming examples.

• Object Relational Designer (O/R Designer)
  Provides links to topics about how to create a LINQ to SQL [LINQ to SQL] object model in applications.

• Working with Datasets in N-Tier Applications
  Provides links to topics about how to create multitiered data applications.

• NIB Occasionally Connected Applications (Local Database Caching)
  Provides links to topics that describe how to incorporate Microsoft Synchronization Services for ADO.NET into applications that enable synchronization of data between local and remote data.

• PAVE OVER Using SQL Server Compact (Visual Studio)
  Provides links to topics about how to manage data by using SQL Server Compact with Visual Studio.

• Connecting to Data in Visual Studio
  Provides links to pages on connecting your application to data with design-time tools and ADO.NET connection objects, using Visual Studio.

• Preparing Your Application to Receive Data
  Provides links to pages explaining what datasets are, how to create new datasets, and how to create and edit the individual objects they are made of.

• Fetching Data into Your Application
  Provides links to pages describing how to load data into datasets and how to execute SQL statements and stored procedures.

• Binding Controls to Data in Visual Studio
  Provides links to pages that explain how to display data on Windows Forms through data-bound controls.

• Editing Data in Your Application
  Provides links to pages describing how to manipulate the data in the data tables of a dataset.

• Validating Data
  Provides links to pages describing how to add validation to a dataset during column and row changes.

• Saving Data
  Provides links to pages explaining how to send updated data from an application to the database.

• ADO.NET
  Describes the ADO.NET classes, which expose data-access services to the .NET Framework programmer.

• Data in Office Solutions
  Contains links to pages that explain how data works in Office solutions, including information about schema-oriented programming, data caching, and server-side data access.