|
|
 |
|
|
| |
|
|
| |
| |
| Programming with Microsoft ADO .NET |
| Duration: 3 days |
|
|
|
- Developers responsible for designing/building data-centric, distributed applications
- Developers with component and Web application development skills
- Developers who have built solutions using Microsoft Visual Studio®
|
|
- Understanding of relational database concepts: table, row, column, primary keys, foreign keys, constraints, and views
- Data query and modification experience, including experience with SELECT, INSERT, UPDATE, and DELETE commands
- Exposure to XML documents, style sheets, and schemas
- Experience with Visual Basic .NET, Visual Basic for Applications, or previous versions of Visual Basic
- Experience building user interfaces, including Web applications or Microsoft Windows® applications
- Recommend experience with a .NET language such as Microsoft Visual Basic® .NET, Visual C#T, or Visual C++®
- Recommend understanding of object-oriented concepts and terminology; experience developing distributed applications
- Recommend Experience developing Web-based applications hosted on Internet Information Server
|
|
|
| Description |
 |
An experienced, expert Microsoft Certified Solution Developer/Microsoft
Certified Trainer will teach this course. |
This Introduction/Intermediate level course provides developers the skills to build data-centric applications and Web services with Microsoft ADO.NET, Microsoft SQL ServerT 2000, and the Microsoft .NET Framework.
|
|
| Objectives |
- Describe data-centric applications, ADO.NET architecture, and ADO.NET and XML
- Connect to SQL Server and other data sources
- Perform connected database operations including executing SELECT commands, database definition commands, dynamic SQL commands, and commands that return data from a SQL Server database in XML
- Build a DataSet schema, populate it with data, and modify the data programmatically
- Use XML techniques while working with DataSets, including mapping tables and columns, creating XSD schemas, building strongly typed DataSets, and interacting with XMLDataDocuments
- Build a Web service that uses ADO.NET to query and update a data source
|
|
| Course Outline |
Data-Centric Applications and ADO .NET
- Design of Data-Centric Applications
- ADO.NET Architecture
- ADO.NET and XML
Connecting to Data Sources
- Choosing a .NET Data Provider
- Defining a Connection
- Managing a Connection
- Handling Connection Exceptions
- Connection Pooling
Performing Connected Database Operations
- Working in a Connected Environment
- Building Command Objects
- Executing Commands That Return a Single Value
- Executing Commands That Return Rows
- Executing Commands That Do Not Return Rows
- Using Transactions
Building DataSets
- Working in a Disconnected Environment
- Building DataSets and DataTables
- Binding and Saving a DataSet
- Defining Data Relationships
- Modifying Data in a DataTable
- Sorting and Filtering
| |
Reading and Writing XML with ADO .NET
- Creating XSD Schemas
- Loading Schemas and Data into DataSets
- Writing XML from a DataSet
Building DataSets from Existing Data Sources
- Configuring a DataAdapter to Retrieve Information
- Populating a DataSet Using a DataAdapter
- Configuring a DataAdapter to Update the Underlying Data Source
- Persisting Changes to a Data Source
- How to Handle Conflicts
Building and Consuming a Web Service That Uses ADO .NET
- Building and Consuming a Web Service That Returns Data
- Troubleshooting errors in an ADO.NET application
| |
|
|
Process
and
Featured Courses