Thanks Vetrivel D .It was really helpful.I was not able to create a table in my database by your way,so I tried the following way,and helped me.I am posting this so that it can be helpful to anyone who have the same problem, Steps 1-Change the name of table [dbo].[table---(change this)] Step 2-Don't save the table after creating them rather choose option update table and then update database. Step 3-On refreshing the tables you will be able to see your table.
this is what you called a true tutorial..step by step... not like the others that just recording those forms not explaining especially the codes that are used to make it run the forms.... thanks vetrivel ;)
Thank you for this! This will help for those students that needs to learn while their professor didn't know how to explain some codes in their class! God bless! :-)
What is so difficult about creating a login form? Most of the people who have problems with this haven't learned or understood C# properly before. Many jump into Visual Studio without first learning the basics like C# and OOP. So it's no wonder you run into problems developing such easy forms if you don't understand the basics.
Wow, youre amazing! Ive looked at other video tutorials for making a second form and well.. theirs were so hard to understand == , they made it look so complicated. Yours is the best
Thank you so much, I'm new to VSC and C# (I'm a web/mobile/Java Dev.); I been looking everywhere to learn how to handle data relations like this with VSC. You're like the only accurate tutorial I can find that covers the database/client(app) connections. Thanks!
I must say i'm not a very good to understand english, even when someone is talking it from another language, but while you listen and watch, you can understand the hole context. It's a good tutorial. I'm learning c# these days by reading an old 2008 version book and those videos are really helpful. Thanks.
Greetings, SqlDataAdapter sda = new SqlDataAdapter("Select Count(*) From [Table] where UserName = '" + textBox1.Text + "' and Password = '" + textBox2.Text + "'", con); Table is reserved word it should be in braces [Table]* Table is name of your table in Database Thanks
Thank you very much Sir for the Kalvi Nyanam Sharing to the World. God bless you with more Wisdom. I am going try this tutorials. Look very easy to Learn.
THANK YOU SOO MUCH SIR: throgh this tutorial help i made completed my 1st window app in c# once again thank you.............................................
could you do a video to show the various stages/exceptions or or should I say errors of logining into an interface. for example: for if : (1) you have typed in a correct username and wrong password (2) you have typed in a wrong username and correct password (3)type in password and username in capital letters Thank you very much
Ahh one scoping issue away from working! "ss can't be declared in this scope because it is being used in an enclosing scope to define a local parameter" So many kudos for a solution
add a button to hide the current form and open another, the new form field's input show be injected into a database, you can then proceed back to the original form and do business as usual
+DetectiveRichardCastle same here, unless he isnt saying "ctrl + s". Once I have saved the table it doesn't show up in the "Tables" folder on in the "Server Explorer" tab. Been trying to solve that for a while now.
Thank you SO much for putting this up here was saved me the embarresment of waking my group members in the middle of the night because i couldn't get the login to work :D
at 8:50-8:54 he said press control + ?, but if you have visual studio 2012+ look below, and you should see something like this CREATE TABLE [dbo].[Table] just change [Table] to something you want like this...CREATE TABLE [dbo].[Login].... that is another way to change the name
press control + s, save it to your project folder, click update, update database, then go to your Server Explorer, right click on Tables, Press Refresh.
I get this error when I try to login when in debug: System.Data.SqlClient.SqlException: 'Invalid object name 'Login'.' Does anybody know why this happens?
masud osman, idk what did he said but this is what to do: Press Ctrl + s, save file to somewhere in the your project then click update and then right click you tables and click refresh
ExiKz Clan i just got around to do it, when i press CTRL + S it opens up a save window where i can save the table but it doesnt open like he has, also when i save it it doesnt show up under Tables section, im using Visual Studio 2013
press control + s, save it to your project folder, click update, update database, then go to your Server Explorer, right click on Tables, Press Refresh.
One quick note . You should not store plain password in database. This what you must do. Encrypt the passpword and save that encrypted password in the database. You can use SHA-512 next during login, take the password user tries and parse it through SHA-512 and take that encrypted password and compare it with the encrypted password in database, if matches login else login failed.
Sir i have one problem regarding this program. After completing coding without any errors and starts to debugging,the login window appears and then entered username and password and clicked on the login button the error occurred on sda.Fill(dt); The error named as - Instance-specific error occurred while establishing a connection to sql server. The server was not found or was not accessible. Verify that instance name is correct and the sql server is configured to allow remote connections. (Provider: sql network interfaces, error: 26 - error locating server/instance specified) Btw thanks for video its more understandable comparing to others...! Thanks a lot And please give me solution for above error.. If you want me to contact with social media then I'm available!👍
Hi great video thanks :-) I created another C# form with databases and I would like this login box to pop up before the actual database form opens. Is there a way to connect this code to my database code please?
nice, but i have ask for you, if i have database and input with an database a equal on visual studio, how i can create program make an notification fill: Database you will input already available?
Instead of "this.Close()" in the exit button in log in screen, try "System.Windows.Forms.Application.Exit();" instead. "this.Close();" might create a bug, namely, will keep running the executable and won't let you rebuild later on.
Thanks sir for this wonderful video. Sir I have a doubt in this video tha you have created a master page in this design but whether we can create any design using this master page sir
here not only 1 because assume that if a user name is already exist as two users then it will return 2 then it will in that case so we have compare >0. if it returns 0 means user not found, if 1 or 2,3 etc user is exist. since you are using Count function that will loop all the user name from that Username column.
![How to Create a Login Form in C#.NET using SQL Server Database and Visual Studio 2022? [Source Code]](http://i.ytimg.com/vi/JgdPrbgHVoE/mqdefault.jpg)
Thanks Vetrivel D .It was really helpful.I was not able to create a table in my database by your way,so I tried the following way,and helped me.I am posting this so that it can be helpful to anyone who have the same problem,
Steps 1-Change the name of table [dbo].[table---(change this)]
Step 2-Don't save the table after creating them rather choose option update table and then update database.
Step 3-On refreshing the tables you will be able to see your table.
Dear friend.
Visit youtube channel "Solve My Programming Task".
They create simple programs for free. I used it.
this is what you called a true tutorial..step by step... not like the others that just recording those forms not explaining especially the codes that are used to make it run the forms.... thanks vetrivel ;)
Thanks a lot.
Thank you for this! This will help for those students that needs to learn while their professor didn't know how to explain some codes in their class! God bless! :-)
. . . . . . . . .
What is so difficult about creating a login form? Most of the people who have problems with this haven't learned or understood C# properly before. Many jump into Visual Studio without first learning the basics like C# and OOP. So it's no wonder you run into problems developing such easy forms if you don't understand the basics.
also you can create a FAKE login window with viruses. hope that it will work on my sister
Thank you for liking video.
Hey, thank you. I'm a beginner and I was stuck with this problem for two days and I wasn't getting anywhere. This video helped me a lot.
Wow, youre amazing! Ive looked at other video tutorials for making a second form and well.. theirs were so hard to understand == , they made it look so complicated. Yours is the best
@inazmul123 A single equal means that there is going to be a change. Two of them means there is no change.
why is everything explained so complicated, = means an assignment, == means a comparison
Thank you so much, I'm new to VSC and C# (I'm a web/mobile/Java Dev.);
I been looking everywhere to learn how to handle data relations like this with VSC.
You're like the only accurate tutorial I can find that covers the database/client(app) connections.
Thanks!
Thank you.
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll
sda.Fill(dt); problem
I gt the same
I must say i'm not a very good to understand english, even when someone is talking it from another language, but while you listen and watch, you can understand the hole context. It's a good tutorial. I'm learning c# these days by reading an old 2008 version book and those videos are really helpful. Thanks.
wamenslot Thanks Brother.. Further Any Doubts then feel free to ask me.. if you like our tutorials then kindly share your friends..
Greetings,
SqlDataAdapter sda = new SqlDataAdapter("Select Count(*) From [Table] where UserName = '" + textBox1.Text + "' and Password = '" + textBox2.Text + "'", con);
Table is reserved word it should be in braces [Table]* Table is name of your table in Database Thanks
+Adeel Tariq Thank you so much.... That was all i needed........
" [Table]"...
Thanks I was facing same for long time...
Nice Thank
Thanks captain :)
Adeel Tariq i want Your Email so Please Send Me Your Email
Thank you very much Sir for the Kalvi Nyanam Sharing to the World. God bless you with more Wisdom. I am going try this tutorials. Look very easy to Learn.
Can you post a tutorial about logging in with different user types. for example, if i am the admin it will direct me into different form
Joey Albert Conejero Based on your doubts, Am made video for you
ua-cam.com/video/6DB6_gStuOk/v-deo.html
here is one of the best programmers in the world
da.fill(dt); in this statement occure some error...
THANK YOU SOO MUCH SIR:
throgh this tutorial help i made completed my 1st window app in c# once again thank you.............................................
Thanks for your valuable feedback. Refer our channel in your friend circle.
could you do a video to show the various stages/exceptions or or should I say errors of logining into an interface. for example: for if :
(1) you have typed in a correct username and wrong password
(2) you have typed in a wrong username and correct password
(3)type in password and username in capital letters
Thank you very much
Vetri vel.D Thanks for the great tutorial, anna. Don't care about the bad comments. Always share your knowledge and help all.
You are a lot of new things I need a scooby snacks for my check then back to work
Very good, and simple way to explain how to add password to your form.... Thank you
Welcome to indian tech support how can i help u
Ahh one scoping issue away from working! "ss can't be declared in this scope because it is being used in an enclosing scope to define a local parameter"
So many kudos for a solution
8:50 same problem... Press Control + ?.... Your favorable response will be highly appreciated... Thank you
@Mega Trash ctrl+f8 doesn't do anything
so u just change the name at the bottom and press update (I had to go to a different video to know this)
@@christi7990 thanks... u guys are just great
@@adityasagarr lol I forgot I wrote this
@@christi7990 😄even I was not expecting any reply on my reply to your reply...
Omg... that's too much reply 😂
thanks for give more information in C#.. i learn how to Create Login Window...
How are you??
I lost you at 8:50. Do you think you could help me?
@technical gamer THANK YOU
Thank you so much! It worked here!
how do you do that if the user will use sign up?
add a button to hide the current form and open another, the new form field's input show be injected into a database, you can then proceed back to the original form and do business as usual
can i ask what ctrl did you use in this part 8:50 when you change the table name? thank you in advance
OMG U ARE FANTASTIC!!!
Thank You sir. you explained it very easily..... Appreciate your hardwork
Very Helpful !!! Thank you Thank you - ph
+Jemuel Ortega Thanks for your Feedback. Please Ask any Doubts i will make video for that..!
+Vetrivel D Can you please help me at 8:50, when i press CTRL + S, it prompted me to save the data?
+Vetrivel D , do you have a video that how to connect the database to combobox?
+DetectiveRichardCastle same here, unless he isnt saying "ctrl + s". Once I have saved the table it doesn't show up in the "Tables" folder on in the "Server Explorer" tab. Been trying to solve that for a while now.
+Vetrivel D what you say in 8:50
Thank you SO much for putting this up here was saved me the embarresment of waking my group members in the middle of the night because i couldn't get the login to work :D
אורן סאסי חברה בעתיד
11.05.2010
2010
אורן סאסי
אורן ססי
אורן סאסי
אורן סאסי
אורן ססי
אורן סאסי
אורן סאסי
at 8:50-8:54 he said press control + ?, but if you have visual studio 2012+ look below, and you should see something like this CREATE TABLE [dbo].[Table]
just change [Table] to something you want like this...CREATE TABLE [dbo].[Login].... that is another way to change the name
press control s
press control + s, save it to your project folder, click update, update database, then go to your Server Explorer, right click on Tables, Press Refresh.
Thanks Man :)
Thanks Bro :)
thanx its very much help full when i just have 4 days to submit my project related to hotel management system
I get this error when I try to login when in debug:
System.Data.SqlClient.SqlException: 'Invalid object name 'Login'.'
Does anybody know why this happens?
Thank you so much for guide in very good details. its really helpful for me as I am very beginner in Development.
hmm nice tutorial. Do you have any video regarding insertion and retrieval of existing data set into new form from existing database?
u said nice that mean u understood whole video can uolease help me to understand at 8:50 sec what did he said ctrl+?................
masud osman, idk what did he said but this is what to do: Press Ctrl + s, save file to somewhere in the your project then click update and then right click you tables and click refresh
thank u
and requesting to add more Vedio series
hi, im having a problem with ( sda.Fill(dt); ) whenever i click login button it say sqlexception occurred , please help
do you resolve this? i have the same problem too.
i had sloved it
the problem in row name its not Username
replace it with USERNAME
AND THE SAME WITH password
Change the data type of USERNAME to nchar(10)
I used braces[table] and the error is gone but still it doesn't log in, it is showing only--"Please check your username and password". plz help
Thank's this helped!
It is easy to understand for beginners like me, very nice video and helpful
Muito bom, me ajudou bastante. Valeu!!!
Dear friend.
Visit youtube channel "Solve My Programming Task".
They create simple programs for free. I used it.
gra8 one... i don't worry about your grammar or accent. it is a good tutorial for beginners... respect and salute...
This is a wonderful step by step login window demonstration! Thank you. A+
Thank you for giving me A+
This is a brilliant tutorial :) Thank you so much for making this video.
You know I have this project in C#, and this helps a lot. thank you.
8:50 i cant understand what does he say, please help ?
i hear control + epic or something i dont know...
yah i cant understand what he type to save the table
i hear control acid
@@davidbryanramboy5043 bro he said Control S it means save it
very good tutorial....please upload more tutorials of different serious project..that could help to learn...thank you.
How did he save the table at 8:54 ?
give update table
When u close that window, it will ask to Enter Table name. once u enter, it will automatically save into DB
Thank you so much. You simply explained. Great
8:51 I don't know what he is saying, help please.
Same, he says something "Press control..."
and then you want to make "login"
f8?
Ctrl S, man :D
Press Control + S then press update then refresh ur tables :)
I like this class very much...
ververy thanks for you
+s chandru Thank You.. Please Post your Question?
This isn't working, I can't name my tables, I can't save my table.
same here :(
Nevermind i fixed it
How you did it?
I'm stuck there too
you click update and i cant remember after that sorry
After updating, right-click on Table and select "Refresh".
THANK YOU VERY MUCH SIR. IT IS VERY HELP FULL. WAIT FOR YOUR NEXT TUTORIAL.
what does he say at 8:50, CTRL + ? I didnt really understand it Vetri vel.D
ExiKz Clan
thanks
ExiKz Clan
i just got around to do it, when i press CTRL + S it opens up a save window where i can save the table but it doesnt open like he has, also when i save it it doesnt show up under Tables section, im using Visual Studio 2013
+hyensik on webs yeah! my problem was the same as you now i stuck here
+hyensik on webs am having the same problem it doesnt save in the section of the tables folder
+Odane Denton didnt he say CTRL + esc?
I Am Very Thankful to you for that
I am From Afghanistan
hello how to solve this sda.Fill(dt); tell me that is unhondled Vetrivel D
+elvira arishta DID you solved? i need please?
+Alfgor död no i have no solved
i solved it. it was easy. just put in the text [Login] instead of Login
Andrea Pasin could you explain further please just stuck on that bit mate
I used braces[table] and the error is gone but still it doesn't log in, it is showing only--"Please check your username and password". plz help
Thank you so much for sharing your knowledge!!!
WTF you forgot the PasswordChar xD Everyone can see your pass
Kai Jan 57
This tutorial is for you..not for creator.but it's ok you find a fault
Go to Password textbox ,in properties in Password Char put *.
Simple Superb.Thank You Vetrivel D.
8:50 = Mayus + ALT + U
You're doing gods work
Thats very nice tutorial really help me thanks alot sir
ctr+ wutt??
me too am stuck their
press control + s, save it to your project folder, click update, update database, then go to your Server Explorer, right click on Tables, Press Refresh.
where i need help fast
Johnny_GR h
Thank you so much sir! and thank you comment section you both helped me alot !
This is horrible.
Great tuto..Sir...By using C# We can Make 2d and 3d game on Unity game engine. Unity is free.
its hard to understand what you say sometime! But thankyou a lot ! continue like this :p
It's vry helpful for me thanku so much
Thank you so much, your video was pretty easy to follow!
Thanks for your valuable feedback. Refer our channel in your friend circle.
nicole johnston pretty easy to login
Without username and password.
Nice video for Beginners ..Simply superb.. Thank you so much,
One quick note . You should not store plain password in database. This what you must do.
Encrypt the passpword and save that encrypted password in the database. You can use SHA-512
next during login, take the password user tries and parse it through SHA-512 and take that encrypted password and compare it with the encrypted password in database, if matches login else login failed.
That gets a little more complicated. This is a complete beginners tutorial, although he should have definitely mentioned that in the video.
I agree, its always good to go with this style and you can impress the interviewer that you know industry coding patterns
You made my day thank u for your help😍💖
Sir i have one problem regarding this program.
After completing coding without any errors and starts to debugging,the login window appears and then entered username and password and clicked on the login button the error occurred on sda.Fill(dt);
The error named as -
Instance-specific error occurred while establishing a connection to sql server. The server was not found or was not accessible. Verify that instance name is correct and the sql server is configured to allow remote connections. (Provider: sql network interfaces, error: 26 - error locating server/instance specified)
Btw thanks for video its more understandable comparing to others...! Thanks a lot
And please give me solution for above error..
If you want me to contact with social media then I'm available!👍
I thanks to you i get go knowledge from this video
Very clear and understandable. Thanks for the upload..
+Linexust Jk Thank You.. Please Post your Question?
sir your videos are awesome best nice creating new ideas😇😇😇😇
Thanks so much, great tutorial worth watching!!
thanks for this only one question? How did u name the table @8:51?
Thank you everything just works just fine :) deserves a like 100%!!!
It works great for me, thanks a lot Vetrivel D
Thank you so much for your video Mr. Vetrivel, It help me a lot.
Hi great video thanks :-)
I created another C# form with databases and I would like this login box to pop up before the actual database form opens. Is there a way to connect this code to my database code please?
Thanks alot Sir Very helpfull tutorial.....
+Sandeep Kaur Riar oye sandy its helpful...not helpfull... XD
Thank you so much!! since this moment i love indu people!!!
You are my hero today ;) Thanks a million
Thank you sir i understand how to develop user name and password windows app connecting with sql database.
thank you, this educative piece of video helps a lot. thank you once again
Thank you for this tutorial. It's very helpful!
Arnold Glenn Managbanag bro paano ba ma debug yung error sa sda.fill(dt)
nice, but i have ask for you, if i have database and input with an database a equal on visual studio, how i can create program make an notification fill: Database you will input already available?
Instead of "this.Close()" in the exit button in log in screen, try "System.Windows.Forms.Application.Exit();" instead.
"this.Close();" might create a bug, namely, will keep running the executable and won't let you rebuild later on.
Thunk youuuuuu from moroco😍😍🇲🇦🇲🇦🇲🇦
(8.50) which button you used?
Ctrl+f6 or Ctrl+6
nice video. i learnt a lot from this...thanks
Thank you sir. I always wanted to build a windows desktop application and I got the right place to start with. Subscribed :)
Thanks sir for this wonderful video. Sir I have a doubt in this video tha you have created a master page in this design but whether we can create any design using this master page sir
it's helpful tutorial .
Is there any tutorial about users roles and Permission ??
what is the create new table name
in 8.50 mins in what cntrl+?
Very Helpful !!! Thank you Thank you - Sir
Vetri my dear brother KEEP UP THE GREAT WORK. Thanks for helping others....... you have another loyal subscriber...... Thank you!!!!!!!
it is avery interesting and easy to understand video thank you.please may i help you plajiarism cheking system in c# video
plz add how to change password or user name without accessing database table from database.......... but superb effort keep it up .........
I got a lot of knowledge ,thanks
here not only 1 because assume that if a user name is already exist as two users then it will return 2 then it will in that case so we have compare >0. if it returns 0 means user not found, if 1 or 2,3 etc user is exist. since you are using Count function that will loop all the user name from that Username column.
It was really helpful !! Thank you very much