Very nice and detailed guide. Thanks a lot, Sir! :) Only one point as critics but its subjective... in my opinion it were too many fields so it sort of blurred the logic behind the commands. It's not too bad but especially people with short attention spans have issues following the whole line then. :) It would be better to use e.g. a simple "Username" and "Password" data set and explain how to expand it after explaining the core structure of it.
Hey bro, I loved your video, it really helped me, but I have some questions, I don't know if you could help me. Do you know how to limit the user from leaving blank spaces in the registration form? Make sure that the user fills in all the spaces for first name, last name, username, etc., so that there are no blank spaces in the database
For that you have to use the same database for login and registration! And for login use email and password field of registration database! The query is select * from registration where email =@email and password =@password
@@RunCodes Hey man! I have successfully been able to register and login using the same database as you stated here. However, having a direct connection to my sql server is pretty risky and i was wondering if you could make a video(or already have) on how to to setup an api within the project and how to implement the api connection on both the server side /database and our application!
@@RunCodes I am facing the same issue. it shows this error :System.Data.SqlClient.SqlException: 'Implicit conversion from data type nvarchar to varbinary is not allowed. Use the CONVERT function to run this query.'
Here you go! How to Create a Login Form in C#.NET using SQL Server Database and Visual Studio 2022? [Source Code] th-cam.com/video/JgdPrbgHVoE/w-d-xo.html
get an Error like : System.Data.SqlClient.SqlException : Incorrect syntax near @ Description' ,' cmd.Parameters.AddWithValue("@Phone", txtPhone.Text); cmd.Parameters.AddWithValue("@City", txtCity.Text); cmd.Parameters.AddWithValue("@Description", txtDescription.Text); cmd.ExecuteNonQuery();
thank you, sir you solve, my problem
Thanks
It was too useful. Many thanks to you
Very nice and detailed guide.
Thanks a lot, Sir! :)
Only one point as critics but its subjective... in my opinion it were too many fields so it sort of blurred the logic behind the commands. It's not too bad but especially people with short attention spans have issues following the whole line then. :)
It would be better to use e.g. a simple "Username" and "Password" data set and explain how to expand it after explaining the core structure of it.
Hey bro, I loved your video, it really helped me, but I have some questions, I don't know if you could help me. Do you know how to limit the user from leaving blank spaces in the registration form? Make sure that the user fills in all the spaces for first name, last name, username, etc., so that there are no blank spaces in the database
Watch video after 21:41, we already did that!
thank you teacher
How do you update the account registration to the login form? The loginapp database did not update after registering.
For that you have to use the same database for login and registration! And for login use email and password field of registration database! The query is select * from registration where email =@email and password =@password
@@RunCodes Hey man! I have successfully been able to register and login using the same database as you stated here. However, having a direct connection to my sql server is pretty risky and i was wondering if you could make a video(or already have) on how to to setup an api within the project and how to implement the api connection on both the server side /database and our application!
@itz_humble648 sorry sir we dont have such video
Sir i tried what ever you did from video. But I'm unable to store the data in database. It's not showing the popup also.
Check your code, the source code is in the description of video!
@@RunCodes I am facing the same issue. it shows this error :System.Data.SqlClient.SqlException: 'Implicit conversion from data type nvarchar to varbinary is not allowed. Use the CONVERT function to run this query.'
It means you choose binary data type while designing your database data type. Choose varchar datatype in your database schema while defining it!
If u use database directly in visual studio then just create table and update table
Right jawa brather ok thanks.
And what about the Login Button ?
Here you go! How to Create a Login Form in C#.NET using SQL Server Database and Visual Studio 2022? [Source Code]
th-cam.com/video/JgdPrbgHVoE/w-d-xo.html
And you can open login form as this.hide
LoginForm f1= new LoginForm()
f1.ShowDialog()
get an Error like : System.Data.SqlClient.SqlException : Incorrect syntax near @ Description' ,'
cmd.Parameters.AddWithValue("@Phone", txtPhone.Text);
cmd.Parameters.AddWithValue("@City", txtCity.Text);
cmd.Parameters.AddWithValue("@Description", txtDescription.Text);
cmd.ExecuteNonQuery();
Show me sql query!