goo.gl/RFY5C2 : Subscribe to CodAffection goo.gl/SUi4bg : Login Window in C# Using SQL Server goo.gl/zV892S : C# CRUD Operations With SQL Server goo.gl/NhNQeZ : Export Excel in C# Applications :
Who has an error with ALTER, so, Just don't change. Leave as it was (CREATE). In new versions of visual studio Alter doesn't work this is all done automatically.
That's nice , i like but what if i want to add a sign in windows to this registration system ? ( i mean related to it and db ) how to do that ? could you please teach us ?
EN-Select the data in the Server Explorer or right click on it and select Properties. In the Properties Window, the Connection String property to your database appears. SP-Seleccionas la de datos en el Explorador de Servidores o click derecho sobre ella y seleccionas Propiedades. En la Ventana de Propiedades aparece la propiedad Cadena de Conexión a su base de datos.
need urgent help as need this done for a university deadline 17th april 11:30pm how to i fix this issue sqlCon.Open(); and the lines below are generating a instance failure error, but i cant see how to fix it please help
@@bobmichell4088 in the end yeah, but i had to rely on C++ as the arrays were giving me trouble and connecting to my database was easier that way Looking forward to future videos on this channel
Hello! So thanks for your video. You did it very well but I have a problem. When I'm starting programme It's writing: System.Data.SqlClient.SqlException: 'Procedure or function 'UserAdd' expects parameter '@Id', which was not supplied If you answer I'll be happy!
I have a questions after i have done doing those whole registration sign up from where is that next management trio you are saying? Is that another application or i remain in c#? Please answer the question thanks
Thank you once again for the lesson. I do have one issue in my program. How can I autofill the Primary and foreign keys in the registration form? I have the customer data going to the customer table and the user name and password going to the user login table. The Customer table is Customer_ID (Primary key), User_ID( Foreign key User Login table has User_ID (Primary key) Everything worked except I did not fill the ID columns on both tables and got a null error for the key columns Any suggestions?
when i wanna see my data base with "Select * from UserAdd" + Execute in SQL i get "Msg 208, Level 16, State 3, Line 12 Invalid object name 'UserAdd'." after you removed UserID and changed 'create' to 'Alter' any ideas why?
Login form would verify username/password is in the user table in a database, and register form would add a new user to the user table in the same database. Unless they are for two different systems, they would be associated with the same table in the same database.
I am getting an error saying something along the lines of "Incorrect syntax near the word Table" in my query string. It did not let me name the table so it kept it as Table instead of tbl_Login
Thank you for your help. When I try to run the app, there's an error for @name_item in the line: sqlCmd.Parameters.AddWithValue(@name_item, stichwortTB.Text.Trim()); It says "the name 'name_item' doesn't exist in this context. It is however the parameter I used in the sql procedure. What can I do about it? Thank you for your help.
I created the form on visual studio 2017, but I've never worked with Microsoft SQL sever management studio 17 and when I open the program, it asks me for a server type, server name and authentication.....Can you please help me?
I use the process as you show in your video. but my User registration is not working. I think its because my sql server is not windows authentication its SQL server authentication. please help what should i do in that case?
Thanks for this video...Can u make ...one .net web page and show database connectivity using C# only.....and perform operation in database with sql server
Hey! Could you please help me out? When trying to set parameters in sqlcmd.Parameters.AddWithValue("@FirstName",txtFirstName.Text.Trim()); I get an error that says txtFirstName does not exist in the current context. How can I solve this? I would appreciate help from anyone!
make sure your writing this in code behind code of the same form where we have the first name text box. or you can download the demo source code from the download link and compare with yours.
ive tried your code but the thing here is that. The password textbox cant read varchar password. so can you tell me what can i do about it. it always displays nvarchar can not be converted to int
learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16 select the same version as that of your sql server from left top menu. ( > SQL Server > ...)
Sorry for the late reply, You can warm user about duplicate user name inside btnSubmit Button Click Event 1) Create StoredProcedure : CheckDuplicateUsername Input : username Output : 0 - No Duplicate 1 - Duplicate Found 2) Call the StoredProcedure before saving the record - if result 1 show 'duplicate username' in a message box.
1) Create a storeprocedure : CheckDuplicateUsername CREATE PROC CheckDuplicateUsername @UserName VARCHAR(100) AS IF EXISTS (SELECT * FROM tblUser where FirstName+' '+LastName = @UserName) SELECT 1 ELSE SELECT 0 2) Call this storeprocedure before save operation Pass FirstName+' +LastName to @UserName Parameter If it return 1 then there is a duplicate record - show warning message.
![How to Create User Registration Form in C#.NET Using SQL Server Database? [With Source Code]](http://i.ytimg.com/vi/VT76ruswmHo/mqdefault.jpg)
![How to Create User Registration Form in C#.NET Using SQL Server Database? [With Source Code]](/img/tr.png)
goo.gl/RFY5C2 : Subscribe to CodAffection
goo.gl/SUi4bg : Login Window in C# Using SQL Server
goo.gl/zV892S : C# CRUD Operations With SQL Server
goo.gl/NhNQeZ : Export Excel in C# Applications
:
I followed through and this video helped loads, thank you.
VERY USEFUL VIDEO EVEN IN 2020, Thanks!
Great job. Very easy to understand. Keep up the good work Sir!
OMG, you really helped me, thanks!😉
Thanks for Your kind efforts. It's easily understandable as i am a new learner. God Bless You.
Glad to hear that
thank you.. for the video have a good day.. brother.
Thank you very much. I used This instruction to Create WPf form.
Verry nice video!! Thanks a lot
Great teaching.. Thanks
best teaching method i like it very much please share more videos with simple and easy way us
thanks for your wonderful feedback.
may god bless you, you are the better one!!
thanks for your wonderful feedback.
Who has an error with ALTER, so, Just don't change. Leave as it was (CREATE). In new versions of visual studio Alter doesn't work this is all done automatically.
yea i have this problem too...
its wonderful, thanks very very much
Any suggestion on what to do if u dont want to have the possiblite to add accounts with same Username ?
ERROR Found:
System.Data.SqlClient.SqlException: 'Procedure or function 'addreg' expects parameter '@id', which was not supplied.'
Thamk you so much!
Thank you so much...!
That's nice , i like but what if i want to add a sign in windows to this registration system ? ( i mean related to it and db ) how to do that ? could you please teach us ?
At 9:56 what is that connection string? Where did it come from?
ruclips.net/video/zsorq1NsbTA/видео.html watch this
The setup may be different based on what database you r using like MySQL or access
can u please tell me why you have used storeprocedure
Does any changes to the database apply for other people using my program?
from where i can get the right side of the variable of connectionString please i need a help?
EN-Select the data in the Server Explorer or right click on it and select Properties. In the Properties Window, the Connection String property to your database appears.
SP-Seleccionas la de datos en el Explorador de Servidores o click derecho sobre ella y seleccionas Propiedades. En la Ventana de Propiedades aparece la propiedad Cadena de Conexión a su base de datos.
Theres an error when executing the store procedure "Msg 156, Level 15, State 1, Procedure UserAdd, Line 9
Incorrect syntax near the keyword 'AS'."
Got the same error too
delete the commas ( , ) on the top of 'AS'
this error occurs
System.Data.SqlClient.SqlException: 'The request for procedure '' failed because '' is a table object.'
you should type so dbo. [ Table Name]
need urgent help as need this done for a university deadline 17th april 11:30pm
how to i fix this issue
sqlCon.Open();
and the lines below are generating a instance failure error, but i cant see how to fix it
please help
Did you ever find the answer
@@bobmichell4088 in the end yeah, but i had to rely on C++ as the arrays were giving me trouble and connecting to my database was easier that way
Looking forward to future videos on this channel
Hey do you have a video on adding components to tool box? I tried adding but they don’t seem to show
plese make a video about how to update or delete registration form or signup form
In my scenario the username have to be unique...so Can I make it primary key or its possible with userID as primary key??
your choice. you can use id or username column.
@@CodAffection oka thanks bro I appreciate that💕
where the hell that connection string came from??! 9:55
go to your sql database, under properties look for connection string, you should find it there, just copy and paste it ;)
this video will help you to find out your db connection string : ruclips.net/video/WJ-CdeTGxp8/видео.html
Hello!
So thanks for your video. You did it very well but I have a problem. When I'm starting programme It's writing:
System.Data.SqlClient.SqlException: 'Procedure or function 'UserAdd' expects parameter '@Id', which was not supplied
If you answer I'll be happy!
still you have the problem?
you forgot to remove @Id from the UserAdd procedure.
@@CodAffection i faced same problem
I have a questions after i have done doing those whole registration sign up from where is that next management trio you are saying? Is that another application or i remain in c#? Please answer the question thanks
management trio ?
i want user register Form in c#windows Application using inheritance.Can you show that video?
Thank you once again for the lesson.
I do have one issue in my program. How can I autofill the Primary and foreign keys in the registration form?
I have the customer data going to the customer table and the user name and password going to the user login table.
The Customer table is Customer_ID (Primary key), User_ID( Foreign key
User Login table has User_ID (Primary key)
Everything worked except I did not fill the ID columns on both tables and got a null error for the key columns
Any suggestions?
I also ran into this issue, let me know if you found a solution.
Show me "could not find stored procedure UserAdd"
HELP ME!!!
Delete UserAdd from database because you will not need it
when i wanna see my data base with "Select * from UserAdd" + Execute in SQL i get "Msg 208, Level 16, State 3, Line 12
Invalid object name 'UserAdd'." after you removed UserID and changed 'create' to 'Alter'
any ideas why?
good day I have Q: I want to do a login form and register form do I do separate database or do separate table ?
Login form would verify username/password is in the user table in a database, and register form would add a new user to the user table in the same database. Unless they are for two different systems, they would be associated with the same table in the same database.
@@joshuaratcliff8554 Thank You
;)
you did not show how you get the connection string
Detailed explanation on SQL Server connection string : ruclips.net/video/WJ-CdeTGxp8/видео.html
I am getting an error saying something along the lines of "Incorrect syntax near the word Table" in my query string. It did not let me name the table so it kept it as Table instead of tbl_Login
write [Table] instead of Table
pls help me
i don't understand why 'txt' and 'commandType' have error
does the code helps with users cannot register duplicate account name?
connecting the different data tables for each user how????? pls help
where do you get the connection string
explained here: ruclips.net/video/WJ-CdeTGxp8/видео.html
please do one video security based application using asp.net membership Registration, login and logout
Just don't change. Leave as it was (CREATE). In new versions of visual studio Alter doesn't work this is all done automatically.
How to Solve this problem _ executenonquery connection property has not been initialized. c# in registration form
awesome
System.Data.SqlClient.SqlException: 'Could not find stored procedure 'UserAdd'.'
Sir can u make a Registration form connect to MyPhp not sql
Hi, every one I wish u .................................................... best in all aspect of life.
Sql.con gives me error :(
Thank you for your help. When I try to run the app, there's an error for @name_item in the line: sqlCmd.Parameters.AddWithValue(@name_item, stichwortTB.Text.Trim()); It says "the name 'name_item' doesn't exist in this context. It is however the parameter I used in the sql procedure. What can I do about it? Thank you for your help.
Have you gotten any reply on this perhaps ?
or answers..
@@de_Kazz Unfortunately, nothing until now. I will have a closer look in the weeks to come, if I find out more.
after that if we want to create user Log In, how to do that?????????
Please try to make your videos in urdu/hindi.. in that manner that would be so valuable....
I created the form on visual studio 2017, but I've never worked with Microsoft SQL sever management studio 17 and when I open the program, it asks me for a server type, server name and authentication.....Can you please help me?
try this ruclips.net/video/h7ImvYpfcUk/видео.html
Where do i download that sql?
After building this page how do I login to a certain page using this database ? can U please give the code for that ?
Yes plz tell me als
how to fix Msg 102, Level 15, State 1, Procedure UserAdd, Line 8 [Batch Start Line 0]
Incorrect syntax near ','.
do you have version in mysql workbench?
yes, ruclips.net/video/O27jl60NvQc/видео.html
Hello, how to avoid duplicate usernames in database? Please help :)
How do you stop users from using existing username?
i tried to do it but i can't change the Create Proc to Alter Proc SQL70001:This statement is not recognized in this context.
Just don't change. Leave as it was (CREATE). In new versions of visual studio Alter doesn't work this is all done automatically.
I use the process as you show in your video. but my User registration is not working. I think its because my sql server is not windows authentication its SQL server authentication. please help what should i do in that case?
try this : ruclips.net/video/WJ-CdeTGxp8/видео.html
Thanks for this video...Can u make ...one .net web page and show database connectivity using C# only.....and perform operation in database with sql server
with asp.net web form : ruclips.net/video/CsT1G3SmHXE/видео.html
with asp.net mvc : ruclips.net/video/1IFS33sPDhE/видео.html
Hey DotnetMOB, Thank you for great guide! PLease can you show us how to make DAL/CONTROLLER. I want do make diz project with MVC
User Registration With MVC : ruclips.net/video/xBS9FMF2NFM/видео.html
I cant change the name of my table and I have an error saying incorrect syntax near AS. Expecting VARIABLE.
still having this problem.
@@CodAffection nah... i used other codes..thanks for the info though
@@ralstinejaneigne3098 bro you must delete , next to password :)
Hey! Could you please help me out?
When trying to set parameters in sqlcmd.Parameters.AddWithValue("@FirstName",txtFirstName.Text.Trim());
I get an error that says txtFirstName does not exist in the current context. How can I solve this? I would appreciate help from anyone!
make sure your writing this in code behind code of the same form where we have the first name text box. or you can download the demo source code from the download link and compare with yours.
Make sure your text boxes are named txtFirstName and txtLastName etc etc
ive tried your code but the thing here is that.
The password textbox cant read varchar password. so can you tell me what can i do about it.
it always displays nvarchar can not be converted to int
Try txtPassword.Password instead of txtPassword.Text under using (SqlConnection sqlcon = new SqlConnection(connectionstring))
Where I can find Microsoft SQL server Management Studio?
learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16
select the same version as that of your sql server from left top menu. ( > SQL Server > ...)
Where and how to get that connection string?
explained here: ruclips.net/video/WJ-CdeTGxp8/видео.html
For some reason when i Run my program it cant find the stored procedure, any tips? (I followed guide closely)
please verify the stored procedure name.
you can download project source code along with db description and then compare with your project.
I figured it out, the problem was that the database that I was configuring was not the same one that was connected to my client. Thank you
thanks for commenting your solution it'll help others to fix their problem.
Hi, if I wanted to use 'Email' instead of userid, what would it be on the Data Type?
-Regards
nvarchar or varchar would be enough.
How to take connection string?
detail video is here : ruclips.net/video/WJ-CdeTGxp8/видео.html
detail video is here : ruclips.net/video/WJ-CdeTGxp8/видео.html
How can I resolve "System.Data.SqlClient.SqlException"?
Make sure you had added "using System.Data.SqlClient" with the other libraries.
thank u
Error 26: Error Locating Server/Instace Specified Fix
Please could you do a video on how to create a role based login ? RBAC style login
Laaable !!!! really
how if we we want to register the username that already created, and we want to make a warn that username already taken? ty
Sorry for the late reply,
You can warm user about duplicate user name inside btnSubmit Button Click Event
1) Create StoredProcedure : CheckDuplicateUsername
Input : username
Output : 0 - No Duplicate 1 - Duplicate Found
2) Call the StoredProcedure before saving the record - if result 1 show 'duplicate username' in a message box.
thanks for the reply. im still dont get how to make input output using data that in sql table. ty
1) Create a storeprocedure : CheckDuplicateUsername
CREATE PROC CheckDuplicateUsername
@UserName VARCHAR(100)
AS
IF EXISTS (SELECT * FROM tblUser where FirstName+' '+LastName = @UserName)
SELECT 1
ELSE
SELECT 0
2) Call this storeprocedure before save operation
Pass FirstName+' +LastName to @UserName Parameter
If it return 1 then there is a duplicate record - show warning message.
well thanks for the reply :)) goodluck, dotnet mob :) im c# beginner here hehe xd
you are welcome :)
It is tough to speak for you otherwise it is good overall but try to make it in urdu...
je t'aime
👍👍👍👍
Mic!
DOND DELL ME WHAD DO DO
咖喱味英语
Hu
Don't acting like amarican accent use your natural .
System.Data.SqlClient.SqlException: 'Could not find stored procedure 'UserAdd'.'