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.

[@CsharpSpace]

For Source Code and Step to Step Tutorials visit: www.voidgeeks.com/tutorial/How-to-Create-Simple-Login-page-in-ASPNET-Core-MVC-with-Database/10

[@shaakirahcornelius565]

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

[@fitnesssecrets4046]

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

[@CsharpSpace]

Sure will make a video on this topic

[@rehankhan-fp1rm]

Nice work...keep it up..

[@FarazAzhar]

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

[@CsharpSpace]

Yes you can use query directly here, I am just use stranded way to code

[@softsysdev9985]

Thaks just i was looking for

[@rebecaparedes6903]

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

[@CsharpSpace]

Create stored procedure sp_login in database, you have not created procedure in database

[@AmarjeetKumar-vm9xb]

Thank you Sir

[@rakeshchandraul764]

Thanks sir

[@matiasdieguez8634]

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.

[@CsharpSpace]

Try to debug application and set break point for actual error

[@developersyard2805]

make a vedio on same this process using Entity Framework

[@enriqueestrada4204]

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

[@isaacrabin375]

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

[@aminebessalah909]

Bro you can use Microsoft AspNet.Core Identity

[@shruti8827]

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

[@CsharpSpace]

Debug your application and check your value for this parameter, I think this value is null.

[@danielmaria7965]

can you do the same exact code with EFW?

[@k-popworldwide3282]

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

[@CsharpSpace]

I think you will not add tempdata on view page.

[@jovan9811]

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

[@pjthunder]

i had the same issue. need to add EXECUTE SP permission on database

[@luisitoelpillopalomon8768]

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

[@CsharpSpace]

Check my video for Connection string: kzbin.info/www/bejne/moWseZqMirSfl80 Article: voidgeeks.com/tutorial/How-to-read-Connection-string-from-Appsettingjson-in-ASPNET-Core/6

[@pradhityabayu5937]

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

[@CsharpSpace]

For difference you can can check this article: docs.microsoft.com/en-us/aspnet/core/release-notes/aspnetcore-2.2?view=aspnetcore-3.1

[@kumaravelk9829]

Hi bro, can we do authorization in this login form

[@omamam.alnajjar4367]

Git heb code?

[@MadhuNepal4u]

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

[@CsharpSpace]

You can use encryption and decryption for this

[@putinninovacuna8976]

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

[@CsharpSpace]

Yes you can use it

[@madalinsoare8769]

He already had the database so he could of used EF database first aproach which is older but still very widely used. It is an interesting way to send data like that betwen client and sever. I used the old way so far with ajax calls from javascript, but I am not sure yeh what's the best aproch regarding security issues. I think this is better though but I am not sure. My question is how do you make a page that once you have registered you can't come back to the frost page. That would be intereting to do

[@aishwaryarh5274]

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

[@CsharpSpace]

Yes you can do.

[@rushikeshkarde134]

I have a core login not found error

[@CsharpSpace]

In which line you found error?