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.
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!
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 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.
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.
THANK YOU SOO MUCH SIR: throgh this tutorial help i made completed my 1st window app in c# once again thank you.............................................
+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.
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 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.
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
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
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
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?
again very helpful Vetrivel D; Thanks for taking the Time to create this Video//Tutorial//Demo-View... I thought it was very well thought out and explained thoroughly enough to an Understanding! --- William J. Le Roi III ---
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.
heyy buddy your tutorial are awesome (Y) am actually developing a windows app for a competition and believe me it's really helping me out as i never worked on visual studio and C#
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
@Vetrivel D I don't get what you said about the table function. from 8:53 for the PASSWORD. you said control something but I don't get it. sorry for asking
This is helpful for real , Thanks for your hard work ! , I would like you to make a video about registration Window , related to this one if you please :D
![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.
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.
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
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.
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 😂
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.
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll
sda.Fill(dt); problem
I gt the same
Vetri vel.D Thanks for the great tutorial, anna. Don't care about the bad comments. Always share your knowledge and help all.
da.fill(dt); in this statement occure some error...
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..
OMG U ARE FANTASTIC!!!
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.
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
th-cam.com/video/6DB6_gStuOk/w-d-xo.html
Very good, and simple way to explain how to add password to your form.... Thank you
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 guide in very good details. its really helpful for me as I am very beginner in Development.
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
gra8 one... i don't worry about your grammar or accent. it is a good tutorial for beginners... respect and salute...
You are a lot of new things I need a scooby snacks for my check then back to work
can i ask what ctrl did you use in this part 8:50 when you change the table name? thank you in advance
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
Thank You sir. you explained it very easily..... Appreciate your hardwork
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!
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 :)
This is a wonderful step by step login window demonstration! Thank you. A+
Thank you for giving me A+
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 :)
here is one of the best programmers in the world
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
Thank you so much! It worked here!
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
sir your videos are awesome best nice creating new ideas😇😇😇😇
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?
It is easy to understand for beginners like me, very nice video and helpful
Welcome to indian tech support how can i help u
Thank you everything just works just fine :) deserves a like 100%!!!
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
Thank you sir. I always wanted to build a windows desktop application and I got the right place to start with. Subscribed :)
I lost you at 8:50. Do you think you could help me?
@technical gamer THANK YOU
Thunk youuuuuu from moroco😍😍🇲🇦🇲🇦🇲🇦
Muito bom, me ajudou bastante. Valeu!!!
Dear friend.
Visit youtube channel "Solve My Programming Task".
They create simple programs for free. I used it.
You made my day thank u for your help😍💖
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?
thanx its very much help full when i just have 4 days to submit my project related to hotel management system
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.
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
It's vry helpful for me thanku so much
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
thanks for give more information in C#.. i learn how to Create Login Window...
How are you??
8:50 = Mayus + ALT + U
You're doing gods work
Vetri my dear brother KEEP UP THE GREAT WORK. Thanks for helping others....... you have another loyal subscriber...... Thank you!!!!!!!
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.
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 *.
again very helpful Vetrivel D;
Thanks for taking the Time to create this Video//Tutorial//Demo-View...
I thought it was very well thought out and explained thoroughly enough to an Understanding!
---
William J. Le Roi III
---
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. You simply explained. Great
This is horrible.
Simple Superb.Thank You Vetrivel D.
Thank you so much for sharing your knowledge!!!
heyy buddy your tutorial are awesome (Y)
am actually developing a windows app for a competition and believe me it's really helping me out as i never worked on visual studio and C#
I like this class very much...
ververy thanks for you
+s chandru Thank You.. Please Post your Question?
Very clear and understandable. Thanks for the upload..
+Linexust Jk Thank You.. Please Post your Question?
Nice video for Beginners ..Simply superb.. Thank you so much,
Thats very nice tutorial really help me thanks alot sir
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.
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
Thank you so much for your video Mr. Vetrivel, It help me a lot.
Thanks so much, great tutorial worth watching!!
@Vetrivel D I don't get what you said about the table function. from 8:53 for the PASSWORD. you said control something but I don't get it. sorry for asking
its hard to understand what you say sometime! But thankyou a lot ! continue like this :p
Thanks alot Sir Very helpfull tutorial.....
+Sandeep Kaur Riar oye sandy its helpful...not helpfull... XD
thank u
and requesting to add more Vedio series
It works great for me, thanks a lot Vetrivel D
Thank you for this tutorial. It's very helpful!
Arnold Glenn Managbanag bro paano ba ma debug yung error sa sda.fill(dt)
Thank you so much sir! and thank you comment section you both helped me alot !
I Am Very Thankful to you for that
I am From Afghanistan
I got a lot of knowledge ,thanks
nice video. i learnt a lot from this...thanks
Wooow the best teacher
You are my hero today ;) Thanks a million
Great tutorial!!! Helped me a lot! But I think you should improve your speech clarity :)) CHEERS!
thank you, this educative piece of video helps a lot. thank you once again
It was really helpful !! Thank you very much
thnks for this tutorial this is helpful good job keep it up man
This is helpful for real , Thanks for your hard work ! , I would like you to make a video about registration Window , related to this one if you please :D
very useful.........thank you sir
Great tuto..Sir...By using C# We can Make 2d and 3d game on Unity game engine. Unity is free.
I thanks to you i get go knowledge from this video
Awesome tutorial! Thanks! Keep it going
tq so so much ! really help me for my programming c# project 👍
this is a good explanation
good
my concept is much clear now
Many thanks bro Good job
100% working! thanks man :))
i am getting error near login , and exception on sda.fill(dt) any help ?
Thanks Vetri...This will be helpful definitely
It really works
Thank you .....