How to Create Complete Login and Registration System (Multiple Accounts) in C# 2020 | C# Tutorial

[@epicmusichunter5457]

for fellow programmers who needed time stamps here... Video Section: 0:00 introduction 0:17 Final Output & Demonstration 1:19 Registration Form UI Designing 7:18 Login Form UI Designing 8:42 Database Designing 10:30 Common Basic Coding 11:40 Registration Form Coding 15:49 Other Registration Form Codings 18:34 Login Form Coding 21:21 Other Login Form Codings 22:33 Outro

[@XolitoFN]

how do i get a window form application in 2022 visual studio?

[@lostsoul9147]

@@XolitoFN Windows Forms App(.NET Framework) or if inside project : "Right click" the project, then "Add" , then "Form(Windows Form)" .

[@eversobinsky7202]

Thank you, your videos are helpful for a 1st year BSIT student here.

[@CodeCraks]

Thank you. Happy to hear that 🙂

[@dreamy7617]

What should I do it says: 'The 'Microsoft.Jet.OLEDB.2.0' provider is not registered on the local machine.'

[@George-et7vi]

Where in the project files can i find the information used at 11:01?

[@standardminecraftplayer]

legit vid anyways i got this error: System.InvalidOperationException: 'The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.' Can you help?

[@morningaga]

Great , but only one thing missing , is that if I want in the sign up page , to show the username already exists validation , in case the username is taken

[@federicogames8431]

finally after 7 months, thank you so much! You can make when you have login or sign up it show you a blank form?

[@prabhakarant542]

Fresher ah?

[@VoidProduction-uk1]

Hi CodeCraks, Kindly assist. Im using visual studio 2022 it all works except the cmd.ExecuteNonQuery I was wondering if your could tell me how to fix this because i couldn't find a solution

[@urosigic2072]

i have there problem man too is it the number of query values and destinations fields are not the same

[@iflookscouldsha]

"Microsoft.Jet.OLEDB.4.0' provider is not registerd on the machine", how to fix this error

[@Lunar-rb9um]

Hello, I've got this Error: System.Data.OleDb.OleDbException: 'Syntax error (missing operator) in query expression 'Test','1234')'.' Help?

[@obitouchiha-uy5qt]

please help when I log in it says con.Open(): Exception Unhandled System.InvalidOperationException:'THe connection was not closed.The connection's current state is open

[@CodeCraks]

Add con.Close() after the database connection code.

[@peri.platypus]

Please make a video c# with data base. Big thumbs up to your videos❤️

[@CodeCraks]

Sure thing👍🏻

[@bryanmacacian2884]

♥️

[@theboss4006]

@@CodeCraks hey how do i connect the users data for dashboard. When a new user signs up and open dashboard, that user still sees the previous user's data

[@CodeCraks]

Sorry I didn’t understand your concept could you explain me briefly

[@matthewm4320]

Hello, I got everything to run but when I try to login or register an account it says "Microsoft.Jet.OLEDB.4.0' provider is not registerd on the machine" what can I do to fix this?

[@CaitlinSWAN]

Super long time ago but how did you fix this because I have the same issue now!

[@ComeonVmware]

I Have The Same Error

[@GOBANANAS8214]

@@ComeonVmware Install OLEdb driver

[@Unkn0wn4rtist]

The beat dropped at 5:10 was 🔥🔥🔥 what's the name of the track?

[@coverscollection8775]

Hi I have a problem, I tried the incorrect login and click submit and works, but if I try to click again its just error. So the problem is I cant login with incorrect data twice

[@CodeCraks]

Did you recheck the code you coded. And if the problem continues try downloading our project file

[@coverscollection8775]

@@CodeCraks System.InvalidOperationException: 'The connection was not closed. The connection's current state is open.'

[@coverscollection8775]

@@CodeCraks Oh I fixed it, just add con.Close(); at the end of the line

[@CodeCraks]

Good to know

[@coverscollection8775]

@@CodeCraks hi i just wondering this apk cant run on another device? So it must have the database too?

[@Kirkkis77]

im getting System.ArgumentException: 'An OLEDB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'.' how do i fix this?

[@dsfdhssgdfgsr8798]

Hey I downloaded your source but I have an issue. Whenever you try to create an account that has already been created it gives an error message. Do you know how to fix it?

[@CodeCraks]

Ya this is because access databases don't let to create duplicate values so this is impossible. But you came change the databases fields properties to allow duplicate value. This solves you issue

[@quangduy2812]

Thank you, your video is amazing ! 😀

[@SharpCheddaChesse]

