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 :
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
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
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.
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!
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 ?
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.
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?
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 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
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.
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.
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.
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?
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 > ...)
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?
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
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
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.
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
:
VERY USEFUL VIDEO EVEN IN 2020, Thanks!
I followed through and this video helped loads, thank you.
Great job. Very easy to understand. Keep up the good work Sir!
thank you.. for the video have a good day.. brother.
Thanks for Your kind efforts. It's easily understandable as i am a new learner. God Bless You.
Glad to hear that
OMG, you really helped me, thanks!😉
ERROR Found:
System.Data.SqlClient.SqlException: 'Procedure or function 'addreg' expects parameter '@id', which was not supplied.'
At 9:56 what is that connection string? Where did it come from?
th-cam.com/video/zsorq1NsbTA/w-d-xo.html watch this
The setup may be different based on what database you r using like MySQL or access
Thank you very much. I used This instruction to Create WPf form.
Does any changes to the database apply for other people using my program?
Verry nice video!! Thanks a lot
best teaching method i like it very much please share more videos with simple and easy way us
thanks for your wonderful feedback.
Great teaching.. Thanks
Any suggestion on what to do if u dont want to have the possiblite to add accounts with same Username ?
can u please tell me why you have used storeprocedure
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
may god bless you, you are the better one!!
thanks for your wonderful feedback.
Thamk you so much!
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'
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
this error occurs
System.Data.SqlClient.SqlException: 'The request for procedure '' failed because '' is a table object.'
you should type so dbo. [ Table Name]
Hey do you have a video on adding components to tool box? I tried adding but they don’t seem to show
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.
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💕
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
where do you get the connection string
explained here: th-cam.com/video/WJ-CdeTGxp8/w-d-xo.html
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 ?
its wonderful, thanks very very much
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...
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?
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 : th-cam.com/video/WJ-CdeTGxp8/w-d-xo.html
does the code helps with users cannot register duplicate account name?
System.Data.SqlClient.SqlException: 'Could not find stored procedure 'UserAdd'.'
Sql.con gives me error :(
connecting the different data tables for each user how????? pls help
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.
Where do i download that sql?
How to Solve this problem _ executenonquery connection property has not been initialized. c# in registration form
pls help me
i don't understand why 'txt' and 'commandType' have error
Show me "could not find stored procedure UserAdd"
HELP ME!!!
Delete UserAdd from database because you will not need it
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 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 :)
Thank you so much...!
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
;)
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.
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
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 th-cam.com/video/h7ImvYpfcUk/w-d-xo.html
you did not show how you get the connection string
Detailed explanation on SQL Server connection string : th-cam.com/video/WJ-CdeTGxp8/w-d-xo.html
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.
do you have version in mysql workbench?
yes, th-cam.com/video/O27jl60NvQc/w-d-xo.html
awesome
how to fix Msg 102, Level 15, State 1, Procedure UserAdd, Line 8 [Batch Start Line 0]
Incorrect syntax near ','.
plese make a video about how to update or delete registration form or signup form
after that if we want to create user Log In, how to do that?????????
thank u
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 > ...)
How do you stop users from using existing username?
Where and how to get that connection string?
explained here: th-cam.com/video/WJ-CdeTGxp8/w-d-xo.html
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 : th-cam.com/video/WJ-CdeTGxp8/w-d-xo.html
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))
Please try to make your videos in urdu/hindi.. in that manner that would be so valuable....
Sir can u make a Registration form connect to MyPhp not sql
i want user register Form in c#windows Application using inheritance.Can you show that video?
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.
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
Laaable !!!! really
How to take connection string?
detail video is here : th-cam.com/video/WJ-CdeTGxp8/w-d-xo.html
detail video is here : th-cam.com/video/WJ-CdeTGxp8/w-d-xo.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.
Error 26: Error Locating Server/Instace Specified Fix
Hi, every one I wish u .................................................... best in all aspect of life.
Hello, how to avoid duplicate usernames in database? Please help :)
How can I resolve "System.Data.SqlClient.SqlException"?
Make sure you had added "using System.Data.SqlClient" with the other libraries.
Please could you do a video on how to create a role based login ? RBAC style login
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 : th-cam.com/video/xBS9FMF2NFM/w-d-xo.html
je t'aime
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 : th-cam.com/video/CsT1G3SmHXE/w-d-xo.html
with asp.net mvc : th-cam.com/video/1IFS33sPDhE/w-d-xo.html
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 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...
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'.'