Data Access (How Do I in Visual J# Express) 

This page links to help on widely used J# data tasks. To view other categories of popular tasks covered in Help, see How Do I in Visual J# Express.

• Recommendations for Data Access Strategies
  Provides information on how to access data using ADO.NET, transaction processing, and XML.

Connecting to Databases

• Connecting to a SQL Express Database
  Describes how connecting your application to data in Visual Studio is simplified by using the Data Source Configuration Wizard. After you complete the wizard, data is available in the Data Sources window for dragging onto Windows Forms.

• How to: Create Connections to Access Databases
  Describes how, when connecting to an Access database, you should use the Microsoft Jet 4.0 OLE DB Provider.

• Connecting to an Oracle Database
  Explains how to connect your application to an Oracle database using the .NET Framework Data Provider for Oracle.

Displaying Data

• How to: Bind Data to Existing Controls
  Describes binding an existing Windows Forms control to data in a data source.

• How to: Bind a Windows Forms ComboBox or ListBox Control to Data
  Describes binding a ComboBox or ListBox control.

Querying

• Filling Datasets and Querying Data
  Describes how you can execute SQL statements or stored procedures against a data source using TableAdapters or command objects.

Editing Data

• Sorting and Filtering Data Using a DataView
  Explains that DataView provides several capabilities for sorting and filtering data in a DataTable.

• Manipulating Data in a DataTable
  Shows that after creating a DataTable in a DataSet, you can perform the same activities that you would when using a table in a database.

• Adding Data to a Table
  Describes how, after you create a DataTable and define its structure using columns and constraints, you can add new rows of data to the table.

• Deleting a Row from a Table
  Contains instructions for deleting records from a data table.

• Viewing Data in a Table
  Describes how using DataTable, you can view subsets of data depending on the search criteria you specify.

• Manipulating Data in a DataTable
  Explains that after creating a DataTable in a DataSet, you can perform the same activities that you would when using a table in a database.

• How to: Edit Rows in a DataTable
  Describes how, in order to edit an existing row in a DataTable, you need to locate the DataRow you want to edit, and then assign the updated values to the desired columns.

Stored Procedures

• Stored Procedure Sample
  Demonstrates how to call a stored procedure.

• How to: Create Stored Procedures and User-Defined Functions
  Explains how you can use Server Explorer to create stored procedures.

See Also

Reference

How Do I in Visual J# Express