Create Login Page in Asp.net (MVC 5 & SQL Server)

[@CSharpCodeAcademy]

New Tutorial Out on Asp .Net Core (MVC): kzbin.info/www/bejne/qWTSaZyrpKmAr6s

[@mohitgohel4671]

code send me

[@RagePower2000]

For people following step by step, know that this is prone to sql injection.

[@dingoDogMan]

Its crazy to me how this video has so made likes and so few dislikes when they are storing passwords as plain text. No reputable website would ever do this and you are compromising users private information.

[@benjaminasracas4525]

@@dingoDogMan bruuuuh, it's not a tutorial how to encrypt password :D

[@michailantipov6914]

@@benjaminasracas4525 it's not a tutorial at all. But a tutorial how to write a Hindu code

[@kennethvenzonmusic_]

Well, then make a better video for us.

[@RagePower2000]

@@kennethvenzonmusic_ I do not have the time, just look up how to use sql parameters.

[@yasiramer2013]

I actually had fun watching this video and didn't skip any part. thanks!

A

[@sannidhibhadarka155]

It was very helpful. thanks for creating video

[@CSharpCodeAcademy]

Glad it was helpful!

[@justinlemuel12]

I tried this and it didn't work for me. I don't know how did you get the values from the form, I tried putting the "Verify" to the form action but it just gives me the error "the resource cannot be found"

[@christosskartsaris19]

I have the exact same problem. after submitting the page it says /Verify page is not found. Can anyone help?

[@justinlemuel12]

@@christosskartsaris19You need to add [HttpPost] above the Verify Method and then on your Login View put "Verify ( or the name of your method)" in the action attritbute.

[@christosskartsaris19]

@@justinlemuel12 the problem was the path of controller and view. I added asp-controller and asp-action in the form tag and it worked.

[@MithilaDamruwan]

What an amazing video. Thank you

[@resterops]

Helal Kardeşim, gurur duydum. (En iyi Motivasyon Müzikleri'nden yakaladım:))

[@kittygina348]

Glad this worked out for me. Quite straightforward video also very helpful. Amazing keep it up.

[@ngonichigariro1162]

do you mind sharing the login template please

[@JorgeVargas-zd1mn]

Nice video, but you should create a service layer for the conection. Do not put database access on the controller. Views, Controllers, Services, Bussiness, Models

[@CSharpCodeAcademy]

thanks for your feedback, this is basic stuff for absolute beginners

[@mangeshsodnar8426]

@@CSharpCodeAcademy I was looking for exactly this type of Api.....thanks bro

[@easytechtv2]

Ow-some and Straight Forward Video. This helped me about to get started with MVC 5. Now I can create login Form in MVC. Thanks

[@hakanakcil_]

0:55 en iyi motivasyon müzikleri :)

[@qtedurepe]

THANKS IT WORKED hope i can add more based on this project

[@CSharpCodeAcademy]

Glad it helped

[@TheTakenKing999]

Wait how is this not throwing a 405 error on the browser when u enter credentials? Your razorview layout has a tag for form method: post (10:53), while you have a httpget modifier on your index method (the one that returns ur main view) am I missing something?

[@CSharpCodeAcademy]

you're missing something and that is after POST request the controller generates Get request call, there are two requests one after another.

[@Crychimou]

Very nice tutorial

[@CSharpCodeAcademy]

Thank you! Cheers!

[@0422LAUREL]

thank you soo much for your help!! continue with this chanel please .... :)

[@0422LAUREL]

sabir ali fine thanks! How about you?

[@0422LAUREL]

sabir ali no , im from México 🇲🇽 jeje sorry

[@rotichke]

Great, I enjoyed every bit of this!

[@CSharpCodeAcademy]

Glad you enjoyed it!

[@ArturoLopez-kl1uw]

Wao me sirvió mucho gracias ! That really fix my problems, thanks so mich! From México

[@TheGeardarko]

Si te funciono

[@yesindia8447]

Thank you so much guys From India🇮🇳

[@CSharpCodeAcademy]

I appreciate it.

[@sulemanali4006]

Great work bro awesome video can you please do delete and update as well

