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 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
