C# - Create User Registration Or Sign Up Form With SQL Server

How to Create a User Registration Form Or Sign Up Form in C#.
In this tutorial, we have discussed how to design and implement user registration or sign up form in the c# windows form application.
📂 GitHub Repository
► goo.gl/f3TQMh
💖 Buy me a Coffee
➤ bit.ly/3L36ut4 (PayPal)
➤ bit.ly/3VF0iPT (Razorpay)
🌀 Related Videos
goo.gl/ySUFf8 : Similar Mvc Tutorials
goo.gl/3ajHuA : Similar C# Video Tutorials
🔗 Find me in
Udemy : bit.ly/3RtyQSB
Facebook : / codaffection
GitHub : github.com/codaffection
Discord : / discord
Twitter : / codaffection
#WinForm #WindowsForm #CodAffection

[@CodAffection]

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 :

[@OriginalTubester]

I followed through and this video helped loads, thank you.

[@thayalinimuththiah7011]

Thank you very much. I used This instruction to Create WPf form.

[@nsanerydah]

Great job. Very easy to understand. Keep up the good work Sir!

[@type-1civilization527]

OMG, you really helped me, thanks!😉

[@p1ntos]

VERY USEFUL VIDEO EVEN IN 2020, Thanks!

[@benjamintenhove582]

Verry nice video!! Thanks a lot

[@truongnhutbui4835]

its wonderful, thanks very very much

[@ruvim2716]

Hey do you have a video on adding components to tool box? I tried adding but they don’t seem to show

[@danairmagonzalezmachorro9763]

Thamk you so much!

[@shovikanand3214]

Great teaching.. Thanks

[@Anton-sz6ef]

Thank you so much...!

[@bienvinidolibre3723]

thank you.. for the video have a good day.. brother.

[@danielsaxlind5052]

Any suggestion on what to do if u dont want to have the possiblite to add accounts with same Username ?

[@Daaboo]

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?

[@Hitury]

Does any changes to the database apply for other people using my program?

[@user-zt1nr5xh3z]

pls help me i don't understand why 'txt' and 'commandType' have error

[@cyberdash7883]

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 ?

[@TIAGO543211]

may god bless you, you are the better one!!

[@CodAffection]

thanks for your wonderful feedback.

[@harikrishnants8545]

ERROR Found: System.Data.SqlClient.SqlException: 'Procedure or function 'addreg' expects parameter '@id', which was not supplied.'

[@rajim1480]

Thanks for Your kind efforts. It's easily understandable as i am a new learner. God Bless You.

[@CodAffection]

Glad to hear that

[@shivanis3431]

can u please tell me why you have used storeprocedure

[@SATACPR22]

thank u

[@babypotatoplus5826]

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

[@halilmertkartal4924]

write [Table] instead of Table

[@gokulnathr8045]

i want user register Form in c#windows Application using inheritance.Can you show that video?

[@newabyuser]

awesome

[@yusraelahi9877]

best teaching method i like it very much please share more videos with simple and easy way us

[@CodAffection]

thanks for your wonderful feedback.

[@nurjimaradam2145]

Sir can u make a Registration form connect to MyPhp not sql

[@gauravuniyal5870]

Laaable !!!! really

[@levizjaperdije8499]

this error occurs System.Data.SqlClient.SqlException: 'The request for procedure '' failed because '' is a table object.'

[@doguhanyangoz5743]

you should type so dbo. [ Table Name]

[@happygirl2406]

does the code helps with users cannot register duplicate account name?

[@georgevetolavman]

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

[@CodAffection]

User Registration With MVC : kzbin.info/www/bejne/rnO2anmDe5eBfK8

[@AhmedRaza-ee7yk]

plese make a video about how to update or delete registration form or signup form

[@ragulm8676]

How to Solve this problem _ executenonquery connection property has not been initialized. c# in registration form

[@1234danik]

Hello, how to avoid duplicate usernames in database? Please help :)

[@medmahdialitaleb8209]

from where i can get the right side of the variable of connectionString please i need a help?