[@CSharpCodeAcademy]

Sure, I'll

[@jordanepellerin6684]

Great Thanks. But why tik tok background music 😭

[@CSharpCodeAcademy]

Don't know

[@codywalicek553]

Can you show how to actually make the database? Otherwise great video!

[@gabrielralfcaceresgabriell319]

Thank you so much! Muchas gracias saludos desde El Salvador!

[@CSharpCodeAcademy]

me alegra que lo hayas disfrutado

[@rohithmp9735]

Felt like it would be soo nice if there were an explaination given as a voice.

[@JustGameAcadamy]

Hi, this video has been very helpful so far. I am stuck at 3:47, however, because I can't find the "WPF" subfolder in the "Databases" subfolder. Would you be able to help?

[@CSharpCodeAcademy]

you can use Directory.GetCurrentDirectory() to get the current location then you can set the path to sub-folder and you can switch the directories in the same solution.

[@CSharpCodeAcademy]

Here is Solution to get Subfolders using absolution path. stackoverflow.com/questions/10668481/listing-only-subfolders-in-c/10668520

[@JustGameAcadamy]

@@CSharpCodeAcademy Thanks! Yeah I figured out I would have to create the Database on my own, but I'm not sure what to put in the query window.

[@JustGameAcadamy]

@@CSharpCodeAcademy Ah nevermind, I think I figured that out too, and to make the table as well. Thanks for the help, nonetheless!

[@themylkking8345]

tks for this tutorial video :D It saves my day!

[@CSharpCodeAcademy]

Glad to hear that!

[@kick3020]

thank you very much for your beautiful video

[@moodplaymusic]

Amazing video! helped me a lot, Can you do a video for a registration form using postgresql ?!

[@Alfa01x]

Hi! Did you manage to do it with postgresql? If so, can you please share? It's urgent!

[@CSharpCodeAcademy]

@Tuğçe Beyhan try this => com.CommandText = "select from tbl_login where username = '"+acc.Name+"' and password = '"+acc.Password+"'";

[@faisalyousfani5450]

Great Tutorial

[@martinporras3154]

you are the fucking best ,you save my ass because i have a proyect in 1 week and i let my login for the final

[@eljona2085]

thank so much you video help me with my proyect

[@yi-tinglee553]

Hey nice work ! from Taiwan

[@crazy-nk8vf]

goooooood daaaaaamn thaaaaank you sooooooooooo much

[@fernandocabrera6397]

Great Video!!!

[@trungpvq8181]

Thank you so much. But i think instead of creating new view (create and error) we can use something like javascript tho?

[@CSharpCodeAcademy]

Obviously, we can

[@siwarmendessi8863]

i'm still stuck in the dr.comconnection that part, where my dr is higlighted in red...wonder whats the problem?

[@CSharpCodeAcademy]

can you please let me know the exact time in the video where you stuck so I can help you more. and dr.comconnection does'nt exist.

[@dhiyaahadan1191]

@@CSharpCodeAcademy it's on AccountController dr=com.ExecuteReader. It say System.Data.SqlClient.SqlException: "Incorrect syntax near the keyword User"

[@afrahmarouane1121]

i did not find the mvc5 layout page razor in my project?

[@jonthamastersmooth]

How do I get my login form to route to my Dashboard when the user logs in? I am having issues with that.

[@danielaragon9228]

Muchas Gracias me sirvió de mucho seria bueno si lo tradujeras al español saludos desde peru Thank you very much, it would be very good if you translated it into Spanish, greetings from Peru.

[@CSharpCodeAcademy]

I've opened contribution for you so you can add subtitles by yourself. so other Spanish can easily understand.

[@mohammedhilal7504]

suiiii

[@Jhunter1ish]

Is there anything here that stops the user just changing the URL themselves? Not exactly secure...

[@michaelg4334]

I can't get my SQL to connect to this project. When I open up SQL Studio, I don't have WPF under databases

[@Cascascap]

I hope you got the answer by yourself after 3 weeks, but just in case, you don't have it because that's his own database, you have to create your own.

[@jonschld]

How can you for example go from /Account/Login to for example /Dashboard? Nice video btw!

