Internet Emirates Group

ASP.NET , SQL SERVER, Reports

1. Getting Started
Understanding how ASP.NET works
Installing Microsoft Visual Web Developer 2008
Hello World: Creating your first ASP.NET web site
Creating pages with dynamic output
Understanding the development web server
Exploring Visual Web Developer 2008

2. Using Microsoft SQL Server 2008
Understanding Microsoft SQL Server
Installing SQL Server 2008 Express
Exploring SQL Server Management Studio Basic
Creating a new database
Connecting to the database in ASP.NET
Testing SQL queries
Presenting a dataset in an ASP.NET page

3. Creating ASP.NET Pages
Understanding ASP.NET web form pages
Separating presentation and logic with code files
Adding web form controls to a page
Handling postback data in a web form page
Using data binding expressions

4. Programming in ASP.NET

Creating a testing environment
Declaring and using a simple variable
Declaring and using a complex object
Using loops
Using functions
Using trace statements
Debugging with breakpoints
Commenting code

5. Creating Reusable Code
Creating web controls
Registering a user control on a web form page
Registering controls globally in the web.config file
Adding public properties to a web control

6. Using Cascading Style Sheets in Web Forms
Understanding Cascading Style Sheets (CSS)
Attaching external CSS files
Defining a CSS selector
Using CSS class selectors in server controls

7. Presenting Dynamic Data
Presenting data with the GridView control
Controlling GridView paging and appearance
Editing data with the GridView control
Presenting data with the DataList control
Formatting data with binding expressions

8. Creating a Data Entry System
Using the DetailsView control
Inserting data with the DetailsView control
Redirecting page requests
Creating an update page
Linking to update pages from the list page
Deleting database records

9. Validating User Input
Customizing forms with item editing templates
Adding validator controls to a form
Controlling the validation error message display
Using the ValidationSummary control

10. Creating Reports
Creating a query with joined tables
Replacing control style properties with CSS
Creating a CSS file for printing
Suppressing elements in printed web pages
Selecting data for a report

11. Managing Session State
Understanding ViewState and managing postbacks
Using session variables

12. Securing a Site with Forms Authentication
Turning on forms authentication
Creating a page to log in users
Creating a page to set up new users
Understanding the security database
Configuring security in the web.config file
Creating a page to log out users

13. Deploying a Web Site
Installing IIS on Windows XP
Installing ASP.NET 3.5 on Windows XP
Deploying a site on Windows XP
Installing IIS on Windows Vista
Configuring ASP.NET 3.5 on Windows Vista
Deploying an application on Windows Vista
Scripting a database for deployment