[@kendakf5752]

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.

[@jexxgaming1]

Where do i download that sql?

[@blaxzefl]

System.Data.SqlClient.SqlException: 'Could not find stored procedure 'UserAdd'.'

[@chrispavas837]

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?

[@CodAffection]

try this kzbin.info/www/bejne/nmisnqmPpcuWi80

[@theboss4006]

connecting the different data tables for each user how????? pls help

[@jamessoy9616]

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?

[@mitchell3088]

I also ran into this issue, let me know if you found a solution.

[@gilbertbentulan1694]

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

[@CodAffection]

management trio ?

[@euginebryansoncadiz1834]

Theres an error when executing the store procedure "Msg 156, Level 15, State 1, Procedure UserAdd, Line 9 Incorrect syntax near the keyword 'AS'."

[@thebenzc200]

Got the same error too

[@newzealandroadster]

delete the commas ( , ) on the top of 'AS'

[@katharinamuller240]

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.

[@de_Kazz]

Have you gotten any reply on this perhaps ? or answers..

[@katharinamuller240]

@@de_Kazz Unfortunately, nothing until now. I will have a closer look in the weeks to come, if I find out more.

[@sadmankhan7585]

after that if we want to create user Log In, how to do that?????????

[@angrysunshinebandit5114]

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]

Did you ever find the answer

[@angrysunshinebandit5114]

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

[@antonioquiacain9451]

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!

[@CodAffection]

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.

[@kshitijbali6915]

Make sure your text boxes are named txtFirstName and txtLastName etc etc

[@ryanlesleykeyer9049]

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.

[@junix199]

Just don't change. Leave as it was (CREATE). In new versions of visual studio Alter doesn't work this is all done automatically.

[@Howto-vo2sh]

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!

[@CodAffection]

still you have the problem?

[@junix199]

you forgot to remove @Id from the UserAdd procedure.

[@shashankc21]

@@CodAffection i faced same problem

[@KingofShena]

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

[@billymganda2504]

Try txtPassword.Password instead of txtPassword.Text under using (SqlConnection sqlcon = new SqlConnection(connectionstring))

[@vanko2052]

Show me "could not find stored procedure UserAdd" HELP ME!!!

[@rachidnait]

Delete UserAdd from database because you will not need it

[@essics1462]

how to fix Msg 102, Level 15, State 1, Procedure UserAdd, Line 8 [Batch Start Line 0] Incorrect syntax near ','.

[@sushilsampang8181]

After building this page how do I login to a certain page using this database ? can U please give the code for that ?

[@mubinonelove]

Yes plz tell me als

[@shekhnasim1541]

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?

[@CodAffection]

try this : kzbin.info/www/bejne/jXuQdJebiayrppo

[@GlitchToGaming]

How do you stop users from using existing username?

[@DarkShadow-oh5di]

In my scenario the username have to be unique...so Can I make it primary key or its possible with userID as primary key??

[@CodAffection]

your choice. you can use id or username column.

[@DarkShadow-oh5di]

@@CodAffection oka thanks bro I appreciate that💕

[@georgevetolavman]

For some reason when i Run my program it cant find the stored procedure, any tips? (I followed guide closely)

[@CodAffection]

please verify the stored procedure name. you can download project source code along with db description and then compare with your project.

[@georgevetolavman]

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

[@CodAffection]

thanks for commenting your solution it'll help others to fix their problem.

[@ZOUZOU5979]

je t'aime

[@V2traveller]

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

[@CodAffection]

with asp.net web form : kzbin.info/www/bejne/eaS3YnppiNJ7jqc with asp.net mvc : kzbin.info/www/bejne/Z3qphGZpqLV3nqc

[@ginopornasdoro9183]

do you have version in mysql workbench?

[@CodAffection]

yes, kzbin.info/www/bejne/hWOam59sZbOph8U

[@junix199]

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.

[@konligjze2003]

yea i have this problem too...

[@j_merc]

At 9:56 what is that connection string? Where did it come from?

