How to Create Login Page in Asp.Net With Sql DataBase

How to Create Login and Logout Page in Asp.net using SQL server database.
The tutorial discusses the following points :
- Create Login Page in asp.net webform
- Logout in Dashboard( Home Page)
Login-Logout System(user authentication) is implemented using a session.
📂 GitHub Repository
► goo.gl/24sG2F
💖 Buy me a Coffee
➤ bit.ly/3L36ut4 (PayPal)
➤ bit.ly/3VF0iPT (Razorpay)
🌀 Related Videos
goo.gl/ySUFf8 : Similar Mvc Tutorials
goo.gl/3ajHuA : Similar C# Video Tutorials
goo.gl/yHZcCo : Build Complete Asp.Net MVC App
goo.gl/ZXKqT9 : jQuery Ajax in Asp.net MVC
🔗 Find me in
Udemy : bit.ly/3RtyQSB
Facebook : / codaffection
GitHub : github.com/codaffection
Discord : / discord
Twitter : / codaffection
#AspNet #CodAffection

[@CodAffection]

goo.gl/RFY5C2 : Subscribe to CodAffection goo.gl/PnEc6c : User Sign Up Or Registration in Asp.Net goo.gl/oxDoDK : Asp.Net CRUD Operations goo.gl/UoNfs4 : Asp.Net Grid Inline CRUD

[@kevinrodrigues8809]

I've seen thousands of videos, and yours is the only one that helped me, thanks (google translate)

[@knit800]

Thank you for doing this. Great job, sir!

[@nidhikhare8331]

Thanks sir, aapne bahut hi simple taraikee se btaya .... Thanks for helping me

[@diablowizard457]

Exactly what I was looking for! Thank you so much!

[@CodAffection]

Glad you found the video helpful.

[@vitaliisharapov8866]

MAN!!! THANK YOU VERY MUCH!! This is just miracle!!! Could you please post more videos about ASP.NET Webforms?

[@marcoscabrera96]

Thanks bro!!! Great tutorial :D

[@ayrtonaranibar3622]

Muchas gracias papu, me ha servido muchisimo, mis respetos :3

[@Buzca]

I love your videos. Thank you!

[@danielortiz1347]

Thank you very much. Just what i'm looking for

[@lectiionline6907]

Thank you for your help and your explanations!

[@akshaygade5182]

awesome job sir,very helpful

[@mohammadyasin999]

thanks, i found this video very useful. nice and simple.

[@kammistry165]

Works! thanks! ... Other published methods on the net failed: employed disabling of anonymous users, but by doing so, login page was also not allowed on 2019 visual studio.

[@meryemer-raki4560]

Excellent ! thanks !

[@Miguel-gm9hx]

Thank you very much! You solved all the problems for my school project!!

[@CodAffection]

You are welcome.

[@BreadSTickist]

Yes me too

[@Roika_77]

Sir, may I ask if Session["username"] can be any name? Or is there id called username to use Session?

[@kennethbomholdt3433]

Thanks a lot, this was very helpful to me :-)

[@CodAffection]

I'm glad you fount the video helpful.

[@dylmatYT]

This was great help! Thank you :)

[@CodAffection]

you are welcome. let me know if you have any video suggestion regarding asp.net.

[@grumpymeercat]

Thank you very much!

[@canand6786]

Thanks, Very useful

[@sqwertysqwerty8988]

Thenk u! Thenk U! it worked now I can add more features

[@akshaygade5182]

what if i have to retrieve only certain database....like for Admin to redirect to another page??

[@Cr3x2p]

thanks you so much sir!

[@maryemtarhri1482]

your course is soooo helful ..... thank you so so much

[@CodAffection]

thanks for the support

[@NVAKAYAMINI]

Excellent work . It is very helpful for me

[@abhishekyadav-hn1gf]

Thanks a lot, successfully completed my page

[@user-wf9pq2ee1y]

Dear Sir, I follow the scenario and the web works properly. But, if I input the incorrect account which is not existed in the database, the login goes wrong. How to solve this symptom? (The "Authorize" Action should be modified! I guess.)

[@capitald9482]

keep going bro thx

[@Solly_Bopape_01]

Best coding channel🔥👌

[@cameron1988]

Great Tutorial!

[@CodAffection]

Thanks for the comment

[@kavitasharma-yr2gc]

Hi sir, plz guide why u type cast to execute scalar method

[@a.s.8113]

Very Helpful

[@gohilnayanaba4831]

sir your video is very helpful for me

[@HlawulaniMaluleke-lg6mw]

Thanks for video

[@omarnajmi6683]

Thank you very much

[@newjsan]

Well done. Thank you.

[@CodAffection]

Thanks man.

[@theresioleefland1737]

hey guys ive done everything just the same, but when i open my login page in google and fill in the credentials to login i get this error in my visual studio 2019 : System.ArgumentException: 'Invalid value for key 'integrated security'.' therefore i cant get trough the login page

[@ravikantha1]

