Computer Science 206


Loading...
This is the fourth semester class in programming. If you have not had CS205 or CS213 then you should not take this course. You may use VB or C# in the class. You will use HTML, CSS, JS, XML, AJAX, ASP.Net, VB, C#, SQL, & ADO 4 in this class. You will also need to understand basic networking protocols.
		Home
Lessons	Projects & Videos	RESOURCES
Lesson 1: Introduction to ASP.Net You need: VS Pro 2010 or Visual Web Developer SQL Server Express 2008 Sp-3 SQL Server Management Studio Express Expression Web 4 WS_FTP-LE	What is ASP.Net? Getting started videos to check out! The Web Model Introduction to IIS video How to create a new web app Part 1 video Making a multi-page site (Chapter 3) How to create a new web application Part 1 Building a multi-page web application (Chapter 3) New Code-behind model (html) Get the slides Crash Course in HTML is in Murach Chapter 5 My HTML for the programmer video series: Intro to html part 1 Intro to html part 2 Intro to html part 3 Publishing your site Class activity: You will learn how to publish your projects to a folder on RPKessler.com and learn how to edit them live. Getting to know Expression Web 4 videos Create folder on live site How to create a simple page How to edit a page live Practice with HTML and some basic JavaScript & CSS Activity #1: Publish 2 pages and use hyperlinks for navigation & use 1 external link to a related page(15 pts)	General Resources Course Outline Code Helper How do I videos? Get all the Software to develop ASP.NET Your Project Website Home Work Projects Project 1 Project 2 Project 3 (EXTRA CREDIT) Getting Started Resources Create basic web page Code editing Getting started videos HTML & JavaScript Html part 1 Html part 2 Html part 3 Color chart HTML Tags Summary Client-Side validation with JavaScript
Lesson 2: Designing your web pages.(Chapter 5)	Introduction to Posting Back to Web Server Mr PostBack Project (C# version) How to format our web pages Web Site Pages I :Code behind files, tables & HTML tags. Web Site Pages II : A first look at CSS. 1-Introduction to Cascading Style Sheets(CSS) Video 2- Managing & Modifying styles Video My Practice Styling Project 401K Future Value Calculator I (Based on Murach p.42) C# Version VB Version 401K Future Value Calculator II (with validation) C# Version VB Version Activity #2: Publish a project that computes something such as the Future Value Calc. DO NOT COPY THE FVC PROJECT. Be sure to include validation.(15pts) Due date is 2/25 at noon!	Database Resources My DB resources page SQL video series SQL Home page SQL Management Studio Express Managing SQL with management studio (pdf) (Eric Brown SQL Management Studio Express 2008 Get Northwind & Pubs Databases AdventureWorks Sample Databases Customers-05 database
Lesson 3 Using Server Controls: StreamReader Class (Chapter 6)	ASP.Net from the server's point of view How to create a new web application Part 2: Data entry using the stream reader. Video Data Entry Project VB version C# Version External Style Sheets Simple External Style sheet project Dynamic CSS project Activity #3: Publish your FVC page with data validation & external CSS page.(15pts)	The MS Access Upsizing Wizard
Lesson 4 Master pages, Tree-View, Site Maps. Validation controls & Client-Side Validation (Chapters 7, 8, 9, 10 & 25)	Introduction to Master Pages, Tree View, & Site Maps Master Pages and content pages Video Master page & Navigation project VB Version C# Version Client-Side Validation, Notification, & Email Using JavaScript Using ASP validation Activity #4: Add data validation to your Activity #3 page using JavaScript.(15pts)	How to use AJAX Introduction to AJAX Partial-Page updates with the Update Panel Updating an existing web site to use AJAX Updating Existing Web with AJAX AJAX Controls samples Get the AJAX Control toolkit for VS
Lesson 5 Using ASP Login Controls Chapter 20). Forms authentication & custom error pages (Chapter 23)	Website Login issues I- Custom Login (Lecture & Demos) GridView with confirm delete, Logins, & custom error pages demo VB Version C# Version Get my Access 2003 customers DB for Lesson 5 Read About Custom Error Pages (Chapter 23) Website Login issues II- Authentication & Authorization. Using the ASP Login Controls (Chapt.20) ASP Website Admin Tool (MSDN article) Login Controls Demo (VB) Login Controls Demo (C#) Training Video on Login Controls(Bob Tabor)	In-Class Demo Projects Our First ASP demo (2/6/2012)
Lesson 6: ASP & SQL Databases Part I (Chapters 13 & 14)	SQL DataSources & Grids SQL Data Sources How to use the DataSource Wizard Get SQL Management Studio Express Connection String Examples Connection String Formats for web.config document Example Conn with DB inside the project (C#) Example Conn with DB attached to SQL (C#) Example Conn for remote/cloud DB Custom GridView Formatting. Learn how to modify grid for better editing and more! Grid Formatting project (includes modified DB) How to display currency with two decimal places in GridView XML Data Sources VB Version C# Version Activity #5: Create a SQL DB and create an ASPX page to display data in a grid. (Does not have to edit/update records)(15pts)	SQL Server Books On Line (Excellent) SQL Language tutorial SQL Tutorial (W3 schools) SQL Data types DataBinding Model MSDN SQL database video series MSDN VB How to: Database Video Series
Lesson 7: ASP & SQL Databases Part II: Data Controls, E-Mail & MapQuest Demos. (Chapters 14, 15, 16)	ASP Data Controls(Databases are included with each project) Get my SQL customers DB here. ADO 2.0 & SQL DataSources, Grids, & List Boxes in Code: VB Version C# Version Details View Control with Murach's Halloween DB VB Version C# Version Databases & the FormView Control(Includes DB) VB Version C# Version Remote SQL Database Management (In Class) Create a new table in the customers206 DB on my SQL server. Create an aspx page to display/edit/add records to your table. FormView, GridView & the AJAX Accordion Control VB Version (no code required!) Accordion Control Video MultiView Control & Wizard Controls MultiView VB version MultiView C# version Wizard Control VB Version Wizard Control C# Version Sending Email From ASP.Net VB demo project C# Demo project MapQuest Demo VB Version C# Version
Send Projects to RPKessler@hotmail.com Copyright © 1999-2012 by Ronald P. Kessler,Ph.D. All rights reserved. Revised: Jan. 23, 2012 These materials are provided for the exclusive use of my students. Please contact me for permission to reproduce or use these presentations.