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

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

[@p1ntos]

VERY USEFUL VIDEO EVEN IN 2020, Thanks!

[@OriginalTubester]

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

[@nsanerydah]

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

[@type-1civilization527]

OMG, you really helped me, thanks!😉

[@bienvinidolibre3723]

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

[@shovikanand3214]

Great teaching.. Thanks

[@benjamintenhove582]

Verry nice video!! Thanks a lot

[@rajim1480]

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

[@CodAffection]

Glad to hear that

[@thayalinimuththiah7011]

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

[@Hitury]

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

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

[@harikrishnants8545]

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

[@TIAGO543211]

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

[@CodAffection]

thanks for your wonderful feedback.

[@danairmagonzalezmachorro9763]

Thamk you so much!

[@truongnhutbui4835]

its wonderful, thanks very very much

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

[@shivanis3431]

can u please tell me why you have used storeprocedure

[@danielsaxlind5052]

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

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

[@Anton-sz6ef]

Thank you so much...!

[@AlexMcTurk]

where do you get the connection string

[@CodAffection]

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

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

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

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

[@happygirl2406]

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

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

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

[@AbdullahAhmed-ts7zc]

Sql.con gives me error :(

[@ruvim2716]

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

[@vanko2052]

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

[@rachidnait]

Delete UserAdd from database because you will not need it

[@jexxgaming1]

Where do i download that sql?

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

[@ginopornasdoro9183]

do you have version in mysql workbench?

[@CodAffection]

yes, kzbin.info/www/bejne/hWOam59sZbOph8U

[@ragulm8676]

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

[@SATACPR22]

thank u

[@AhmedRaza-ee7yk]

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

[@theboss4006]

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

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

[@blaxzefl]

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

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

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

[@กัณฑ์พงษ์ศรีสุธาภัทร์]

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

[@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 ;)

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

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

[@abcdef_101]

Where and how to get that connection string?

[@CodAffection]

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

[@sadmankhan7585]

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

[@gokulnathr8045]

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

[@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 :)

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

[@georgenze1956]

you did not show how you get the connection string

[@CodAffection]

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

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

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

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

[@newabyuser]

awesome

[@GlitchToGaming]

How do you stop users from using existing username?

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

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

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

[@nurjimaradam2145]

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

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

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

[@essics1462]

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

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

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

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

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

[@1234danik]

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

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

[@АлексейБулай-и6л]

👍👍👍👍

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

[@leahmacalipay5602]

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

[@kendakf5752]

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

[@bgrcomputersltd]

Error 26: Error Locating Server/Instace Specified Fix

[@gauravuniyal5870]

Laaable !!!! really

[@ZOUZOU5979]

je t'aime

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

[@TomMaczka]

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

[@inzaiqbal1743]

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

[@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 :)

[@FlexZone100]

Mic!

[@erenkaleli6861]

DOND DELL ME WHAD DO DO

[@度空-u5r]

咖喱味英语

[@faridamammadova7707]

Hu

[@aljaidiabdallah5358]

Don't acting like amarican accent use your natural .

[@metea.890]

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