drshahizan/learn-aspnet

This course introduces the fundamentals of web development using ASP.NET, with the aim to develop a database (SQL Server) driven website.

Don't forget to hit the ⭐ if you like this repo.

Programming Technique 3 (SCSJ3253)

The information on this Github is part of the materials for the subject Programming Technique 3 (SCSJ3253). This course introduces the fundamentals of web development using ASP.NET, with the aim to develop a database (SQL Server) driven website. The course will provide students with conceptual and practical understanding of website design and development and encourages the integration of good interface design with effective system functionality. An introduction is provided to AJAX (Asynchronous Javascript with XML)

Contents:

• About Us
  • Contents:
• Course Learning Outcome
• Notes
  • What do you need
  • Introduction to Visual Studio
    • Youtube
  • History
  • Database
  • Themes and Skins
  • Bootstrap and Master Pages
  • Navigation Control
  • AJAX🔥
  • Cookie and Session🔥
  • XML🔥
  • Adv Database🔥
• Lab
  • Book
  • Standard Control
  • Lab: Database
    • Microsoft SQL Server
    • Microsoft Access
    • MySQL
  • Styles and Master Pages
• Case Study
• Assignment
  • Assignment 4: Web Design
    • Tasks
    • 🌟 Solution
• Project
• Books
• Final Exam
  • Contribution 🛠️

Course Learning Outcome

1. Describe the key features of the Microsoft .NETFramework and ASP.NET. Understand event driven programming model and the .NET framework.
2. Design and implement web applications based onan analysis of business needs that use the .NET framework and a web development language
3. Demonstrate the ability to construct multi-tier server driven dynamic web application incorporating access to databases using appropriate software methods and tools.
4. Work in a team to develop a medium to complex program as a group mini project, applying the ASP.NET framework.

Notes

What do you need

• 7-Zip
• C# Notes for Professionals book
• Visual Studio 2022 (Getting Started) Download & Install
• Visual Studio : How to fix missing ASP.NET template for .NET Framework
• How to Do Web Forms in VS 2022

Introduction to Visual Studio

• Visual Studio 2022
• Your Ultimate Guide To Visual Studio vs Visual Studio Code
• Wikipedia: Visual Studio
• Welcome to the Visual Studio IDE
• Keyboard shortcuts in Visual Studio

Youtube

• Visual Studio 2022 (Getting Started) Download & Install
• Websites in Visual Studio 2022(HTML /JavaScript /CSS)
• How to install Visual Studio 2022 on Windows 11
• WebForms in Visual Studio 2022 (Getting Started)
• Visual Studio 2022 | Getting Started Web Design | HTML & CSS
• GitHub and Visual Studio Community 2022
• History of Visual Basic
• Bill Gates demonstrates Visual Basic (1991)
• Basic Web form Using Visual Studio 2022
• First ASP. Net Project
• ASP.net DropDownList Controller
• Creating Two ASP.Net DropDownLists Controls
• Video: Static vs Dynamic Websites - What's the Difference?
• ASP.NET Lifecycle | ASP.NET Page Lifecycle Explained

History

• Evolution of The Web : Web 1.0, web 2.0, web 3.0 and beyond
• Web Evolution from 1.0 to 3.0
• The History of Web Development Technology
• The History of ASP.NET (Part 1)
• The History of ASP.NET – Part II (Covers ASP.NET MVC)
• The History of ASP.NET – Part III (Covers ASP.NET Core)
• Difference between ASP.NET WebForms and ASP.NET MVC
• ASP.NET MVC vs Webforms
• Page Life Cycle In ASP.NET
• Microsoft: Learn ASP.NET
• Tutorialride: ASP.NET Tutorial
• Tutorialspoint: ASP.NET

Database

• Creating Sql Server
• ASP.Net Database Project
• Display Two Related Tables into a single GridView🎥
• Working with GridView & DetailsView Controls🎥
• Various Data Bound Controls Used in ASP.Net
• Joining Three or More Tables in SQL Server
• SQL Cheat Sheet
• 52 SQL Editors and IDEs Compared: The Ultimate List
• 60 Best Resources for Learning SQL
• 19 Best Database Books
• SQL Server

Themes and Skins

• Themes💾
• Skins💾
• Building Beautiful, Responsive Sites with Bootstrap
• How To Add Bootstrap In ASP.NET (MVC & Web Forms)
• ASP.NET Themes and Skins🎥
• How To Apply Free Bootstrap Themes in ASP.NET🎥
• 10 Best Powerful ASP.NET Templates 2022
• Future of ASP.NET

Bootstrap and Master Pages

• Responsive Web Design
• Bootstrap 5 Tutorial
• Twitter Bootstrap Grid Examples
• Medical Care Application UX Case Study
• Mobile Web Menu - Mamak
• Top 8 Bootstrap Practice Projects For Beginners 2022
• Master Page in ASP.NET💾
• ASP.NET Master Page🎥
• Creating Master Page using Visual Studio 2022🎥
• Free download master page web templates files in .html .css .js format

Navigation Control

• Navigation Control in ASP.NET
• ASP.NET Site Navigation Overview
• Video: ASP.NET - Navigation Controls

AJAX🔥

