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 🙂

[@jbosmadejesus]

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

[@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?

[@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

[@quangduy2812]

Thank you, your video is amazing ! 😀

[@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

[@dd0669]

AMAZING VID, THANKS!

[@tiagopimenta]

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

[@dreamy7617]

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

[@SilencePlaysRust]

FINALLY AFTER 5 MONTHS

[@CodeCraks]

Yeah😀

[@osbornekhonyongwa3112]

am thankfull for this video bigup my guy

[@iflookscouldsha]

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

[@ajdinnn]

very helpful video, thanks a lot :)

[@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

[@FultmanVR]

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

[@cinecastmedia]

Thank you very much

[@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?

[@singlebee3054]

Great video，very helpful！

[@hoanglinhngodoan364]

thank you so much it helps me so much

[@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

[@anthemslenses1016]

Thank you man for sharing this stuff

[@keralazap]

Bro you videos are so nice

[@CodeCraks]

Glad you like them!

[@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?

[@ayensNdlabi]

you lost me when you opened powerpoint

[@raoufsnowden2988]

What ? When ?

[@certifiedahole3417]

@@raoufsnowden2988thinnk he means access

[@mohammadiaa]

That's not PowerPoint

[@mohammadiaa]

Lol

[@parsaKh-un9vy]

too useful.. thanks🖤🖤

[@CodeCraks]

Welcome stay together with us

[@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.

[@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

[@vickiekamau4335]

thanks dude, really helped

[@hciheminf680]

Hi, great work.

[@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

[@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

[@bajikeisuke9395]

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

[@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"; }

[@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?

[@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?

[@George-et7vi]

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

[@homestudio1447]

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

[@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

[@funnix400]

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

[@tecnome8166]

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

[@beefjerkytheockyway]

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

[@Xnvyyyy]

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

[@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.

[@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 ?

[@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

[@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."

[@Rajeshkumar-wn4xc]

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

[@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

[@Lunar-rb9um]

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

[@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😅

[@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

[@Unkn0wn4rtist]

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

[@almoniaruela.8241]

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

[@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

[@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.

[@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

[@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

[@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.

[@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

[@xoxo1927]

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

[@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

[@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?

[@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

[@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.

[@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

[@HEYAA..]

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

[@Dayv3n]

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

[@itzame9428]

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

[@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" ?

[@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?

[@korpukkur]

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

[@suharajithsen2184]

welll link in the description does not work

[@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?

[@kumargourab9090]

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

[@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

[@KJ_GamingYTopG]

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

[@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

[@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

[@danhkevo5292]

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

[@kaiheuangmany1109]

what is dr.read() ?

[@papak05]

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

[@Smogi_5267]

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

[@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.

[@ProPro-li4mz]

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

[@mutayyab01]

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

[@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

[@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

[@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

[@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?

[@MuhammadAkbar-ju7yr]

i really appriciate your reply on my previous comment

[@gonnabe8861]

invalid sql statement when i try to register ??

[@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?

[@Clxqz]

why cant i create a account on your website

[@miksiuTTV]

Can you share files from Office Access?

[@Karaokeba]

I dont have cmd here

[@fatmabasar7404]

I wonder why I don't have a label click

[@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

[@BroBro-tb3fi]

I can't write OleDbConnection. Does anyone know why?

[@CodeCraks]

You must include "using System.Data.OleDb;" at the top of your codes.

[@i-d-k.1.2]

i get errors at 11:50