Course Overview
This course is for Beginners to ASP.NET having some knowledge of C# or similar programming languages.
In this course, I will show you how to use SqlClient to connect to the database and to execute SQL queries. In addition, I will show you how to implement the traditional authentication using Sessions.
We will use Visual Studio 2022 to connect to the SQL Server and to create the database/tables. So we don’t need to install SSMS (SQL Server Management Studio).
In this course, you will learn:
- How to create an ASP.NET Core Web Application with Razor Pages
- How to create databases and tables using SQL Server and Visual Studio 2022
- How to update the layout of the application
- How to use Session data
- How to use Cookies
- How to validate forms using attributes and model binding
- How to send emails using ASP.NET Core and SendGrid
- How to Implement Authentication and Role based Authorization
- How to reset user password
- How to perform CRUD operations (Create, Read, Update and Delete) on the database using ASP.NET and ADO (no Entity Framework)
- How to perform CRUD operations using Entity Framework
- How to use pagination (Split data on multiple pages)
- How to add advanced search functionalities
- How to upload images to the server
To follow this course, you need to install the following tools
- Visual Studio 2022
- Microsoft SQL Server
Also it is necessary to install two components into Visual Studio: “ASP.NET and web Development” and “.NET Desktop development”
FAQ
FAQ area empty
Course curriculum
-
Introduction
183 Xem trước -
Create New Project
49 Xem trước -
Connect to SQL Server Database and Create a Table
169 -
Install SqlClient Package
48 -
Contact Form - Create the Form
498 -
Contact Form - Traditional validation
610 -
Contact Form - Validation using Attributes and Model Binding
822 Xem trước -
Contact Form - Add Messages to Database
209 Xem trước -
Send Emails
378 Xem trước -
Contact Form - Send Confirmation Emails
121 -
Update EmailSender
64 -
Messages - List received messages
887 -
Messages - Add Table Pagination
588 -
Message Details
529 -
Delete Messages
234 -
Source Code
-
Introduction
193 -
Create books table and add images
264 -
Books - List the books
918 -
Books - Add search functionality
363 -
Books - Add pagination
592 -
Books - Add sort functionality
836 -
Create Books - Build the Form
943 -
Create Books - Upload images
194 -
Create Books - Insert Books in Database
228 -
Edit Books - Create the Form
831 -
Edit Books - Update image
233 -
Edit Books - Update Database
210 -
Delete books
417 -
Fix empty images error
66 -
Source Code
-
Introduction
261 -
Add tables to database
129 -
About Sessions
260 -
Enable Session Middleware
111 -
Register - Update Navbar
263 -
Register - Create the Form
655 -
Register - Create new Account
350 -
Register - Send Confirmation Email
138 -
Register - Create Authenticated Session
162 -
Register - Access Control
158 -
Login - Create the Form
497 -
Login - Create Authenticated Session
274 -
Logout
146 -
Authorization - Create Attributes
337 -
Authorization - Use Attributes
331 -
ForgotPassword - Create the Form
383 -
ForgotPassword - Send Reset Token
373 -
ForgotPassword - Save Reset Token
203 -
ResetPassword - Create the Form
638 -
ResetPassword - Update the Password
401 -
Profile - Show Profile
401 -
Profile - Create Update Form
936 -
Profile - Update Profile
577 -
Users - Read Users from Database
369 -
Users - Display Users
345 -
Users - Add Pagination
448 -
Source Code
-
Introduction
307 -
Create Order Tables
274 -
Home page - Create Sections
750 -
Home page - Create Book Items
609 -
Home page - Read Book Items from Database
788 -
Shopping Cart - Introduction
318 -
Shopping Cart - Add Icon
294 -
Shopping Cart - Update cookie using Javascript
789 -
Shopping Cart - Read cookie on the server
147 -
Book Details - Read book details from database
320 -
Book Details - Display book details in razor page
565 -
Book Search - Create the Search Form
821 -
Book Search - List Book Items
581 -
Book Search - Add Search Functionality
307 -
Book Search - Implement Pagination
609 -
Cart Details - Create Page Template
498 -
Cart Details - Create OrderItem Class
130 -
Cart Details - Convert Cookie to Dictionary
275 -
Cart Details - List Cart Items
475 -
Cart Details - Add Subtract Delete Items
557 -
Cart Details - Order Summary
620 -
Cart Details - Create Orders
1113 -
Admin Orders - OrderItemInfo and OrderInfo
557 -
Admin Orders - Read Orders from Database
284 -
Admin Orders - List Orders
704 -
Admin Orders - Add Pagination
418 -
Admin Order Details - Read Order Details from Database
480 -
Admin Order Details - Show Order Details in the Page
652 -
Admin Order Details - Update Payment Status and Order Status
671 -
Client Orders
381 -
Client Order Details
416 -
Update Layout File
263 -
Source Code
-
Introduction
145 -
Create Project and Database
149 -
Install Entity Framework Packages
71 -
Create ApplicationDbContext
200 -
Create Product Model and Products Table
239 -
Add Products to Database
99 -
Read Products
453 -
Add Dropdown Item to Navbar
191 -
Create ProductDto Model
147 -
Create Product - Create the Form
390 -
Create Product - Form Validation
318 -
Create Product - Save Products
263 -
Update Product - Show Product Details
486 -
Update Product - Update Details
355 -
Delete Product
216 -
Read Products - Pagination
560 -
Read Products - Search
316 -
Read Products - Sort
866 -
Source Code
-
Introduction
295 -
Required Domain Models
109 -
Create Contact & Attachment models and database tables
346 -
ContactDto Model
124 -
Contact Form - Create the contact form
522 -
Contact Form - Save the contact
695 -
Contact List - Show the contact list
474 -
Contact List - Pagination
335 -
Contact Details - Read the details from the database
248 -
Contact Details - Display the details
333 -
Contact Details - Download attachments
392 -
Delete Contacts
360 -
Send Emails using Brevo / SendinBlue
870 -
Source Code
-
Introduction
52 -
Edit Application Layout
187 -
Home Page - Create Hero Section
288 -
Home Page - Display Newest Products
482 -
Products Page - Display All The Products
240 -
Products Page - Add Pagination Buttons
309 -
Products Page - Add Search Form
417 -
Products Page - Filter Products
288 -
Products Page - Sort Products
349 -
Display Product Details
341
-
Introduction
180 -
User Registration, Authentication and Authorization
957 -
Role-based Authorization
726 -
Create Entity Models and Tables
387 -
Shopping Cart Storage Principle
202 -
Add the Shopping Cart Icon To the Navbar
181 -
Add Products to the Shopping Cart
672 -
Read the Cookie on the Server and Display the Cart Size
250 -
Shopping Cart - Display Items
770 -
Shopping Cart - Create the Form
482 -
Shopping Cart - Create the Order
682 -
Admin Orders - Display Orders to Admin
611 -
Admin Orders - Add Pagination
198 -
Display Client Orders
325 -
Source Code
Requirment
-
Beginner knowledge of C#, SQL, HTML and Visual Studio 2022
Outcomes
-
Create a full ASP .NET Core Web Application using Razor Pages
-
Create SQL Server databases and tables using Visual Studio 2022
-
Perform CRUD Operations on SQL Server Databases
-
Use Pagination to Split the Content over Multiple Pages
-
Implement the Search Functionality to Find Data in the Database
-
Upload Images to the Server
-
Implement Authentication and Role based Authorization using Session Data
-
Send Confirmation Emails
-
Using Cookies to Add/Subtract/Delete Items from the Shopping Cart
-
Form Validation using Attributes and Model Binding
0 Student
1 Course
0 review