CSci260 .NET and Web Programming

(A Programming-Intensive and No-Nonsense Course)
Software/Tool W3Schools W3C C# .NET Visual Studio
HTML & CSS HTML help HTML tutorial CSS help CSS tutorial
ASP.NET ASP.NET help ASP.NET ASP.NET quickstart ASP.NET overview VS Express
Access Database Access help Access Access tutorial
General Information CSci Wiki EITS UND Help Stack Overflow Microsoft Imagine

According to U.S. News & World Report, Best Technology Jobs of 2019 ranked by high-paying jobs that boast low unemployment rates are as follows:
  1. Software Developer: C++, Java, C#, PHP, etc.
  2. Computer Systems Analyst
  3. IT Managers
  4. Information Security Analyst
  5. Database Administrator (and Developer): Oracle, MySQL, MongoDB, SQLite, Access, etc.
  6. Web Developer: HTML, CSS, JavaScript, ASP.NET, Visual Basic, PHP, etc.


Syllabus: Fall 2019   Credit hours: 3
Class times: 03:30pm – 04:45pm, TuTh Classroom: Collaborative Energy Complex 205


Instructor: Wen-Chen Hu   (my teaching philosophy) Office: Upson II 366K
Office hours: 02:00pm – 03:00pm, MoWeFr, or simply dropping in Email: wenchen@cs.und.edu


Prerequisite: CSci161 Computer Science II or consent of instructor


Lecture notes: No textbook will be used. Instead detailed and precise class instructions and interactive, informative, and practical lecture notes (based on W3Schools, ASP.NET, and other online documents and user manuals) will be provided. Collectively, the lecture notes and instructions are more like a small book, which supplies much more information than regular notes do and makes the subject studies much easier. Students will not have problem learning the subjects or taking the exams after studying them and doing programming exercises.


Remark I: Definitions, terminologies, and theories will be discussed minimally in this course. Instead practical works and programming knowledge will be emphasized and enforced.


Remark II: Online asynchronous is also provided for the distance students. It is conducted fully through Internet instruction. For details, check UND Online & Distance Education or DEDP (Distance Engineering Degree Program). Besides, YuJa is used for hosting and sharing lecture videos, and ProctorU is used to monitor the exams.


Instructor’s qualification: The instructor initiated a database-driven web system by using Perl and Sybase in 1997, when not many people were familiar with the Web. Ever since, numerous software and tools such as ASP.NET, LAMP, and Oracle have been used by him to build various web systems. In addition, the instructor has been teaching this course for more than 10 years.


University of North Dakota Course Description —
An introduction to Microsoft .NET and World Wide Web programming for fundamental web content development. Topics including Microsoft .NET concepts, World Wide Web basics, web system structures, technology survey, client-side languages such as (X)HTML and VBScript, server-side languages such as ASP.NET but no database processing, web-host connection, and web content design and development.

Wikipedia
The Microsoft .NET Framework is a software framework that can be installed on computers running Microsoft Windows operating systems. It includes a large library of coded solutions to library programming problems and a virtual machine that manages the execution of programs written specifically for the framework. The .NET Framework is a Microsoft offering and is intended to be used by most new applications created for the Windows platform.

World Wide Web Programming —
Web programming is to design and implement web content. It consists of two kinds of programming:

  • Client-side programming, which is to develop software running on client computers/browsers. The popular client-side languages include CSS, DOM, (X)HTML, JavaScript, XML, XSL(T), etc.

  • Server-side programming, which is to develop software running on servers. The software normally receives requests from browsers and sends the results from databases/files/programs back to the browsers for display. The popular server-side languages include C/C++, Java, Perl, PHP, etc.
PC Magazine
World Wide Web programming is to write the necessary source code to create a web site. At the very least, it refers to writing the HTML pages. However, most web sites also use JavaScript in their HTML pages, and any web site that provides searches, access to databases or any custom processing for the user requires additional programs that run in the web server. Web server processing is programmed in Java, VBScript, Perl and other languages.

A Generic Three-Tiered Client-Server Web System Structure —


An Internet-Enabled and Mobile Database Course Sequence —
This is part of an Internet-enabled and mobile database course sequence offered by me:
CSci260 .NET and World Wide Web Programming

CSci457 Electronic Commerce Systems

CSci513 Advanced Database Systems

