Export (0) Print
Expand All

Code for Data Access

Visual Studio .NET 2003

This topic is designed to help you find code that demonstrates how to perform common data-programming tasks in Visual Basic .NET. The following categories are represented in the list below:

You can also find sample code for data access in these locations:

Datasets

Example of...

Accessing columns in datasets

Filling datasets

Filling datasets with a parameterized query

Creating a simple Windows application that uses a dataset

Creating a simple Windows application that uses a parameterized query

Creating a simple Web application that uses a dataset

Creating a simple distributed application that exchanges information in datasets

Creating a simple application that maps data tables to a dataset

Sorting a data table in a dataset

Filtering (selecting) a data table in a dataset

Data Views

Example of...

Sorting a dataset using a data view

Filtering (selecting) in a dataset using a data view

Finding records in a data view

Reading records using a data view

Updating records using a data view

Inserting records using a data view

Deleting records using a data view

Working with multiple data views

Updating Datasets and Data Sources

Example of...

Updating existing dataset records

Creating a simple Windows application that updates a database

Creating a simple Web application that updates a database

Creating a simple Web application that updates a database using a grid

Inserting records into a dataset

Deleting records from a dataset

Merging datasets

Turning off dataset constraints

Committing dataset changes

Sending dataset changes to the data source

Handling data-update errors

Data Commands

Example of...

Creating parameterized queries

Creating a simple Web application that displays information in a grid

Executing queries that return a result set

Creating a simple Web application that displays paged data

Executing update, insert, or delete queries

Executing database (DDL) commands

Executing commands that return a scalar value

Concurrency

Example of...

Creating a simple application that implements concurrency checking

Handling concurrency errors

Relations

Example of...

Working with data in related tables

Creating a simple Windows application that displays master-detail information

Related Code Examples

Accessing Data (Web Forms)

Accessing Data (Windows Forms)

DataGrid Control (Web Forms)

DataGrid Control (Windows Forms)

Code Examples for Visual Basic Programmers

Show:
© 2014 Microsoft