Thank you very much.

[@deathhackers6183]

Great you help me so much

[@ingjb87]

Great our Job, What If I want to create a Connection Class and then call the Process in each page where I Need to Execute an SQL query?

[@olugbenrosamuel]

Thank you so much

[@aniketshetty2721]

Thank you soo much.. god bless

[@CodAffection]

Thank you.

[@happiestmeinworld]

Can u add a video like after login page...showing the user details.on that page we edit the details like that.

[@SardiusSriver]

Hi, thanks for your tutorial ! Do you have any videos about login modules with encrypt password ?

[@noyou2353]

Thank you sir ..helps alot for beginners

[@CodAffection]

you are welcome. let me know if you have any asp.net related topic suggestion for future videos.

[@shahidouahdi3814]

I have a quick question. so if I enter the url " .../Dashboard.aspx" directly in my navigator, it will still ask for a username and password ? or i would be able to access the page with no problemes ?

[@youtubefan899]

Thank you Sir

[@evantan6326]

How to export this SQL database to CSV? Can you do a tutorial of it?

[@mohsin6312]

Many many thanks for your amazing tutorial.

[@knowiz8071]

Watch other tutorials this is out dated and considered bad practice nowadays.

[@mohsin6312]

@@knowiz8071 I needed this for my University assignment.

[@faiqkhan5911]

package konsa selct kiya tha project create karteh watq

[@danielquek329]

Hi, for my project, it keep ahowing error and pointing to the sqlCon.Open(), any solution for me😭

[@yiush7868]

im trying to resolve the issue with this too.. its something to do with the data source..

[@sistemasfischer5958]

Great video

[@donamritpal]

A big Thanks

[@MultiToblo]

Best voice of the youtube!

[@CodAffection]

Thank you for the wonderful feedback! :) I'm humbled.

[@anusreev6732]

Thank you

[@mrsuiii2998]

Thank you.

[@wihandebeer1755]

LEGEND

[@BreadSTickist]

You helped me again. Thank you from my heart

[@CodAffection]

you are welcome.

[@dadasajad8741]

Thank you dear. very much helpful

[@CodAffection]

My pleasure 😊

[@bhauminpatel2662]

Great view

[@healthnspice1376]

i am getting an error like : " object reference not set to an instance of an object.'" near " lblErrorMessage.Visible = false; " help me with this

[@vashirasamaila6317]

Thank you so much.

[@knowiz8071]

Watch other tutorials this is out dated and considered bad practice nowadays.

[@yiush7868]

Hey i know this is a long-ago video but do you have a registration and forget password tutorial

[@NidhiSharma-pt5ze]

there is an error in int count = Convert.ToInt32(sqlCmd.ExecuteScalar());

[@jaynostulop2476]

Hello, need assistance on lblerrormessage.visible = false;. Why its still showing up even if it is on page load

[@somajahnavi7861]

I'm getting an error as invalid object name 'userDetails' in the execution time and at the line of int count=Convert.ToInt32(cmdExecuteScalar()); Can anyone please help.....

[@sametcesmebasi9568]

up

[@navjotsingh2457]

TY

[@rahibridoy6229]

boss you are the best

[@CodAffection]

thank you.

[@barenecessities5354]

Thank you for sharing this! Very informative. However I see that while using this query, the password can be CAPS or small letters, and it will still permit user login unless the database table tblUser has collation set to be case sensitive.

[@CodAffection]

Good point!

[@waseemsiddique9715]

Nice video bro but plz show output also after some steps it will help u understand... 👍

[@ravimeher6067]

I am getting error as System.InvalidOperationException: 'ExecuteScalar: Connection property has not been initialized.' plz help

[@BreadSTickist]

Try to add this line in top of Login.aspx.cs using System.Data.SqlClient;

[@arabindapatra5665]

I am getting an error message in lblUserDetails

[@andregomezmercado1183]

This videos s god-like!

[@CodAffection]

Glad you found the video helpful.

[@avocadomangos]

Thanks

[@Animated-Corporate-Videos]

Hi, How are bro? I have a question for you, I have VB.net windows form application with MYSQL database. Is it possible to connect Firebase Database instead of SQL server with VB.NET desktop application?

[@justboughtmarmalade628]

thats visual basic LOL

[@ishmaelkhattab4020]

T H A N K S ! ! !

[@davidmaceda5379]

excellent tutorial

[@CodAffection]

thank you :)

[@planetcamo5829]

Where do you get the @Data Source line from? (7:30 in the video)

[@CodAffection]

Answer is here : stackoverflow.com/a/4879175/4133590

[@acmevisit]

Nice

[@Amirajama]

I'm having problem in SQL part like...you didn't explain that part so well and I'm confuse af... how the table was ready and everything ?

[@mikestevens1718]

When I right-click - properties on the btnLogin and double-click the Click event, I do not get a Login.asps.c page to edit the code. I am getting a Login.aspx.vb page. What am I doing wrong? If I click on Design I see the page correctly. I am just not getting the right page to add the click event code.