Im just getting the error after trying to register an "account" Unrecognized database format but i've tried other formats like accdb and odb but it just says the same thing

[@spiridonlitsios1216]

Hi You do Great JOb here.!! Well done.! But i Have a problem with OleDbConnection.. it show an error CS1069 : The type name 'OleDbConnection' could not be found in the name space 'System.Data.OleDb'. Can you help me about that.?

[@imane1525]

same happens to me

[@CodeCraks]

You must install OLEDB in your computer

[@jbosmadejesus]

That's a very nice video. Congratulations 🎉 Pov: for DRY (Don't Repeat Yourself), some codes must be Functions 🤷

[@DJone4one]

Thank you. But i have a little problem. I have a database and have connected she with the form correctly but i have little bit more table columns inside the table Users. how i can work with lower Inputs in a table, if i get the error: "The index, based on 0 (zero), must be greater than or equal to zero, and less than the size of the argument list."

[@tecnome8166]

Great work !!.Can i create login and sign up win form without and database connection ? Please help me ?

[@franciscolameirao6808]

Hello I have a question, what if the user creates a new account with a username already used? By the way, good video!

[@CodeCraks]

For that you can have two solutions 1. Add a Try, Catch to the Code so the program can alert the user that it is a duplicate record. 2. You can change Allow Duplicates in the database

[@franciscolameirao6808]

@@CodeCraks ok, thanks

[@aleksavasiljevic2567]

@@CodeCraks and how to do that exactly , can u explain it further or make another video about it

[@masoodhassan5702]

If(username == USERNAME) { Label.text = "username exist"; }

[@dd0669]

AMAZING VID, THANKS!

[@gangganoch]

Sorry, when you created this project, you used a database from Microsoft Access software. If you use SQL Server Management Studio software, will the results still be the same? Coincidentally, I also tried using SQL Server and the result was an error😅

[@Exyo]

Hello! I Have A Problem, In Minute 19:23 It Says To Type Within The Code txtUsername, But It Doesn't Allow It And Errors It

[@AlaSwekProductions]

Check if you'r textbox has properties name "txtUsername" ;)

[@Xnvyyyy]

Hello, when i try to login to the created account it says that con.Open(); command isn't working

[@beefjerkytheockyway]

What to do if we don't own the database/ Microsoft Database or whatever?

[@osbornekhonyongwa3112]

am thankfull for this video bigup my guy

[@kanefbo]

After "SELECT", what is that dot? is it an asterik?

[@malola5499]

it is this one "*" I had the same trouble it has now worked

[@benmoreton8114]

I’ve got to the part where I close down access and go back into VS. I type in using.system.data.oleDb But when I type oleDb into the public frmregister, I only have two options for oleDb that aren’t oleDbconnection Any help please?

[@CodeCraks]

Ya, You can Go through the Project File. If you need feature help contact me on Email

[@abrahamsaavedra5092]

Did you solve it? I have the same problem

[@benmoreton8114]

@@abrahamsaavedra5092 nope, still can’t solve it :(

[@UnzeelaImran]

@@benmoreton8114 Same..ain't happening , idk why

[@ayensNdlabi]

you lost me when you opened powerpoint

[@raoufsnowden2988]

What ? When ?

[@certifiedahole3417]

@@raoufsnowden2988thinnk he means access

[@mohammadiaa]

That's not PowerPoint

[@mohammadiaa]

Lol

[@FultmanVR]

nvm i bought it it wasnt expensive that i thought keep up the great work sorry for being mean

[@trixynix7806]

Can I ask for help I have a problem in registering the error say pass does not match even when I type the password correctly.

[@mhlaing11]

I can't type the wrong password or username twice.The error show at con.Open().Can you please tell me the way to make that right?

[@cookieskush]

its because he doesnt use con.Close(); after the if(dr.Read() == true) statement well thats what fixed it for me atleast

[@CodeCraks]

Good to know

[@ajdinnn]

very helpful video, thanks a lot :)

[@Dayv3n]

@CodeCraks I keep getting a error System.InvalidOperationException: 'Invalid attempt to call Read when reader is closed.'

[@camjaykirkby3961]

another great video, but im facing a problem. Even if i put the correct Username and password into the login form it shows the incorrect user and pass, Do you know how to fix this?

[@CodeCraks]

Do you try our project file

[@camjaykirkby3961]

@@CodeCraks no i do it with my own

[@camjaykirkby3961]

@@CodeCraks never mind i have sorted it, great video!

[@CodeCraks]

Oh great

[@thaneshsanganesan9366]

@@camjaykirkby3961 im having the same problem. what was the solution?

[@ghadaalabbasi9814]