[@CSharpCodeAcademy]

use asp link to go

[@priyagupta1256]

This how to make user dashboard

[@sarthakpatelia9888]

Sir i need to learn how to build E-commerce website using bootstrap in mvc, i need your help please bring tutotrial on this

[@CSharpCodeAcademy]

I'll try my best to publish asap.

[@georgiana-larisagaspar6905]

Nice tutorial. Great job! Can you please send me the code?

[@stiveroncal2735]

Greetings from Peru

[@mads_girl_vlog]

Can u pls explain how to change the bg image ...becoz I don't need that

[@erinyadel2315]

Excuse me, my server name has (\) and it occur error in ConnectionString. what should i do?

[@CSharpCodeAcademy]

it can't be an issue.

[@CSharpCodeAcademy]

try @"connection string" instead " ", use @ sign before " "

[@erinyadel2315]

@@CSharpCodeAcademy Thank u so much

[@MANISHKUMAR-kr5wj]

Good morning sir some problems will come with SQL server connection when we enter the user id and password and click login then it's redirect to accountcontroller.cs page .how to solve this problem.

[@CSharpCodeAcademy]

did you mention the path in form attributes (asp-controller & asp-action)? if not then mention them and your page will be redirector to the correct controller and call the action method you mentioned.

[@2048-cupcakes]

Server Error in '/' Application. The resource cannot be found. Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly. Requested URL: / Any solution please

[@CSharpCodeAcademy]

It seems you assign the wrong path, in the form tag use these two attributes asp-controller="YOUR Controller name" asp-action="Your Action Method Name"

[@subhashinie6793]

How to connect database..i created database in sql but if i login its showing error..can u please help

[@CSharpCodeAcademy]

here you can find how to setup connection string 04:39

[@fidelrebolledo5382]

How can I redirect from login to an index? after the user accepts?

[@aamirsarfaraz3004]

Everything works fine if I run it from Login.cshtml, it log-in successfully. But if I run from routing and click on Sign In then it gives me below error: "Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly. " Requested URL: /Verify

[@aamirsarfaraz3004]

Finally I rectified this issue by myself. just need to change the RouteConfig.cs as below: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using System.Web.Routing; namespace EMAM { public class RouteConfig { public static void RegisterRoutes(RouteCollection routes) { routes.IgnoreRoute("{resource}.axd/{*pathInfo}"); routes.MapRoute( name: "SignIn", url: "Verify", defaults: new { controller = "Account", action = "Verify", id = UrlParameter.Optional } ); routes.MapRoute( name: "Default", url: "{controller}/{action}/{id}", defaults: new { controller = "Account", action = "Login", id = UrlParameter.Optional } ); } } }

[@saharali4531]

@@aamirsarfaraz3004 after doing theses changes i'm still facing this error.

[@putinninovacuna8976]

im absolute beginner can I use entity framework code first to make the queries?

[@CSharpCodeAcademy]

Sure, you can use

[@benjaminasgo]

Where is your login button written at??? I don't see it in your Login.cshtml

[@MartinFerenec]

Rule #1... never implement your own authentication and user management system! Problems with your system: - passwords get saved in database in plain text and are not handled properly (they should ALWAYS be hashed and salted) - Vulnerability to SQL injection attacks - Brute-Force attacks - No "Forgot password" - No Email confirmation - No 2FA - ... Use ."NET Identity" to handle/manage user accounts and link the responsive form to it! Your app looks good and everything and it is okay for demonstration purposes of the responsive form. But it is not safe to be deployed in a real-world scenario.

[@joydas1685]

Nice

[@WongLP]

Hey nice work btw! Can I have the Code please?

[@farehaalnaz9840]

Hey i tried to dowload that template but it was giving me thre pictures in part.

[@zayahanhasanshah1337]

can you tell me what does integrated security do?

[@King-Merlin]

entering user name and password and after its showing on the next page cannot log into data base, i don't understand where did go wrong

[@onopvallund9488]

Hello, This is my first project in asp.net mvc ever. And i'm at the end of the video and i wan't to click the login button. But i get a error it can't find the /account/Verify i can't find the solution on google, maybe you guys know it?