[@bluesilhouette6748]

kzbin.info/www/bejne/sKTSo6Rng9iViqM watch this

[@bluesilhouette6748]

The setup may be different based on what database you r using like MySQL or access

[@TomMaczka]

Please could you do a video on how to create a role based login ? RBAC style login

[@ralstinejaneigne3098]

I cant change the name of my table and I have an error saying incorrect syntax near AS. Expecting VARIABLE.

[@CodAffection]

still having this problem.

[@ralstinejaneigne3098]

@@CodAffection nah... i used other codes..thanks for the info though

[@PrzemoGames]

@@ralstinejaneigne3098 bro you must delete , next to password :)

[@angusmcalister593]

Hi, if I wanted to use 'Email' instead of userid, what would it be on the Data Type? -Regards

[@CodAffection]

nvarchar or varchar would be enough.

[@sbzalz4611]

good day I have Q: I want to do a login form and register form do I do separate database or do separate table ?

[@joshuaratcliff8554]

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.

[@sbzalz4611]

@@joshuaratcliff8554 Thank You ;)

[@georgenze1956]

you did not show how you get the connection string

[@CodAffection]

Detailed explanation on SQL Server connection string : kzbin.info/www/bejne/jXuQdJebiayrppo

[@user-nr9fx9fk4o]

👍👍👍👍

[@AbdullahAhmed-ts7zc]

Sql.con gives me error :(

[@AlexMcTurk]

where do you get the connection string

[@CodAffection]

explained here: kzbin.info/www/bejne/jXuQdJebiayrppo

[@leahmacalipay5602]

How can I resolve "System.Data.SqlClient.SqlException"?

[@kendakf5752]

Make sure you had added "using System.Data.SqlClient" with the other libraries.

[@santhoshk4196]

please do one video security based application using asp.net membership Registration, login and logout

[@junix199]

Just don't change. Leave as it was (CREATE). In new versions of visual studio Alter doesn't work this is all done automatically.

[@animeguy1511]

Where and how to get that connection string?

[@CodAffection]

explained here: kzbin.info/www/bejne/jXuQdJebiayrppo

[@unxpected15]

Where I can find Microsoft SQL server Management Studio?

[@CodAffection]

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 > ...)

[@kou5479]

where the hell that connection string came from??! 9:55

[@antonioquiacain9451]

go to your sql database, under properties look for connection string, you should find it there, just copy and paste it ;)

[@CodAffection]

this video will help you to find out your db connection string : kzbin.info/www/bejne/jXuQdJebiayrppo

[@inzaiqbal1743]

Please try to make your videos in urdu/hindi.. in that manner that would be so valuable....

[@abdullahiaminu4840]

Hi, every one I wish u .................................................... best in all aspect of life.

[@bgrcomputersltd]

Error 26: Error Locating Server/Instace Specified Fix

[@aniruddhasoni6491]

How to take connection string?

[@CodAffection]

detail video is here : kzbin.info/www/bejne/jXuQdJebiayrppo

[@CodAffection]

detail video is here : kzbin.info/www/bejne/jXuQdJebiayrppo

[@Ghoulz--]

how if we we want to register the username that already created, and we want to make a warn that username already taken? ty

[@CodAffection]

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.

[@Ghoulz--]

thanks for the reply. im still dont get how to make input output using data that in sql table. ty

[@CodAffection]

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.

[@Ghoulz--]

well thanks for the reply :)) goodluck, dotnet mob :) im c# beginner here hehe xd

[@CodAffection]

you are welcome :)

[@inzaiqbal1743]

It is tough to speak for you otherwise it is good overall but try to make it in urdu...

[@FlexZone100]

Mic!

[@erenkaleli6861]

DOND DELL ME WHAD DO DO

[@faridamammadova7707]

Hu

[@user-xq7gu2pq4d]

咖喱味英语

[@aljaidiabdallah5358]

Don't acting like amarican accent use your natural .

[@metea.890]

System.Data.SqlClient.SqlException: 'Could not find stored procedure 'UserAdd'.'