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
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 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
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?
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
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.
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
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
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.
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.?
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?
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."
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
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
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?
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 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 .
@@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.
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 getting System.ArgumentException: 'An OLEDB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'.' how do i fix this?
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
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?
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
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
@@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
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😅
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
@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
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?
@@XolitoFN 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
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?
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
That's a very nice video. Congratulations 🎉
Pov: for DRY (Don't Repeat Yourself), some codes must be Functions 🤷
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
Great work !!.Can i create login and sign up win form without and database connection ? Please help me ?
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";
}
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.
Where in the project files can i find the information used at 11:01?
Thank you, your video is amazing ! 😀
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 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?
am thankfull for this video bigup my guy
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 ?
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
Its a great video
but i need this registration for with SQLserver database
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?
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."
nvm i bought it it wasnt expensive that i thought keep up the great work sorry for being mean
"Microsoft.Jet.OLEDB.4.0' provider is not registerd on the machine", how to fix this error
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
What should I do it says: 'The 'Microsoft.Jet.OLEDB.2.0' provider is not registered on the local machine.'
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
AMAZING VID, THANKS!
Can you make a video how to allow duplicates on Microsoft Access 2007?
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?
very helpful video, thanks a lot :)
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
you lost me when you opened powerpoint
What ? When ?
@@raoufsnowden2988thinnk he means access
That's not PowerPoint
Lol
What to do if we don't own the database/ Microsoft Database or whatever?
After "SELECT", what is that dot? is it an asterik?
it is this one "*" I had the same trouble it has now worked
The beat dropped at 5:10 was 🔥🔥🔥
what's the name of the track?
Bro you videos are so nice
Glad you like them!
Hi, great work.
Nice video man !!! Very good !!! Tks !!!
Thank you very much
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?
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.
sir how i want upload image for registration system.?
can you help me?
U can make video login and register with sql sever.
Thanks
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
Great video，very helpful！
@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" ?
How do you make the username and password on login case sensitive?
FINALLY AFTER 5 MONTHS
Yeah😀
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
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.
thank you so much it helps me so much
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.
Thank you man for sharing this stuff
too useful.. thanks🖤🖤
Welcome stay together with us
im getting System.ArgumentException: 'An OLEDB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'.' how do i fix this?
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
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.
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
could you maybe make a video on how to add a working "Remember me"
Brother how can I display the table data in the dashboard please reply
I don't have log in and register system folder help
thanks dude, really helped
Hello, don’t i need to run the database on a server?
Hello, when i try to login to the created account it says that con.Open(); command isn't working
I have a problem when registering and logging in. Can you help me?
'The connection was not closed. The connection's current state is open.'
how i can 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?
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
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, 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?
what is cmd in the code i didnt understood that thing it is like
cmd = new SqlCommand(login,con);
what is the cmd thing
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
Can you share files from Office Access?
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
@codecraks not able to download sample files, please suggest.
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
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
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😅
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
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?
Hello, I've got this Error:
System.Data.OleDb.OleDbException: 'Syntax error (missing operator) in query expression 'Test','1234')'.'
Help?
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
How i download source code
In description there is no link to download source code?
what is dr.read() ?
i really appriciate your reply on my previous comment
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
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
bro i have not MS Access and how can i install it ?
An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'.' how to fix this bro
i already fix it thankyouuuu btw not skipping the ads
Thank you, Feel free to ask any questions, we can make a video on that?
ow shiittt you notice me my heart!!🥺
getting same error how did u fixed this bro?
welll link in the description does not work
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
@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
why cant i create a account on your website
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
invalid sql statement when i try to register ??
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
were is the dowload
drive.google.com/file/d/1_f_h2_eompGDH-BcIvI8NFJOji3KeE9v/view?usp=sharing
I wonder why I don't have a label click
hi bro, can you suggest to me about forgot the password?
Ya sure
How can i make a database to the panel?
Sorry I didn't get it, which panel?
not working
System.Data.OleDb.OleDbException: 'Could not find output table 'tbl_users'.'
same here ?