[@CSharpCodeAcademy]

send me screenshots including error + C# code + front-end, then i'll able to assist you.

[@aamirsarfaraz3004]

Hi, Just change RouteConfig.cs as below, and it will work fine. using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using System.Web.Routing; namespace EMAM { public class RouteConfig { public static void RegisterRoutes(RouteCollection routes) { routes.IgnoreRoute("{resource}.axd/{*pathInfo}"); routes.MapRoute( name: "SignIn", url: "Verify", defaults: new { controller = "Account", action = "Verify", id = UrlParameter.Optional } ); routes.MapRoute( name: "Default", url: "{controller}/{action}/{id}", defaults: new { controller = "Account", action = "Login", id = UrlParameter.Optional } ); } } }

[@awaismughal882]

Even Done Everything As Per Video In Spite Facing Compile Error As Code No "CS1009" - "Unrecognize Escape Sequence Error" .. How To Remove It And Build It Successfully? Please Help Me..

[@fofagen8188]

Hi, i have a problem in the end when i try to log in, when i put my username and password it says error, can you help? Thanks!

[@veenasrilakshmi.t2979]

Please give the route config part for giving controller name and action. For a reference.

[@CSharpCodeAcademy]

Here you go docs.microsoft.com/en-us/aspnet/core/mvc/views/working-with-forms?view=aspnetcore-6.0

[@pandybear4256]

it's so unhandy that you dont show the functionality of the login button. How do I connect the Verify method with the login method? please help

[@CSharpCodeAcademy]

follow the instructions carefully ...

[@snawzay.7780]

I'm watching full tutorial code with shoulder dance..

[@vungoxuan9007]

do u make video about register form?

[@CSharpCodeAcademy]

Sure, i'll upload it so stay tuned.

[@onestopmusic265]

Can someone please help mein with this error ? System.Data.SqlClient.SqlException: 'Cannot open database "WPF" requested by the login. The login failed. Login failed for user

[@CSharpCodeAcademy]

It seems either the user is invalid or you entered the wrong credentials.

[@jean-woodlyndorsinvilbertr6673]

I want you to give us the link of files in the video description...

[@CSharpCodeAcademy]

i'll update the links for new videos in the description.

[@Infanuu]

In 10:10 im unable to add image and styles to my VS please anyone help me out!!❤‍🩹🤧

[@MGNS]

Great video. Could you link to the source code?

[@CSharpCodeAcademy]

if you follow the instructions then you'll get your code. However, I'll check my dictionary and I'll upload to cloud then share the link in the description.

[@MGNS]

@@CSharpCodeAcademy Thanks, I found the problem and it works now :)

[@bringchanges]

Can you give me background music name please :)

[@GeekyNiksVlogs]

need help in implementing the same for signup page.

[@sadenlav]

How to create direction session home page?

[@ganenayepurane90s]

nice

[@hugomarcovasquez5044]

help me... Error de servidor en la aplicación '/'. No se encuentra el recurso.

[@CSharpCodeAcademy]

intente agregar atributos a su formulario =>

[@davidhurtado47]

I did it and it was working properlly but now its says Unable to cast object of type 'System.Int32' to type 'System.String'. :/

[@CSharpCodeAcademy]

Make sure you are using the correct Datatype.

[@ngonichigariro1162]

can i please have the files for the template cause im struggling to get it from w3layouts thank you

[@nguyentrungthanhaptechhcm3214]

Server Error in '/' Application. The resource cannot be found. Requested URL: /Verify please help me

[@CSharpCodeAcademy]

try to add attributes to your form =>

[@nguyentrungthanhaptechhcm3214]

@@CSharpCodeAcademy great! thank you so much :)

[@vasga_floze]

I'm using mvc with entity framework, but I can't apply de css to all the views. Someone can help me?

[@CSharpCodeAcademy]

you need to link the css file to _Layout.cshtml file [ inside the shared folder ]

[@vasga_floze]

@@CSharpCodeAcademy Thank u so much! that worked for me!

[@marioroberto1141]

Hello, excellent project, I have problems with public class AccountController : Controller, where ": Controller" line 11 gives me error cs0118 and I can not solve it, help please