I don’t have the PasswordChar option what should I do please help 16:08

[@lawsonstevens4127]

same here did you fix it?

[@ghadaalabbasi9814]

@@lawsonstevens4127 Yes it turned out I was selecting a label instead of a textbox, I mean I named the label instead so I change that and it worked just fine. but actually the program didn’t work I had another issue so if it works with you I’d really appreciate your help🙏🏽!

[@FultmanVR]

the thing is others wont be able to log on the other accounts cuz it doesnt have it saved on a server or smth its only on database

[@almoniaruela.8241]

'The connection was not closed. The connection's current state is open.' how i can fix this?

[@MrJasonDEX]

Hey,im wondering where the database file is? im kinda new to this and this is better than collage as im meant of done this before but watching you is alot more simple lol

[@CodeCraks]

I'm gald to hear that you are interested in our videos. How can i help you

[@CodeCraks]

The Database file will be at : (Project Folder)/(Project Name)/bin/debug

[@MrJasonDEX]

@@CodeCraks Hey do you have a discord?

[@henrycovich]

Can I create another database linked to the first so when I login with a user I see the data stored in the second database of that user?

[@WKCyberCenter]

Hi CodeCraks, Kindly assist. Im using visual studio 2022 and does not seem to have OleDbConnection. do you perhaps have a solution around this?

[@CodeCraks]

It should be there because that's used to connect the database

[@WKCyberCenter]

@@CodeCraks I cant seem to find it is there a way you might know to add that property

[@MuhammadAkbar-ju7yr]

what is cmd in the code i didnt understood that thing it is like cmd = new SqlCommand(login,con); what is the cmd thing

[@aprildev1]

Hello i have a question.Is this going to work on any computer trough the internet?

[@CodeCraks]

No

[@aprildev1]

@@CodeCraks is there any way to make a internet based login and registration system in c#?

[@CodeCraks]

Ya its possible

[@tiagopimenta]

Nice video man !!! Very good !!! Tks !!!

[@HEYAA..]

Its a great video but i need this registration for with SQLserver database

[@csicee]

8:45 I don't have that you said you'd leave the database below

[@CodeCraks]

You download the project file you will find the database

[@lawsonstevens4127]

having a error at 16:08 with PasswordChar what should i do?

[@CodeCraks]

What kind of an error

[@lawsonstevens4127]

@@CodeCraks it’s fixed now and I’m done with every but now when I create a account I have to hit it 2 times for it to say created and also only the user name goes to the data base not the password

[@Jaypft]

Question, I wana make it too where Different people can Log in. But I dont want them to be able too see other peoples login info how do I do that.

[@CodeCraks]

Are you trying to make poeple login from different computers or just in your own computer?

[@Jaypft]

@@CodeCraks from different computers , like im making a multi tool , that has a login. I have the database and everything but i wana be able to share the database around with the tool working but people not being able too see other peoples login.

[@CodeCraks]

Then you must change the database from access to remote mysql, by then you can login from any computers remotely. But it needs an internet connection.

[@Jaypft]

@@CodeCraks how do I do that?

[@CodeCraks]

First of all you must own a mysql server with remote mysql support and enough database storage.

[@BossBYT]

It is possible to create an account on a website and then use that account to purchase a program on that page. I would later download the program from the site and would have to log in program with the same information as I logged in on the website. I would also like to make it possible for only one device to be logged into an account at the same time. Is that possible?

[@ayoziddy]

So you want to sell a program but u want them to reigster on website and the after they register website they can login on the application and use it.

[@planeman4453]

Nice video, one question though. When your opening each form, you are creating a new object, and once your done with it you just hide it. If you keep hitting the register account, will that not leave a lot of forms hidden in the background instead of closed?

[@CodeCraks]

It will. but this small programs want take much RAM so its not a matter

[@homestudio1447]

sir how i want upload image for registration system.? can you help me?

[@bajikeisuke9395]

I don't have log in and register system folder help

[@kanelanecaiphus5951]

@Codecraks please I need help I keep getting the same error...The name 'cmd' does not exist in the current content and The name 'con' does not exist in the current content.....#Please help me

[@Rajeshkumar-wn4xc]

@codecraks not able to download sample files, please suggest.

[@singlebee3054]

Great video，very helpful！

[@sbmpubgmobile8800]

Hello, i have a question, how to connect each unique own information per account, for example, my account has info about space, if you login with your account it will have another info about war? If you did video about that, can you send a link please, or just try to explain, it will be helpful for me, thanks

[@CodeCraks]

Can you just mail me you questions i will help you there

[@sbmpubgmobile8800]

@@CodeCraks Ok, i mailed you, thanks

