How to Create Login Page in ASP.NET Core MVC with Database

Here I will explain how to create custom login page in ASP.NET Core MVC with database. Razor pages is used for display view and ADO.NET for database operations. In this example I have used stored procedure for validation the user.

[shaakirahcornelius]

this was so helpful ! Busy with my third year project and this video made it easy to understand

[fitnesssecrets]

Really thanks to you sir... Please make more videos on ASP. Net Core MVC or Razor pages

[FarazAzhar]

Nicely explained. Why was it necessary to use a stored procedure ? Could have queried it directly from the table.

[rebecaparedes]

Hi there! I have a problem I wrote all the code but it gives me an error in com.ExecuteNonQuery();
Error: 'Could not find stored procedure 'Sp_Login'.'
This exception was originally thrown at this call stack:
[External Code]
in db.cs
in HomeController.cs


Please help

[matiasdieguez]

Hi I am getting the login page but when I try to sign in nothing happens. I am getting no erros either any ideas of where I should check. Cheers.

[isaacrabin]

Is that OK to use the the "PASSWORD" as password in a login mechanism in the era of .Net Core (+ .Net 5, 6) ? 😕

[enriqueestrada]

i have a problem, always TempData say "Admin id or Password is wrong"

[shruti]

Sir itz showing error like dis procedure sp_login expects parameter @Admin_id even after properly passed values also...how i resolve it?

[k-popworldwide]

My view page is showing the form but no validation from the TempData is popping up. Can anyone tell why ?

[danielmaria]

can you do the same exact code with EFW?

[developersyard]

make a vedio on same this process using Entity Framework

[kumaravelk]

Hi bro, can we do authorization in this login form

[aminebessalah]

Bro you can use Microsoft AspNet.Core Identity

[jovan]

hi sir, i have this error SqlException: The EXECUTE permission was denied on the object 'Sp_Login', database 'starbucks', schema 'dbo'. pls help

[luisitoelpillopalomon]

How do you connect the SQL server with ASP.NET CORE mvc?

[pradhityabayu]

2.0 and 2.2 version are same? or not much difference?

[MadhuNepalu]

how can we store hassed password rather same password in database?

[putinninovacuna]

why don't you use entity framework core code first ? can I use EF core ?

[aishwaryarh]

Can we do the same with asp.net web application with .net framework