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</li> </ul>

Perform database operations by using a command object. <ul> <li>MSDN2 - SqlCommand.ExecuteNonQuery Method</li> </ul>

Retrieve data from a database by using a command object. <ul> <li>MSDN2 - SqlCommand.ExecuteReader Method</li> </ul>

Perform asynchronous operations by using a command object. <ul> <li>MSDN2 - SqlCommand.BeginExecuteNonQuery Method</li> <li>MSDN2 - Performing Asynchronous Operations</li> <li>MSDN2 - Creating ASP.NET Applications Using Wait Handles</li> </ul>

Perform bulk copy operations to copy data to a SQL Server computer. <ul> <li>MSDN2 - Performing a Single Bulk Copy Operation</li> </ul>

Store and retrieve binary large object (BLOB) data types in a database. <ul> <li>MSDN2 - Writing BLOB Values to a Data Source</li> <li>MSDN2 - Obtaining BLOB Values from a Database</li> </ul>