[@Mr_NoobPlay]

@@sbmpubgmobile8800hello bro do you get the solution for it?

[@itzame9428]

How do you make the username and password on login case sensitive?

[@anthemslenses1016]

Thank you man for sharing this stuff

[@raincoplayz413]

When I register it comes back in register code line 42 cmd.ExecuteNonQuery(); the error said when I click on register button there is a syntax error but there are no errors and I did exact the same as you did

[@VoidProduction-uk1]

same

[@PankajNegi007]

Thanks for making very informative and knowledgeable video. Sir I follow all step as per your video now i want to say if i create duplicate username it show error now i want to do that its show me 'message username already exists Try Another Username.' how to fix its sir.

[@keralazap]

Bro you videos are so nice

[@CodeCraks]

Glad you like them!

[@eliaszadrazil4425]

Hey I dont have OledBConnection in generel i dont have as much oledb settings as u can u help me maybe?

[@CodeCraks]

Make sure, that you have included this code at the top :- using System.Data.OleDb;

[@eliaszadrazil4425]

@@CodeCraks i have but i still dont have it :(

[@eliaszadrazil4425]

@@CodeCraks it only shows permission and attribute

[@eliaszadrazil4425]

@@CodeCraks Maybe u can help me in discord for like 5 dollars quick im leigt helpless why i dont have oledbconnection

[@PRICEX]

@@eliaszadrazil4425 yo did you ever figure it out? I'm having the same issue

[@na-sha-ru]

Please do a lesson on authorization through mysql, I ask you very much, I am learning and I can not normally find a video how to do authorization through a mysql database

[@CodeCraks]

Yeah Sure, we've got many suggestions about MySQL. We'll be uploading some related videos nearly.

[@na-sha-ru]

@@CodeCraks I am very much looking forward to the release of the video about Mysql, thank you for what you are doing

[@funnix400]

I have a problem when registering and logging in. Can you help me?

[@hciheminf680]

Hi, great work.

[@andrei.s7171]

Hi, great work. Maybe you can update your code with " How to login to a secure/password protected access database". The login is useles because everyone can read the user and password directly from the db and log in after that.

[@CodeCraks]

The credentials cannot be read in the database if you are using a password for the database.

[@andrei.s7171]

@@CodeCraks Do you have an idea how to do something like this? To get some information (Excel, Access, mysql, etc) that is protected to a c# form ?

[@YP_1]

Hi can someone help me with the running bit? How do I run it on my desktop?

[@CodeCraks]

Start using visual studio

[@YP_1]

@@CodeCraks ok yeah I didn’t know what I was talking about then. I already did the entire thing in visual studio. My problem is “Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.” After I enter credentials it just fails and displays that.

[@CodeCraks]

Check out this guide social.msdn.microsoft.com/Forums/sqlserver/en-US/a91ff002-909c-4874-a352-52d4f0539305/microsoftjetoledb40?forum=windowsgeneraldevelopmentissues

[@juliuscarino8497]

An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'.' how to fix this bro

[@juliuscarino8497]

i already fix it thankyouuuu btw not skipping the ads

[@CodeCraks]

Thank you, Feel free to ask any questions, we can make a video on that?

[@juliuscarino8497]

ow shiittt you notice me my heart!!🥺

[@akashdubey2849]

getting same error how did u fixed this bro?

[@bReAd-tHe-fIrSt]

How do I download the files? I created an account but it wont log me in. I see the files but no place to download the file.

[@SKIWRLDWIDE]

You can’t anymore unfortunately

[@parsaKh-un9vy]

too useful.. thanks🖤🖤

[@CodeCraks]

Welcome stay together with us

[@xoxo1927]

Hello, don’t i need to run the database on a server?

[@lostsoul9147]

@CodeCraks sorry, but can you make a video explaining every step .. because i'ven't understood what most of the methods do or used for if not all .. i want to understand so in the future if i want to make something similar on my own .. Sorry if i'm asking for too much .

[@lostsoul9147]

BTW, Sorry For my bad English .

[@CodeCraks]

Sure we are trying our best to make the video more explained Thanks for you feedback

[@lostsoul9147]

@@CodeCraks how do i link it to "SQL" instead of "ACCESS" ?

[@oliq8122]

Hello thank you for the tutorial and i have question how can i check if that user is admin?

[@CodeCraks]

You can create a separate database table field for admin and user so the a admin is login can can give all access and if a user login you can limit access

[@oliq8122]

@@CodeCraks But how do i check if that user is admin i dont know how to get value from ms acces value: isAdmin- yes/no please help.

[@CodeCraks]

Ya you should make a separate field for a user type then when you create a account keep a field to select whether user type check when the application start where its a admin or not then if it is a admin login give access to admin and if it is a user login don’t display those features

[@oliq8122]

@@CodeCraks how do i check?

[@okokokr6096]

Yea i have that same problem how can i get like value from field like Yes/no to bool or string in c# please help.

[@papak05]

Can you make a video how to allow duplicates on Microsoft Access 2007?

[@memeicon2395]

is there a way to do this without office access cause i dont have 20$ to spend on it as of right now

[@matthewm4320]

Did you find another way?

[@i-d-k.1.2]

i get errors at 11:50

[@danhkevo5292]

U can make video login and register with sql sever. Thanks

[@AdeebTechLab]

not working System.Data.OleDb.OleDbException: 'Could not find output table 'tbl_users'.'

[@meme-y6z]

same here ?

[@hoanglinhngodoan364]

thank you so much it helps me so much

[@Trentoscroft]

how do i add this to an existing WPF i have so you have to login before accesing my other WPF

[@CodeCraks]

Your asking about Accessing a WPF Application using a WinForm

[@Trentoscroft]

@@CodeCraks so basically I made a WPF but before someone can access it it want them to login first so I how go I add this login to my excising WPF

[@CodeCraks]

You can create a log using WPF instead

[@vickiekamau4335]

thanks dude, really helped

[@jp-world3366]

Great video, new sub. I have question how do you modify your voice, is it a program or app?

[@CodeCraks]

No its a website

[@jp-world3366]

Ohh I see, I have to do a video for school, but I dont want my real voice in it, I'd really apreciate if you give the name of the page or a link 😁

[@CodeCraks]

Yeah sure i will send it

[@CodeCraks]

text-to-speech-demo.ng.bluemix.net here it is

[@stralex1992]

when I click the signup or log in an error pops up saying "could not find output table table tbl_users"

[@CodeCraks]

Check your table's name in your database. Maybe a spelling mistake in the database table or in the program code.

[@stralex1992]

@@CodeCraks so I just found the problem and I don't know how to fix it, can you help me please (sorry if I'm annoying) the error says: Error Could not copy "obj\Debug\Craft Limited.exe" to "bin\Debug\Craft Limited.exe". Exceeded retry count of 10. Failed. The file is locked by: "Craft Limited (17008)" Craft Limited