[@CodAffection]

so you are working on VB.Net

[@mikestevens1718]

I am working (practice) on Asp.Net

[@andrewnleon]

Hi, do you have a method of encrypting the password or is your method secure enough?

[@syedwasay3087]

the method isnt secure for encryption use authentication and security classes they are a bit complex but most secure

[@andrewnleon]

@@syedwasay3087 i plan to use sha1 on submit login and register. this would be an accurate approach?

[@faruksmajlovic6773]

I used MD5 once worked like a charm, it is really easy to implement too.

[@andrewnleon]

@@faruksmajlovic6773 ty for your feedback

[@AnuragSharma-jx8df]

Hello if u could upload a similar video of login according to various roles then it would be a big help

[@CodAffection]

I'll see what I can do!

[@ahmedrashed5567]

thanks

[@CodAffection]

you are welcome.

[@abineshgopal1906]

int count = Convert.ToInt64(SqlCmd.ExecuteScalar()); this line error will be occur.how to modify line

[@CodAffection]

check you db connection string or try with break point.

[@abineshgopal1906]

CodAffection tq.

[@ahmedrashed5567]

I try to use sspi connection it works good on my machine but get this error on anthers machine in domain Server Error in '/' Application application error from being viewed remotely (for security reasons) I search a lot but get nothing hope ur help if u don't mind

[@CodAffection]

Check your DB Connection String.

[@ahmedrashed5567]

thanks so much for the reply - but DB connection string i guess it right coz it works well on my machine - db server is not my machine just website and iis on my machine -

[@CodAffection]

db is in another server machine right ?

[@ahmedrashed5567]

yes sir - we work on domain - theirs machine have db and my machine have website and there others

[@CodAffection]

can you connect server db from your local machine using ssms or visual studio?

[@darkclouds98]

HI bro, how do you hide the password? cuz your video shows the password

[@akshaygade5182]

i am having problem in {int count = Convert.ToInt32(sqlcmd.ExecuteScalar()); } showing No mapping exists from object type System.Web.UI.HtmlControls.HtmlInputPassword to a known managed provider native type. plz help

[@CodAffection]

particular stored procedure should return integer string

[@akshaygade5182]

done sir

[@omkarlele693]

Hi I am beginner and have NO knowledge of ASP.NET I viewed the video and followed the steps. However when clicked on login, got below error. Please help me here. Error: Server Error in '/' Application. ExecuteScalar requires an open and available Connection. The connection's current state is closed. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.InvalidOperationException: ExecuteScalar requires an open and available Connection. The connection's current state is closed. Source Error: Line 25: sqlcmd.Parameters.AddWithValue("@Username", txtUserName.Text.Trim()); Line 26: sqlcmd.Parameters.AddWithValue("@Password", txtPassword.Text.Trim()); Line 27: int count = Convert.ToInt32(sqlcmd.ExecuteScalar()); Line 28: if (count == 1) Line 29: { Source File: Q:\Prod\myproject\loginpage\loginpage\login.aspx.cs Line: 27 Stack Trace: [InvalidOperationException: ExecuteScalar requires an open and available Connection. The connection's current state is closed.] System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) +2378748 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +91 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +53 System.Data.SqlClient.SqlCommand.ExecuteScalar() +180 loginpage.WebForm1.btnlogin_Click(Object sender, EventArgs e) in Q:\Prod\myproject\loginpage\loginpage\login.aspx.cs:27 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +9659822 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +108 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +12 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +15 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +35 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1639 Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.6.81.0

[@CodAffection]

Please Check Your Sql Server Connection String

[@omkarlele693]

Sir, It is exactly same as provided by you. as below: using (SqlConnection SqlCon = new SqlConnection(@"Data Source=(local)sqle2012;initial catalog=LoginDB;integrated security=true;")) { string query = "SELECT COUNT(1) FROM People WHERE UserName=@username AND Password=@password"; SqlCommand sqlcmd = new SqlCommand(query, SqlCon); sqlcmd.Parameters.AddWithValue("@Username", txtUserName.Text.Trim()); sqlcmd.Parameters.AddWithValue("@Password", txtPassword.Text.Trim()); int count = Convert.ToInt32(sqlcmd.ExecuteScalar()); if (count == 1) { Session["Username"] = txtUserName.Text.Trim(); Response.Redirect("Dashboard.aspx"); } else { lblErrorMessage.Visible = true; } }

[@CodAffection]

Did you create the Sql Server DataBase LoginDB in Your System ?

[@omkarlele693]

yes SQLEXPRESS.LoginDB

[@CodAffection]

do you know the sql server instance name ?

[@default632]

YOUR NAME IS SHAMZU, DATABASE SERVER DONT LIE

[@CodAffection]

:)

[@default632]

@@CodAffection Happy day to you, I am so lucky to be noticed.

[@fahimehporbarzegary3325]

Thanks

[@foootyflickss]

TY