Create Login Window in C# Using Sql Server

[@CodAffection]

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#

[@rjcreations6727]

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

[@CodAffection]

Glad to hear that

[@SMart-iy7zx]

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

[@connief2679]

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.

[@ishkasewshanker3813]

did u finish it?

[@ness9038]

@@ishkasewshanker3813 we hope so

[@madmac558]

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

[@TarunKumar-ry7bc]

Thanks man i have windows app interview today thanks a lot

[@warzhydra990]

This helped me a lot😊thank youw❤

[@earnafterlearn9765]

Best tutorial so far for login authentication..

[@CodAffection]

I am glad you found the video helpful.

[@ronaldjohnson4470]

Great tutorial, Thank you.

[@vega7836]

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

[@CodAffection]

glad you found the video helpful in your live projects.

[@digitplays4008]

What a load lol, if anyone was buying software it wouldnt be from someone who couldnt make a login form.

[@Error-vd1yo]

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'.'

[@mikhalpalych]

Same

[@ПавелК-й1ж]

Crystal clear! Thanks a lot.

[@zafersogutcu]

Thank you very much, it worked perfectly!

[@CodAffection]

I'm glad it helped.

[@yasmine2176]

thankyou you just saved my life

[@justjase10]

Thanks for the help, it worked🎉

[@sameeraprasantha4586]

Thank you.!

[@georgevetolavman]

Thank you sir! Very good tutorial.

[@kasyfredy]

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

[@CodAffection]

you are welcome, by the way thanks for watching my video

[@helengargantiel4065]

thank you so much! ❤

[@Cossack3000]

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

[@g3nito409]

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

[@CodAffection]

thanks for the wonderful comment.

[@YamiKeizerLeon]

Thanks! Its working :D

[@WayEngineer]

Super gooooood!!! Thank you!)))

[@Scaramouche122]

*YOU ARE THE BEST!!!*

[@ichbindummwaasduauch6358]

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

[@nottokyo1401]

In stead of saving the file, click the UPDATE button in the top left cornor of the window, then you'll get a window where you can click execute query, your table will be added to your database ;)

[@OwlYaRlyRUS]

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?

[@KiKus121]

I love u man, thank u :)

[@simobl8277]

this helped me thank you bro

[@lehlohonolomotloung1167]

This was pretty helpful. Thanks a mill

[@devmanav6808]

Thanks Lot very helpful keep it up !!!

[@Oom_Sakkie]

god bless you and your voice

[@IamRamishka]

Thank You Sir....!!!!

[@MajidAliRN]

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.

[@CodAffection]

thanks for the info . hope you found this C# tutorial helpful.

[@MajidAliRN]

@@CodAffection yes sir, your turorial has helped me a lot. Thank you so much !

[@mpumelelosicelomthethwa4635]

Thanks alot man, very useful!!

[@CodAffection]

:)

[@bomb4ik]

Thank you

[@gaborkosa263]

sir! thank you!its works fine!

[@lucasbraga8569]

You helped me a lot. Thank you!

[@CodAffection]

you are welcome.

[@leedenbigh]

Thank you very much for this.

[@JulianPrithiviraj]

very useful thanks a lot

[@sheivongamboa]

Use secure procedure is better than leaving open SQL query string

[@JStream]

this still works until now :D

[@chaitu_ash7600]

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

[@CodAffection]

sorry, I didn't get you.

[@rohithiwale3750]

Thank you For helping Others!!!!!!

[@gizachewadane6262]

Thank you it has Great tutorial

[@Rebelvlog07]

nice uploade more video related windows form

[@gandhidhamcomputers9664]

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

[@CodAffection]

Glad you found the video helpful.

[@ksktamiltech4130]

@@CodAffectionua-cam.com/video/VuAblmhisxc/v-deo.html

[@mohinisonawane991]

Thank you so much very helpful :-)

[@CodAffection]

thanks for the comment.

[@a1994s]

thanks a million bro.

[@techsics5456]

Thanks a lot❤️❤️❤️❤️

[@akshaygadilkar8994]

Sir you are the best

[@CodAffection]

My Pleasure, Happy Coding

[@blacksmith9259]

thank you very very mutch
God Bless You

[@bagup_alpharetards]

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.

[@CyberKittenlol]

