Microsoft .NET Applications MCSD/MCAD/MCDBA 70-316 Series: Data Binding and Data Manipulation
Product Code: appn03 Time: 3.0 hour(s) CEUs: Available

Summary:

This course explains what is needed to make data available to users by binding data to the interface, and transforming and filtering data to provide only what the user requires. .NET methods for accessing and manipulating data from file-based storage, relational databases, and XML files through Ad-Hoc queries and stored procedures are also covered. Data binding and manipulating data are two of the most important application development tasks in the .NET framework.

Objectives:

  • Bind data to user interface using simple and complex data binding techniques.
  • Understand how to transform and filter data at the server and within the client application.
  • Access, manipulate, and consume data from file-based data storage, relational databases, and XML data files.
  • Understand Ad-Hoc queries and stored procedures used to access SQL server databases.
  • Use the ADO .NET Object Model to make data available within an application.
  • Handle database errors using SqlException and SqlError objects.


Topics:

  • Simple Data Binding
  • Complex Data Binding
  • Transformation and Filters
  • Transact-SQL Statements
  • Ad Hoc SQL Server Queries
  • SQL Server Queries using Stored Procedures
  • Data Access
  • The ADO.NET Object Model
  • XML Data
  • Database Errors

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.



Copyright © 2008 MindLeaders. All rights reserved.