ASP.NET is a web application framework developed by Microsoft that allows developers to build dynamic web sites, web applications and XML web services. ASP.NET can be used to create anything from small, personal websites through to large, enterprise-class web applications.

Learning how to connect and interact with a database is the next step in learning ASP.NET as this class continues from the Introduction to ASP.NET Web Development class.

Students will learn the database class framework, ADO.NET that is used with ASP.NET to connect and interact with different types of databases such as SQL Server, ORACLE, XML and even MySQL. Understanding the syntax of structured query language (SQL) that communicates with the database is covered. Students will be taught different techniques in working with a database to retrieve, filter, display and format data on a web page.

Learning what and how AJAX can be added to an existing ASP.NET to improve visitor interactivity and responsiveness.

AJAX is a set of technologies (JavaScript, the DOM, XML, and the XMLHttpRequest object) that have formed the foundation for many of new interactive (web 2.0) websites you see now on the web. AJAX allows you to update parts of your website without refreshing the entire page.

Students will be using Visual Studio 2010 Express and SQL Server 2005/2008.

Applicable Job Roles: ASP.NET developer, web developer, software engineer, and database engineer

Objectives for this class are:

• Overview of databases on the web and Microsoft’s ADO.NET framework
• Understand basic syntax of SQL with respect to SELECT, INSERT, and UPDATE statements.
• Understand how to use (C#) to interact with classes of the ADO.NET framework to interact with SQL Server databases.
• How to programmatically (C#) interact with data server controls in connecting, interacting and filtering data for more RAD of data interaction.
• Learn the components of AJAX and how it can be used with ASP.NET
• Learn how to code (C#) AJAX-based server controls to update independent sections of an ASP.NET web page.
• Overview of some Microsoft ASP.NET Certifications that students can study after taking the class.

• Overview of ADO.NET
• SQL Server 2005/2008 (and Management Studio) review and installation
• Review our sample database
• DataSource controls overview
• Connecting to the database (connection string)
• Rendering the data

• SQL Overview (SELECT with WHERE, IN and BETWEEN)
• Comparison operators
• Retrieving and filtering your data
• Querying multiple tables (JOIN)
• Using web.config for global data connections
• Exception Handling
• Interacting with data and server controls
• Review of ADO.NET Connection Objects (instead of SQLDataSource)
• SQL Injection Attacks precautions
• ADONET: DataReader object

• ADO.NET: DataSet object
• INSERT query
• Using SCOPE_IDENTITY() for return values
• DELETE query
• UPDATE query
• Using code to maintain referential integrity with your database

• Benefits of using Stored Procedures
• Review of creating a Stored Procedures in SQL Server
• How to use Stored Procedures on your web host
• Setting up input parameters
• Transactions Overview

• Understanding AJAX
• Script Manager and Partial Refreshing
• Conditional Updating
• Update Progress Notification
• Timed Refreshing

• Component Overview and implementation
• Testing our HTTP calls with Fiddler
• JavaScript libraries overview
• Performance tweaking