I think i have the same problem too. I first save a place where in your drive then in the upper-left corner of the Table Designer, select the Update button.
Then you save it I think(because im trying

[@RadhaKrishna_777]

😍😇 thnk U sO mUch sir !!

[@atluong6236]

Great. Thanks so much :D

[@CodAffection]

you are welcome

[@PatrosAnime]

7:58 when i clicked new table an error occured called : "An incompatible SQL server version was detected "
What should i do man?

[@CodAffection]

Have you tried this : stackoverflow.com/a/27881800/4133590

[@farahsghaier9891]

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.

[@Killermonktr]

im stuck there aswell, hope u found an answer after a year xD

[@bandaraharan9018]

It works, Thank you

[@rw12player39]

nice tutorial

[@jmdeluxe]

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

[@kotoriitsuka1097]

8:36 could you explain what do you say there?

[@CodAffection]

Showing how to save the table
Press Ctrl + S to Save the Table. it will open a dialog box, Name your table inside the dialog box, then click OK.
Then added sample record into the table.

[@kotoriitsuka1097]

Thank you for fast answer. I appreciate all work that you put into your videos. It is very helpful. Thank you! :)

[@truebittech]

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

[@timeforqbing3247]

same thing(((

[@manpreetjohal9033]

You are awesome. This is so helpful.
How can i get a report that what user at what time/date logged in and logged out?
Thank you :)

[@CodAffection]

I am glad you found the video useful.
Get Logged In and Out Time
- Add two additional column of the type date time one for logintime and logouttime
- During Login Insert DateTime.Now to logintime
- During Logout Update Current User Last Row - logouttime with DateTime.Now

[@manpreetjohal9033]

Dotnet Mob Thanks for you reply.
Where would that log file go once i completed compiling the program.
Thank you

[@CodAffection]

Not a separate file. I mean add two columns in tblUser table. for logintime and logout.
Or You can keep a separate table - tblUserAudit to store login time and logout time.

[@manpreetjohal9033]

Dotnet Mob Thank you :)

[@CodAffection]

You are welcome

[@Hearte12356]

Thank you very much !!!!

[@CodAffection]

you are welcome.

[@rehanfarooq1122]

thanks for this video bro

[@HANIFASATTAR]

Very nice person

[@harikrishnants8545]

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.

[@hackslash834]

Don't know if you figured it out or not but I will leave this here for anyone with the same problem. There is an update button at the top of the table you can click on. It will then save it on the existing mdf file. Under the table there is a sql query on that you can edit your table. Make changes here. To see the change or whether your table is created or not you have to rightclick the table folder on the database connection and refresh.

[@karthiknayak5632]

@@hackslash834 ya i fixed the issue thanks for the comment.

[@CodAffection]

thanks for sharing your thoughts.

[@teach2088]

thanks bruda

[@deepikakbify]

Thanks!

[@spikeisback]

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.'

[@CodAffection]

try this stackoverflow.com/a/14779107/4133590

[@SamMeiki]

Thank you!!!!!

[@abdelkiki]

Thank you si much

[@feeqqaa]

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~!

[@CodAffection]

did you check with break points?

[@feeqqaa]

CodAffection sorry, but how do I do that?

[@CodAffection]

ua-cam.com/video/FKAOHtxiloA/v-deo.html

[@sahejnarang8911]

thanks bro

[@ВалентинаВеремчук-и6у]

thanks a lot :)

[@Sajidhussain302]

so sweet

[@salikomarpatug7024]

Life saver

[@乔治高老庄]

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

[@jesvirsubang6725]

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

[@jeremychu8922]

you need the database varible and in textlabel script
label.text = "varible"

[@mihaelborak78]

@Dotnet Mob Hello i need help ! Every time i press login this shows up : Unhandled exception has occurred in your application...... Incorrect syntax near the keyword 'Table' pls help fast cuz i need 2 finish this project in 3 weaks and your tutorials helped me so far

[@CodAffection]

Let me see your query for login operation.

[@Unreality_3D]