[@CSharpCodeAcademy]

please make sure the namespace and controller class names must be different,

[@CSharpCodeAcademy]

You'll get more details there => check out the link: docs.microsoft.com/en-us/dotnet/csharp/misc/cs0118

[@spyrex3988]

backgrounc music a bop

[@kalyanikadam2953]

I got the server error in / application . how to fix it ? Plz help me to fix this

[@CSharpCodeAcademy]

try this =>

[@ROLANDOBONA10]

Hello friend, I have followed exactly all your steps and everything works for me, but at the time of logging in I receive the error "Error connecting to the local database with.open () An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll Additional information: An instance-specific or network-related error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: named pipes provider, error: 40 - Could not open a connection to SQL Server) " Could you help me please

[@CSharpCodeAcademy]

Make sure your connection string is correct. Error will be resolved automatically.

[@ROLANDOBONA10]

@@CSharpCodeAcademy That's right friend, I managed to fix the problem and it was that in the CommandText I had written "tbl_" and that was something from your login table and that was my mistake, thanks for your concern, a question how can I add more windows after having already I miss my login?

[@CSharpCodeAcademy]

understand & follow MVC structure.

[@MyFirstHandle]

@@CSharpCodeAcademy Hey I had the same problem too. I couldn't make the server name totally correct because the code won't allow me to use backslash or I'd get an error but my server name uses a backslash. Is there any way to rename the server name or any code to accept a backslash so I can proceed?

[@tugcebeyhan6069]

Merhaba ben login sayfasını oluşturdum şimdi session işlemi yapmak istiyorum yönlendirebilir misiniz?

[@CSharpCodeAcademy]

Microsoft belgelerindeki bu makaleye göz atın => docs.microsoft.com/en-us/aspnet/core/fundamentals/app-state?view=aspnetcore-5.0

[@salamshah774]

Nice video. But cant download the login template!!!

[@CSharpCodeAcademy]

you can try other templates.

[@vijendramishra729]

This is token based authentication ?

[@CSharpCodeAcademy]

No, it's a basic login tutorial.

[@dprogrammar8144]

please guys i need the sources to this please. i have tried multiple times and still didnt work. help me with the code let copy and check where am wrong

[@CSharpCodeAcademy]

I appreciate you tried several times but as a matter of fact the video is 2+ years old and i don't have the source code. but I'll upload a new video with source code so stay tune.

[@tripletechnology9535]

Thank you so much

[@CSharpCodeAcademy]

You're most welcome

[@_KirubaharanA]

Bro can you please a layout template link that you used in this video

[@CSharpCodeAcademy]

w3layouts.com/template/spin-login-form-flat-responsive-widget-template/

[@raheelahmed603]

Thankyou Soo much

[@yuxeebaxhraf3306]

what to do when using MySQl

[@stiveroncal2735]

cuales son los tipos datos de duplas de la base de datos

[@mohamadbokloch1238]

I have an idea for an online project and I need the help of programmers and experts so help me achieve my dream and I wish you with all my heart that dreams will come true God willing

[@CSharpCodeAcademy]

Ping me on channel email

[@harithak144]

If i enter username and password,it shows 1error in con.Open().how to clear that error

[@CSharpCodeAcademy]

try this code snippet if(con.ConnectionState == ConnectionState.Open){ con.Close(); } con.Open();

[@ShoniNemavhidi]

Thanks mate

[@satishvibes8757]

i am unable download template please guide me

[@fatihakyel5526]

merhaba; Verify yazdığım parametre login.cshtml ile eşleşmiyor her seferinde hata ekranı dönüyor sql parametre string yönlendirmeden yazınca giriş başarılı dönüyor ne yapmalıyım

[@CSharpCodeAcademy]

bu belgeleri okuyun, cevabınızı burada bulabilirsiniz => www.c-sharpcorner.com/UploadFile/2b481f/pass-multiple-parameter-in-url-in-web-api/

[@ygirijareddy4199]

hi i have one doudt for create alogin page

[@CSharpCodeAcademy]

let me know how i can help you?

[@hamzaalitaj708]

please share the code of html,css used in this