![]() Capt. Horatio T.P. Webb |
Parks -- Spring 2012 Version 3 -- Last Updated 6:00 PM 3/21/2012 | ||
| NOTICES:
There is a problem that causes the regular expression validator for acctdesc
*************************CAUTION *******************************
The following line has an oddity in it. In order prevent the user
from entering a single or double quote the regular expression validator uses the pattern: [^\'\"]+
BUT the validator pattern is enclosed in double quote marks itself.
So, to prevent the double quote from terminating the ValidationExpression string
we have to force the double quote to be inserted at execution time.
So in the line below, replace the double quote with the string: AMPERSANDCHARACTERquote;
that is, the single ampersand character followed by the string "quot;"
The following line is done this way. But you can't see it when you view this page,
because the ampersandquot; has been rendered by your browser as ". But it is there nonetheless.
See this discussed: http://forums.asp.net/t/1220701.aspx/1
******************************************************************
<asp:RegularExpressionValidator id="adquotecheck" ControlToValidate="adtextbox" ValidationExpression="[^\'\"]+"
Display="Dynamic" runat="server">
| |||
| COURSE SUMMARY: | This
course is the second part of a two course sequence on transaction
processing in the clent-server environment. This second course
concentrates on server-side processes involving submission and processing
transaction information across the Internet. The primary technologies
employed are: HTML, XML, XSL, WSH, Microsoft's Visual Studio and ASP.NET 3.5 (VB.NET and C#), Microsoft SQL Server emphasizing XML. We will also examine the LINUX and PHP alternatives.
The course will discuss two major technologies. In the first half the course will present server side scripting options and the second half will discuss Microsoft's server-side ASP.NET 3.5 and Visual Studio technologies. | ||
| TEXTS: |
We will not start using this textbook until FEB 22.
Beginning ASP.NET 3.5: In C# and VB by Imar Spaanjaars Wrox (Wiley) ISBN: 978-0-470-18759-3 March 2008 | ||
| OFFICE HOURS: | MW
1-2:30 MW 280E Melcher Hall or by appointment 713-743-4729 | ||
| GRADING: | There is one in-class exam (WED MAR 21). There will also be a take-home exam 2 that will be distributed in class on MON APR 30 and be due FRI MAY 4 at 5:30 PM. All grading issues are handled in-person during office hours. Do not send e-mail to the instructor regarding any grading issue. Grades assigned for drops after WED FEB 1 (last day to drop without receiving a grade) will be based on your current class grade. If you have a failing grade at the time of the drop, you will receive an F otherwise a W. | ||
| Exam 1 (in class WED MARCH 21) | 40% | ||
| Exam 2 (provided on the last data of class MON APR 30, due back FRI MAY 4 5:30PM) | 60% | ||
| See the assignments necessary for the final here | |||
|
|
|
||
| WED JAN 18 | Introduction to the Transaction Processing in the Client/Server Environment | ||
| MON JAN 23 | Traditional ASP and SQL -- Part I | ||
| WED JAN 25 | Traditional ASP and SQL -- Part II | ||
| MON JAN 30 | Server Processes: How your server accounts and SQLServer DSNs are created (word doc) Request Variables servar.asp (see asp code servvar.htm) Browser and screen resolution detection Object Models Overview (reference) Traditional asp template example ( source code) SQL Server and ADO Fundamentals ( reference) |
||
| WED FEB 1 |
|
||
| MON FEB 6 |
Traditional ASP Examples -- Column #1 only
Connections and Recordsets for ASP here ODBC vbs OLEDB connections timings here |
||
| WED FEB 8 |
Command Parameters
(source)
and Error Collection (source)
Audit Controls |
||
| MON FEB 13 | Text File Processing (ASP example -- source code here)
Dave Whalen's Cookie FAQ Client-Side Cookie examples (write,read,kill in both VBScript and Javascript) Sample assignments |
||
| WED FEB 15 | XML in traditional ASP: The XML DTD Receiving and Displaying XML on the Client Creating XML on the Client (this is AJAX see here) IE Example AJAX for GL Account Query
Cross Browser Example AJAX for GL Account Query
Receiving and Creating XML on the Server Sending XML from the Server to the Client Boatwright & Higdon's Complete XML example Walking the XML tree Example AJAX for GL Account Query RSS Examples Family Cookbook (AJAX based) |
||
| MON FEB 20 | Execute glrestor.asp
Get Source Code for glrestor.asp |
||
| WED FEB 22 | .NET Framework Visual Studio Introduction Simple ASPX Examples (see the C# and VB.NET columns) Installing IIS on XP Professional (here) Installing IIS on Vista (here) | ||
| MON FEB 27 | .NET Languages at MSDN
VB.NET Language C# Language ASP.NET Pages |
||
| WED FEB 29 | Server Controls | ||
| MON MAR 5 | Web Forms I Client-to-server object references (postback) (here) |
||
| WED MAR 7 |
Web Forms II Simple Data Controls (mis4372_ex1.aspx, source) Data Binding to Controls (also IsPostBack) (mis4372_ex3.aspx), source) |
||
| MON - SAT MAR 12-17 |
|
||
| MON MAR 19 | Exam Review | ||
| WED MAR 21 |
Exam 1 in class (scripting)
Sample midterm exams: Fall 2011 Midterm, Spring 2011 Midterm, Fall 2010 Midterm, Fall 2009 Midterm, Spring 2009 Midterm, Fall 2008 Midterm, Spring 2008 Midterm, Fall 2007 Midterm, Fall 2000 Midterm, Fall 2001 Midterm, Fall 2002 Midterm, Fall 1999 Midterm, Spring 2001 Midterm, Spring 2002 Midterm |
||
| MON MAR 26 | Post Exam Review
ADO/XML in .NET Data Binding |
||
| WED MAR 28 | Updating SQL in .NET XML in .NET Web Applications |
||
| MON APR 2 | Security Issues SQL Injections -- Part I (here) |
||
| WED APR 4 | Injections and other Nasties-- Part II (here)
Regular Expressions A Simple Encrypt/Decrypt VBScript Security .NET Collections Server Controls Web Services |
||
| MON APR 9 | XML with MS Server 2000 Introduction FOR XML RAW FOR XML AUTO ELEMENTS |
||
| WED APR 11 | Portals, Frames, Ajax, Dashboards and Sharepoint | ||
| MON APR 16 | ASP PHP Comparison (here)
Email using CDO (here) |
||
| WED APR 18 | Web Crawling (here) | ||
| MON APR 23 | OpenXML
.net graphics COBIT (see MIS 4373) COSO/ERM and ITIL (see MIS 4373) |
||
| WED APR 25 Exam Review | |||
| MON APR 30 |
FINAL EXAM -- distributed in class Due back to Room 280E MH 5:30 PM FRI MAY 4
Sample Exams:
|
All assignments should be complete and ready for take-home exam Take-home Exam due back to the instructor's office (280E MH) by 5:30 PM FRI MAY 4 | |
| WED FEB 1 | Last Day to Drop a Class | ||
| MON-SAT MAR 12-17 | Spring Holiday | ||
| WED MAR 28 | Exam 1 (in class) | ||
| TUE APR 3 | Last Day to Drop without Receiving a grade | ||
| MON APR 30 | Exam 2 (handed out in class, returen by 5:30PM MAY 4) | ||
| ADMINISTRATIVE NOTES | |||
| |||