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:

After completing this course, students will be able to:
  • 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:

200MHz Pentium with 32MB Ram. 800 x 600 minimum screen resolution. Windows 98, NT, 2000, or XP. 56K minimum connection speed, broadband (256 kbps or greater) connection recommended. Internet Explorer 5.0 or higher required. Flash Player 7.0 or higher required. JavaScript must be enabled. Netscape, Firefox and AOL browsers not supported.

Copyright © 2006 Learn It Online. All rights reserved.