[@CodeCraks]

Download Our Project files and use our database. So this error will disappear

[@ProPro-li4mz]

Brother how can I display the table data in the dashboard please reply

[@cinecastmedia]

Thank you very much

[@korpukkur]

could you maybe make a video on how to add a working "Remember me"

[@stefffanyanne2114]

What if I don't want to put a dashboard? What will i do instead? Please help 😭

[@CodeCraks]

You can go with you preference may be you can create a menu to navigate the user in the application

[@isuq1980]

i dont have nirmala ui wat an i do ?(i have vieusal studio 2019 proffesional)

[@CodeCraks]

In VS 2019 you cannot find WinForms so You have to get VS 2015

[@isuq1980]

@@CodeCraks now i have visual studio 2015 but not nirmala ui do you know other fonts and size that it looks the same

[@CodeCraks]

If you follow my video you will get the same Ui As mine

[@suharajithsen2184]

welll link in the description does not work

[@mutayyab01]

How i download source code In description there is no link to download source code?

[@keralazap]

Hey can you make a video to c# Register with a Token?

[@CodeCraks]

token? how could it be?

[@sweTutorials0]

@@CodeCraks like say a forget password form that will automatically generate tokens to users to recover their password

[@CodeCraks]

Forget password cant be easily made wil tokens if you want its possiable

[@sweTutorials0]

@@CodeCraks please do a video on it

[@CodeCraks]

On forget password or with tokens

[@Smogi_5267]

What if someone creates an account with the same password and username

[@vincentcolasi9631]

I get this error saying "System.Data.OleDb.OleDbException: 'The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.'" whenever I tap register button twice to check the if it pops message box containing warning message

[@CodeCraks]

When you press the button twice, the same data gets added twice. Which will eventually produce a duplicate primary key error.

[@vincentcolasi9631]

@@CodeCraks owwwww that's it thank you so much

[@kumargourab9090]

bro i have not MS Access and how can i install it ?

[@gonnabe8861]

invalid sql statement when i try to register ??

[@hotsoda46]

Is there a way I can do this but without access? It says it costs money.

[@CodeCraks]

To do what?

[@Axel-wi2hw]

You don't need to pay, he has the file in the description where u can download!

[@hotsoda46]

Thank you @Axel that really helps!