|
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
|
