Create Login Window in C# Using Sql Server 

goo.gl/RFY5C2 : Subscribe to CodAffection goo.gl/Z6SkSC : C# CRUD Operations With DB goo.gl/WsgPbp : C# User Registration With DB goo.gl/Gu5q37 : Export PDF in C#

I am beginner to C#. Search many places. But your explained the working method step by step. Thanks a lot.

Tried this for a project i am building, very helpful Thank you. You should upload some recent videos like this of Visual Studio 2019

OMG! You saved me! Thought I was going to be up all night again trying to finish my project, but this video was SOOO helpful! Thank you, thank you, thank you.

please help I am at 17:50, and I get this error no matter what System.Data.SqlClient.SqlException: 'Incorrect syntax near the keyword 'Table'.'

Thank you.!

even after 4 years it`s a best video. thx man

Great tutorial, Thank you.

This helped me a lot😊thank youw❤

Crystal clear! Thanks a lot.

System.Data.SqlClient.SqlException (0x80131904): An attempt to attach an auto-named database for file C: \Users\jmpla\source epos\Aqua Lab\DataBase\LoginDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. HELPPP

Thanks man i have windows app interview today thanks a lot

Thank you sir! Very good tutorial.

I cant debug it shows 1)The name 'txtusername' does not exist in the current context 2)The name 'txtpassword' does not exist in the current context Plz help what I do

thankyou you just saved my life

Use secure procedure is better than leaving open SQL query string

Can you help me? At the saving 8:45 if I click OK at save in into DB it doesnt show in server explorer at tables

Super gooooood!!! Thank you!)))

Thanks for this tutorial , but I have a problem with the sda.Fill(dtbl). ==> System.Data.SqlClient.SqlException: 'An expression of non-boolean type specified in a context where a condition is expected, near 'de'.' I have already read the comments and i didn't find the right answer . Please answer me as soon as possible.

Thank you for good subject guven for me....i have an doubt I. E., u r creating one table that is login table in database right, in that table first username value is 1 only....y u giving user1 as in username value in login form? 1 and user1 both r same in this situation? Please clarify my doubt as soon as possible. I'm waiting for ur response. Tq

Hi, I have a question. In video, you have one main form. But if I have two, and for each form I have login and password, how I can realize this? 9:10 - I see, you create here 2 users, but you didn't use 2nd user in code. I try did it - I remade part of code "if(dtbl.Rows.Count == 1)", where I changed 1 to 2 and changed text in braces for my 2nd form and this reworked part I inserted after "else {...}". But when I run the application and enter the data for the second user, Visual Studio opens for some reason the first form. What should I do?

Thanks Lot very helpful keep it up !!!

Best tutorial so far for login authentication..

Thank You Sir....!!!!

Thank you very much! My software buyers can now safely use their purchased program!

Thank you

when i try to save the table it comes up a menu asking me where i want to save it to, and doesn't apper in the tables collum after, any help???

Bro much love for you you helped me a lot i loveyou so much have a great life

thank you so much! ❤

Thanks for the help, it worked🎉

Thank you very much for this.

This was pretty helpful. Thanks a mill

this helped me thank you bro

Crystal clear. Thanks for the explanation, it really helped!

Thank you it has Great tutorial

Thank you For helping Others!!!!!!

nice uploade more video related windows form

very useful thanks a lot

I love u man, thank u :)

Thanks very cool

*YOU ARE THE BEST!!!*

I"m using Visual studio 2019. I cannot create tables with the steps provided by you. In the Server Explorer under the table it shows nothing.

Your are the Best mate! straightforward and easy to follow the steps, Thanks...

Thank you very much, it worked perfectly!

god bless you and your voice

You helped me a lot. Thank you!

Thank you so much very helpful :-)

Thanks alot man, very useful!!

Those having issue with sda.Fill(dt); please, check your sda query, the username and password we are using from input in the query should have apostrophes " ' " enclosing them. please, check the code carefully and make sure you add those, and your problem will be solved.

System.Data.SqlClient.SqlException: 'An attempt to attach an auto-named database for file C: \Users\sam\Desktop\Passwords And user.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.'

sir! thank you!its works fine!

I wrote my code exactly like this, only my table name is /*Signup*/. Upon running the application even after entering correct username and password it is saying check username and password. Please help

Hi sir I have some problem when I write the correct username and password its show not correct I don't know why can you help me please?

query one record then direct to main form to open but not to match successfully with bool true.

bakit kapag pinipindot ko yung login ganto nalabas? An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll Additional information: An attempt to attach an auto-named database for file C: \Users\Mercado\Documents\Visual Studio 2015\Projects\GenericoCashieringSystem\GenericoCashieringSystem\LoginDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

thank you very very mutch God Bless You

Server Explore in Data Connections in LoginDB in Table in File do not show. Please sir Help me

thanks a million bro.

😍😇 thnk U sO mUch sir !!

this still works until now :D

THANK YOU!

how can i display the name of the user who logged in to the next form?

Thanks! Its working :D

The name 'ObjFrmMain' not exist at the current context. could you help me please?

How to create it for multi user so every one has different form apperead after logging in??

Sir you are the best

Thanks a lot❤️❤️❤️❤️

Very nice person

Good

nice tutorial

thanks bruda

when I hit add a table it just says loading... the design surface is loading.. it's been 27 minutes ffs

thanx man love ya and drink some water :) thanx for the help

but the password string anyone can see if they open sql server database. How can convert the password string into some unique symbol in sql server that is not the password we type in the text box?

When I add table n databse it doesnot appear in table option.

thanks for this video bro

Thank you!!!!!

how can i fix Error 1 An object reference is required for the non-static field, method, or property 'System.Windows.Forms.Control.Show()' c:\users eda\documents\visual studio 2010\Projects\WindowsFormsApplication1\WindowsFormsApplication1\Form1.cs 33 16 WindowsFormsApplication1

Great. Thanks so much :D

Why u used disconnected architecture ,,,, connected architecture is used

Dear I got error ' invalid object name ' ? Please help me..

is that possible when i click login it navigate to my google account?

This is not the best way to login to a database.

Main Menu - the window which opens after corrrect login. After closing Main Menu window the program doesn't close(

Hi, I'm using VS 2017. Thank you for this video, it is great and so helpful! But I followed exactly as what you have shown but when I entered the right credentials, it will run the else statement still. Do you know how I can fix this? Thank you in advance~!

so sweet

Thank you so much for the Code it will help me for life time

thanks bro

Thank you very much !!!!

Please tutorial of coding

It works, Thank you

Thank you si much

Good day maam/sir can i ask for a help 😭😭 im doing right now a kiosks project and i dont know how to pass a value from exe to another exe 😭😭😭

Life saver

At 8:40 when i press ctl+s instead of showing a dialoge box that shows in the video like choose name, my PC asks to saves the file in my documents or in local disk drive instead of saving it in visual studio like a dialoge box has appeared for the name of the table. Please can someone help. Please.

the frmMain is not colored , what should i do ?

YOUR VOICE LOOOOOOOL

Why this error occur at 'sda.Fill(dtbl)'? Exception unhandled System.Data.SqlClient.SqlException: 'An attempt to attach an auto-named database for file C: \Users\User\Documents\Visual Studio 2017\Projects\LoginApp\DB\LoginDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.'

How to make it to connect to a website Sql data have I replaced the like url for the database with the remote database but when I hit start it will stop saying like it can't connect but it's connected in visual studio.

the fill function does not work like that it say a missing .. the error message says that the server was not found or was not accessible