• AJAX Control Toolkit
• AJAX Introduction
• Ajax Control🎥
• Video: How to install and download latest ajax toolkit
• Download: AjaxControlToolkit
• Install AJAX Control Toolkit in Visual Studio

Cookie and Session🔥

• ASP Cookies
• ASP.NET Cookie
• ASP Session Object
• ASP.NET Session
• SessionID
• ASP.NET - Managing State
• State Management
• ViewState
• Github: lab/cookie-session

XML🔥

• XML Tutorial
• Video: Reading/Writing to XML file in Visual Studio 2022🎥
• Using XML in ASP.NET
• XML Tree
• Walkthrough: Creating a Web Page to Display XML Data
• Displaying XML Data in ASP.Net GridView
• Binding GridView From XML Using ASP.Net
• Lab: books.xml
• Lab: style_sheet.xslt
• Display XML Document in ASP.NET using XML Control
• Read and Write XML Data Using Asp.Net

Adv Database🔥

• LINQ - SQL
• Sample LINQ Queries
• Add LINQ to SQL Tools in Visual Studio🎥
• Simple Tutorial with example of using LINQ to SQL in ASP.Net Website using C# and VB.Net
• SQL Stored Procedures for SQL Server
• Using Stored Procedures With ASP.NET

Lab

Book

• Chapter 4
  • Lab 4.1: AdRotator (page:97)
  • Lab 4.2: Calendar (page 105)
  • Lab 4.3: DropDownList (page 112)
  • Lab 4.4: Image (page 118)
  • Lab 4.5: ListBox(page 125)
• Chapter 5
  • Lab 5.1: Conversion of Decimal numbers to Octal and Hexadecimal (page 166)
  • Lab 5.2: Floating point numbers (page 169)
  • Lab 5.3: Numeric variables (page 179)
  • Lab 5.4: Arithmetic Operators (page 191)
  • Lab 5.5: Mathematical functions (page 195)
• Chapter 6
  • Lab 6.1: Changing the shape of characters (page 212)
  • Lab 6.2: Replace function (page 233)
  • Lab 6.3: Space Function (page 241)
  • Lab 6.4: Various Dates and Times (page 247)
  • Lab 6.5: Date and time (page 249)
• Chapter 7
  • Lab 7.1: If Statement (page 259)
  • Lab 7.2: ElseIf Statement (page 268)
  • Lab 7.3: Select Cade statement (page 278)
  • Lab 7.4: For Next Statement (page 286)
  • Lab 7.5: For Each statement (page 290)
• Chapter 8
  • Lab 8.1: RegularExpressionValidator control (page 328)
  • Lab 8.2: RequiredFieldValidator control (page 333)
  • Lab 8.3: RequiredFieldValidator and CompareValidator controls (page 336)
  • Lab 8.4: RequiredFieldValidator control (page 339)
  • Lab 8.5: ValidationSummary control (page 343)

Standard Control

• Lab 1: ASP.NET Fundamentals
• Lab 2: Conditionals
• Lab 3: Pizza store
• Lab 4: JDT NBA team
• Lab 5: More controls

Lab: Database

Microsoft SQL Server

• Lab 1: Create Table
• Lab 2: Data binding
• Lab 3: Implementing CRUD in FormView

Microsoft Access

• Lab 4: Microsoft Access Database Engine 2016 Redistributable: AccessDatabaseEngine_X64
• Lab 5: Data binding using an Access database
• Lab 6: Filtering data
• Lab 7: Data binding: Using a DropDownlist to filter data
• Lab 8: Data binding: Using calender control to filter data
• Lab 9: Working with relational database

MySQL

• Lab 10: How to Bind Data From MySQL Database to GridView

Styles and Master Pages

• Lab 1: Style sheets
• Lab 2: Themes & Skin
• Lab 3: CSS Template
• Lab 4: Master page: Intro
• Lab 5: Master page E-learning
• Lab 6: Master page: brown shadow template
• Lab 7: Master page: ASP.NET Web Apps

Case Study

• Danny’s Diner (Question)
• Danny’s Diner (Solution)
• DB source code

Assignment

Assignment 4: Web Design

This case study can be completed in groups (four students per group - max). Please submit source code and reports using. This report outlines the tasks you completed.

Tasks

• This assignment requires you to complete a project using the concepts of Master Pages, Skins and Themes.
• You need to use Bootstrap to complete this task.
• The Malaysian culture is essential to this project's concept.

Examples of websites that you can referred:

1. Mobile Web Menu - Mamak
2. Berau-by-Benak
3. Cultured Society Website
4. Malaysian Food Culture
5. BOOS - Kadazan Language Learning

🌟 Solution

Group	Title	Github
Ainon	myLekor
Catchy	Satay Tepi
Nazariah	Penang food hunter
Ramli	Batik the unity art

Project

Group	Title	Files
Ainon	FIFA on the go
Catchy	Player Scouting System
Charlene	Qatar 2022 Fifa World Cup Players List
Ramli	Fifa World Cup

Books

1. Pengaturcaraan Web ASP. NET Menggunakan VB dan C#

   

   🛒Buy: Shopee

2. Pembangunan Aplikasi Web menggunakan ASP.NET

   

   🛒Buy: Shopee

Final Exam

• Cover page

Contribution 🛠️

Please create an Issue for any improvements, suggestions or errors in the content.

You can also contact me using Linkedin for any other queries or feedback.