Microsoft Certified Professional Developer/Exam 70-528/Web-Based Client Development/Create, delete, and edit data in a connected environment

Retrieve data by using a DataReader object.

• MSDN2 - Retrieving Data Using a DataReader

Build SQL commands visually in Server Explorer.

• Creating T-SQL Statements in SQL Server 2005 and Visual Studio 2005

Build SQL commands in code.

• MSDN2 - SqlCommand Class

Create parameters for a command object.

• MSDN2 - How to: Set and Get Parameters for Command Objects
• MSDN2 - SqlCommand.Parameters Property

Perform database operations by using a command object.

• MSDN2 - SqlCommand.ExecuteNonQuery Method

Retrieve data from a database by using a command object.

• MSDN2 - SqlCommand.ExecuteReader Method

Perform asynchronous operations by using a command object.

• MSDN2 - SqlCommand.BeginExecuteNonQuery Method
• MSDN2 - Performing Asynchronous Operations
• MSDN2 - Creating ASP.NET Applications Using Wait Handles

Perform bulk copy operations to copy data to a SQL Server computer.

• MSDN2 - Performing a Single Bulk Copy Operation

Store and retrieve binary large object (BLOB) data types in a database.

• MSDN2 - Writing BLOB Values to a Data Source
• MSDN2 - Obtaining BLOB Values from a Database