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
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
@@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
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
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
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
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?
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
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?
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?
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?
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
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
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 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.
Check out this guide social.msdn.microsoft.com/Forums/sqlserver/en-US/a91ff002-909c-4874-a352-52d4f0539305/microsoftjetoledb40?forum=windowsgeneraldevelopmentissues
@@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.
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.?
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.
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?
@@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🙏🏽!
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.
@@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
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."
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?
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
im getting System.ArgumentException: 'An OLEDB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'.' how do i fix this?
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?
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
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
@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 .
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
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
![How to Create a Login Form in C#.NET using SQL Server Database and Visual Studio 2022? [Source Code]](http://i.ytimg.com/vi/JgdPrbgHVoE/mqdefault.jpg)
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
how do i get a window form application in 2022 visual studio?
@@Vilemfn Windows Forms App(.NET Framework) or if inside project : "Right click" the project, then "Add" , then "Form(Windows Form)" .
Thank you, your videos are helpful for a 1st year BSIT student here.
Thank you. Happy to hear that 🙂
finally after 7 months, thank you so much! You can make when you have login or sign up it show you a blank form?
Fresher ah?
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
Please make a video c# with data base. Big thumbs up to your videos❤️
Sure thing👍🏻
♥️
@@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
Sorry I didn’t understand your concept could you explain me briefly
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
Did you recheck the code you coded. And if the problem continues try downloading our project file
@@CodeCraks System.InvalidOperationException: 'The connection was not closed. The connection's current state is open.'
@@CodeCraks Oh I fixed it, just add con.Close(); at the end of the line
Good to know
@@CodeCraks hi i just wondering this apk cant run on another device? So it must have the database too?
Where in the project files can i find the information used at 11:01?
Thank you, your video is amazing ! 😀
AMAZING VID, THANKS!
you lost me when you opened powerpoint
What ? When ?
@@raoufsnowden2988thinnk he means access
That's not PowerPoint
Lol
The beat dropped at 5:10 was 🔥🔥🔥
what's the name of the track?
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
I'm gald to hear that you are interested in our videos. How can i help you
The Database file will be at : (Project Folder)/(Project Name)/bin/debug
@@CodeCraks Hey do you have a discord?
am thankfull for this video bigup my guy
very helpful video, thanks a lot :)
After "SELECT", what is that dot? is it an asterik?
it is this one "*" I had the same trouble it has now worked
That's a very nice video. Congratulations 🎉
Pov: for DRY (Don't Repeat Yourself), some codes must be Functions 🤷
Nice video man !!! Very good !!! Tks !!!
Bro you videos are so nice
Glad you like them!
What should I do it says: 'The 'Microsoft.Jet.OLEDB.2.0' provider is not registered on the local machine.'
Hello I have a question, what if the user creates a new account with a username already used? By the way, good video!
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
@@CodeCraks ok, thanks
@@CodeCraks and how to do that exactly , can u explain it further or make another video about it
If(username == USERNAME)
{
Label.text = "username exist";
}
Thank you very much
FINALLY AFTER 5 MONTHS
Yeah😀
Great video，very helpful！
nvm i bought it it wasnt expensive that i thought keep up the great work sorry for being mean
thank you so much it helps me so much
Thank you man for sharing this stuff
"Microsoft.Jet.OLEDB.4.0' provider is not registerd on the machine", how to fix this error
I have a problem when registering and logging in. Can you help me?
Hi, great work.
What to do if we don't own the database/ Microsoft Database or whatever?
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?
It will. but this small programs want take much RAM so its not a matter
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
i have there problem man too is it the number of query values and destinations fields are not the same
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?
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?
Super long time ago but how did you fix this because I have the same issue now!
I Have The Same Error
@@ComeonVmware Install OLEdb driver
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?
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
8:45 I don't have that
you said you'd leave the database below
You download the project file you will find the database
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
Add con.Close() after the database connection code.
thanks dude, really helped
too useful.. thanks🖤🖤
Welcome stay together with us
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
Yeah Sure, we've got many suggestions about MySQL. We'll be uploading some related videos nearly.
@@CodeCraks I am very much looking forward to the release of the video about Mysql, thank you for what you are doing
Hi can someone help me with the running bit? How do I run it on my desktop?
Start using visual studio
@@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.
Check out this guide
social.msdn.microsoft.com/Forums/sqlserver/en-US/a91ff002-909c-4874-a352-52d4f0539305/microsoftjetoledb40?forum=windowsgeneraldevelopmentissues
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.
Are you trying to make poeple login from different computers or just in your own computer?
@@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.
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.
@@CodeCraks how do I do that?
First of all you must own a mysql server with remote mysql support and enough database storage.
Its a great video
but i need this registration for with SQLserver database
Great work !!.Can i create login and sign up win form without and database connection ? Please help me ?
sir how i want upload image for registration system.?
can you help me?
Hello i have a question.Is this going to work on any computer trough the internet?
No
@@CodeCraks is there any way to make a internet based login and registration system in c#?
Ya its possible
Hello, when i try to login to the created account it says that con.Open(); command isn't working
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.?
same happens to me
You must install OLEDB in your computer
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.
The credentials cannot be read in the database if you are using a password for the database.
@@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 ?
I don't have log in and register system folder help
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?
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.
Hello, don’t i need to run the database on a server?
How do you make the username and password on login case sensitive?
Hey can you make a video to c# Register with a Token?
token? how could it be?
@@CodeCraks like say a forget password form that will automatically generate tokens to users to recover their password
Forget password cant be easily made wil tokens if you want its possiable
@@CodeCraks please do a video on it
On forget password or with tokens
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?
Do you try our project file
@@CodeCraks no i do it with my own
@@CodeCraks never mind i have sorted it, great video!
Oh great
@@camjaykirkby3961 im having the same problem. what was the solution?
what is cmd in the code i didnt understood that thing it is like
cmd = new SqlCommand(login,con);
what is the cmd thing
could you maybe make a video on how to add a working "Remember me"
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
I don’t have the PasswordChar option what should I do please help 16:08
same here did you fix it?
@@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🙏🏽!
'The connection was not closed. The connection's current state is open.'
how i can fix this?
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?
its because he doesnt use con.Close(); after the if(dr.Read() == true) statement well thats what fixed it for me atleast
Good to know
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.
having a error at 16:08 with PasswordChar what should i do?
What kind of an error
@@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
U can make video login and register with sql sever.
Thanks
what is dr.read() ?
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."
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?
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.
Can you make a video how to allow duplicates on Microsoft Access 2007?
@codecraks not able to download sample files, please suggest.
Great video, new sub. I have question how do you modify your voice, is it a program or app?
No its a website
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 😁
Yeah sure i will send it
text-to-speech-demo.ng.bluemix.net here it is
Brother how can I display the table data in the dashboard please reply
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
Can you share files from Office Access?
im getting System.ArgumentException: 'An OLEDB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'.' how do i fix this?
is there a way to do this without office access cause i dont have 20$ to spend on it as of right now
Did you find another way?
bro i have not MS Access and how can i install it ?
Hi CodeCraks, Kindly assist. Im using visual studio 2022 and does not seem to have OleDbConnection. do you perhaps have a solution around this?
It should be there because that's used to connect the database
@@CodeCraks I cant seem to find it is there a way you might know to add that property
Hey I dont have OledBConnection in generel i dont have as much oledb settings as u can u help me maybe?
Make sure, that you have included this code at the top :-
using System.Data.OleDb;
@@CodeCraks i have but i still dont have it :(
@@CodeCraks it only shows permission and attribute
@@CodeCraks Maybe u can help me in discord for like 5 dollars quick im leigt helpless why i dont have oledbconnection
@@eliaszadrazil4425 yo did you ever figure it out? I'm having the same issue
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?
Ya, You can Go through the Project File.
If you need feature help contact me on Email
Did you solve it? I have the same problem
@@abrahamsaavedra5092 nope, still can’t solve it :(
@@benmoreton8114 Same..ain't happening , idk why
Hello thank you for the tutorial and i have question how can i check if that user is admin?
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
@@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.
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
@@CodeCraks how do i check?
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.
@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 .
BTW, Sorry For my bad English .
Sure we are trying our best to make the video more explained
Thanks for you feedback
@@CodeCraks how do i link it to "SQL" instead of "ACCESS" ?
welll link in the description does not work
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
Can you just mail me you questions i will help you there
@@CodeCraks Ok, i mailed you, thanks
@@sbmpubgmobile8800hello bro do you get the solution for it?
How i download source code
In description there is no link to download source code?
Hello, I've got this Error:
System.Data.OleDb.OleDbException: 'Syntax error (missing operator) in query expression 'Test','1234')'.'
Help?
how do i add this to an existing WPF i have so you have to login before accesing my other WPF
Your asking about Accessing a WPF Application using a WinForm
@@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
You can create a log using WPF instead
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.
You can’t anymore unfortunately
What if someone creates an account with the same password and username
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
Check if you'r textbox has properties name "txtUsername" ;)
invalid sql statement when i try to register ??
Is there a way I can do this but without access? It says it costs money.
To do what?
You don't need to pay, he has the file in the description where u can download!
Thank you @Axel that really helps!
How can i make a database to the panel?
Sorry I didn't get it, which panel?
source code nhi dikhra bro
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
same
i dont have nirmala ui wat an i do ?(i have vieusal studio 2019 proffesional)
In VS 2019 you cannot find WinForms so You have to get VS 2015
@@CodeCraks now i have visual studio 2015 but not nirmala ui do you know other fonts and size that it looks the same
If you follow my video you will get the same Ui As mine
I wonder why I don't have a label click
why cant i create a account on your website
What if I don't want to put a dashboard? What will i do instead? Please help 😭
You can go with you preference may be you can create a menu to navigate the user in the application
i really appriciate your reply on my previous comment