@@CodAffection Hi i have the same problem, my login table is just called Table, also im using VS 2017,
The Error...
System.Data.SqlClient.SqlException
HResult=0x80131904
Message=Incorrect syntax near the keyword 'Table'.
Source=.Net SqlClient Data Provider
StackTrace:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at WindowsFormsApp6.loginFrm.loginBtn_Click(Object sender, EventArgs e) in C:\Users\Gary\source
epos\WindowsFormsApp6\WindowsFormsApp6\Form1.cs:line 28
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.Run(Form mainForm)
at WindowsFormsApp6.Program.Main() in C:\Users\User\source
epos\WindowsFormsApp6\WindowsFormsApp6\Program.cs:line 19
My Code...
SqlConnection sqlcon = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\User\source
epos\WindowsFormsApp6\WindowsFormsApp6\Database\LoginData.mdf;Integrated Security=True;Connect Timeout=30");
string query = "Select * From Table where username ='" + usernameTxt.Text.Trim() + "' and password = '" + passwordTxt.Text.Trim() + "'";
SqlDataAdapter sda = new SqlDataAdapter(query, sqlcon);
DataTable dtbl = new DataTable();
sda.Fill(dtbl);
if (dtbl.Rows.Count > 0 && dtbl.Rows[0][0].ToString().Equals("1"));
{
mainFrm objMainFrm = new mainFrm();
this.Hide();
objMainFrm.Show();
}
Thanks for the video i really needed this.

[@nguyenhoanghuy8456]

Good

[@jaydipgadhiya2265]

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

[@teamfired3843]

same

[@MuhammadHammad-jj8pe]

Iam using vs 2017 but when i ctrl + s to name the table it doesnt open any dialog box and takes me to save it and not showing it in tables ?
Can you help me out

[@bunyipimaboy5715]

same thing happens to me

[@lovehunter8278]

You may try to save it under the db location and refresh table

[@kshitijbali6915]

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

[@HichamBLM]

Merci 🙂

[@daniealasyraf9129]

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.'

[@CodAffection]

did you download the source code ?

[@daniealasyraf9129]

Yes... can you teach me how to enter RC4 encryption for the password?

[@programmer313]

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?

[@Vapsiz]

this li- HMHHM
16:06

[@trok1]

Lol that load

[@user-tf7te5fs2n]

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

[@justinromaine3493]

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.

[@CodAffection]

you want to connect Live SQL Server Database ?

[@Ivan-tb1cw]

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.

[@Ethan-rv1jr]

When he cleared his throat my ears were gone
zooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooom

[@Sajidhussain302]

clear e he bhai

[@algorithms2289]

You must write "tblLogin" between [ ] otherwise it cause error sometimes

[@CodAffection]

I don't think so. you have to enclose sql object inside '[ ]' if it contains a space or reserved terms like 'User'. Otherwise it is not necessary. thanks for the comment.

[@algorithms2289]

Dotnet Mob
welcome,
but I try this code without [ ] this caused an error, then I fixed it by write this brackets.

[@mryan5522]

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?

[@abigailpartis392]

I know others have asked, but i cant see the replies. I have an error on the sda.Fill(dtbl), I'm told "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)" Any tips on how to fix this?

[@CodAffection]

ping me at [e-mail] with possible screen shots.

[@abigailpartis392]

Dotnet Mob thank you but I figured it out. Daft mistake on my part 😂😂 thanks for the tutorial. Subbed.

[@azizkarami5067]

@Abigail Partis i got the same error can u help me ??

[@CodAffection]

please check your connection string.

[@yvonne981228ahvon]

i have the problem on sda.Fill(dtbl); , how to solve this problem

[@imabik2378]

Has anyone found the solution to this problem if so please reply asap

[@kelvinescitnal6223]

you dont have a conection in your form 2

[@scrub2657]

and how do you fix this?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ty :)

[@CodAffection]

@@scrub2657 Please check db connection string and query string.
If nothing works leave a message in fb page. let me check what I can do.

[@singhpranshu3]

@@CodAffection everything is fine. Just,
sda.Fill(dtb1);
is error

[@n3odemencial30]

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

[@renzguinto125]

A network related or instance specific error occured while establishing a connection to sql server. the server was no found or was not accessible. verify that the instance name is correct and that sql server is configured to allow remote connections. proivder sql network interfaces, error 26 error locating server/. instance specified
I'm getting this problem in adding connection can you help me?

[@CodAffection]

please SQL server connection string.

[@renzguinto125]

Already fix this thank you i just downloaded the sql server

[@renzguinto125]

can you help me i want to make my button to add number on text box example if i click the button there will be value in text box
EXAMPLE: clicked the button textbox value = 1
clicked the button for the second time the value of textbox 1 will be 2 and so on

[@CodAffection]

If Textbox = txt , Button = btn, (Control Naming)
txt.Text =(Convert.ToInt32(txt .Text)+ 1).ToString();

[@fadestutorials106]

can you do a video on how to do a multi user login

[@averageanon007]

do you still have the "Do not delete" folder in C:/ drive? :p

[@CodAffection]

no, now it 'can be deleted'.

[@knowsome3424]

Thanks