CSci515 Data Engineering and Management
The following platforms, software, and tools used in these courses greatly help students look for jobs:
  • CSci260 (.NET and World Wide Web Programming) to build database-driven websites by using

    • Microsoft Access database,
    • Microsoft ASP.NET,
    • Microsoft C# or Visual Basic,
    • Microsoft .NET, and
    • Microsoft Visual Studio.

  • CSci457 (Electronic Commerce Systems) to build electronic and mobile commerce systems by using

    • Android programming,
    • Android-server-database connection,
    • (L) Linux operating system,
    • (A) Apache web server,
    • (M) MySQL database, and
    • (P) PHP.

  • CSci513 (Advanced Database Systems) to build Internet-enabled and embedded database systems by using

    • Android programming,
    • Android SQLite embedded database,
    • JDBC (Java Database Connectivity),
    • object-relational SQL and PL/SQL, and
    • Oracle (an object-relational database).

  • CSci515 (Data Engineering and Management) to build location-based services and data-mining systems to discover knowledge from a large set of data by using

    • Android programming,
    • Android Google APIs and Firebase database,
    • data mining and knowledge discovery,
    • information retrieval,
    • location-based services, and
    • smartphones and mobile handheld devices.


Grading:


Announcements:


Tentative Schedule:


Week

Class Topic Exercise Due Where
1 08/27
08/29
1. Introduction      
  1.1 Course outline      
  1.2 System overview      
  1.3 Technology survey      
2 09/03
09/05
2. HTML (HyperText Markup Language)      
  2.1 Programming Exercise I Exercise I    
  2.2 HTML tags      
  2.3 HTML examples      
09/04 Last day to add a course or drop without record
Last day to add audit or change to/from audit
Last day to receive a refund on a dropped class
Drops after the last day to add will appear on a transcript.
     
3 09/10
09/12
3. XHTML (eXtensible HTML)      
  3.1 Why XHTML      
  3.2 XHTML syntax      
  3.3 HTML5      
4 09/17
09/19
4. CSS (Cascading Style Sheet)      
  4.1 CSS basics and syntax Exercise II    
  4.2 CSS text and fonts      
  4.3 CSS links and lists      
5 09/24
09/26
5. CSS (Cont.)      
  5.1 CSS box model and border   Exercise I  
  5.2 CSS pseudo- class and element      
  5.3 CSS navigation bar and images      
6 10/01
10/03
6. Programming Exercise III      
  6.1 Specifications Exercise III    
  6.2 ASP.NET programming      
  6.3 ASP.NET and Access databases      
7 10/08 7. Databases and SQL      
  7.1 Introduction to databases   Exercise II  
  7.2 SQL (Structured Query Language)      
  7.3 Embedding SQL in ASP.NET      
10/10   Exam I (Thursday)      
8 10/15
10/17
8. C# for ASP.NET      
  8.1 Getting started with C#      
  8.2 C# code samples      
  8.3 C# data types and variables      
9 10/22
10/24
9. C# for ASP.NET (cont.)      
  9.1 C# control structures      
  9.2 C# functions      
  9.3 C# arrays      
10 10/29
10/31
10. ASP.NET: A Database Example      
  10.1 User interface construction Exercise IV    
  10.2 ASP.NET-Access connection      
  10.3 ASP.NET programming      
11 11/05
11/07
11. ASP.NET: Essentials      
  11.1 Getting started with ASP.NET      
  11.2 Dynamic user interface      
  11.3 Request methods and page navigation      
12 11/12
11/14
12. ASP.NET: Critical Controls      
  12.1 Text boxes      
  12.2 Radio buttons      
  12.3 Hidden fields   Exercise III  
11/15 Last day to change to or from S/U grading
Last day to change to or from audit grading
Last day to drop a full-term course or withdraw from school
     
13 11/19 13. ASP.NET: Server Controls      
  13.1 HTML server controls      
  13.2 Web server controls      
11/21   Exam II (Thursday)      
14 11/26 14. ASP.NET: Data Binding      
  14.1 Data binding      
  14.2 List controls      
11/28   Thanksgiving Recess (Thursday) — no classes      
15 12/03
12/05
15. The World Wide Web      
  15.1 Web introduction      
  15.2 Web terminology      
  15.3 Web basics      
16 12/10
12/12
16. Microsoft .NET      
  16.1 Microsoft .NET introduction      
  16.2 Microsoft .NET software      
  16.3 Microsoft .NET framework   Exercise IV We’re here.
17 12/19   Final exam (05:30pm – 07:30pm, Thursday)      
18 12/24 Grades posted before noon, Tuesday