For those who are stuck at 10:10 and can't find the path: you need to go to Database Properties, but not the one on the right side of the screen, it's the one he's clicking at 6:15 . Pause at 6:15 and look at the right side of his screen, you can see "Connection String" , just copy and paste it. Thank you vor the video btw it really helped!
may i ask? where did you get this path " (@"Data Source=(LocalDB)/MSSQLLocalDB;AttachDBFilename=|DataDirectory|\Database1.mdf;Integrated Security=True")) "
Hey where did you get that " "@"Data Source=(LocalDB)..." On 10:07. I copied it and then run it. Log in was okay but the dashboard won't open and a pop up said "Exception Unhandled" plssss replyyy help me
@@Teacher_Ali Asslam-o-Alaikum Sir Please upload the video on this Topic with complete detail and source code I'm really thankful to you. You are so Brilliant and Good Teacher for me. Regard By: Ayaan Ansari from PAKISTAN
When users try to log into my program, this error appears 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Can you make a video on how to create a form which can be used to create logins. So that the username and password the user chooses gets added to the login database please
Sure I want to redo the whole login form, user creation form as well as main form in latest version of Visual Studio. Will try to get it uploaded asap.
This is a data source string you have to define to exactly point to the location of database file. Note that reference path is not absolute but relative.
private bool IsValid Severity Code Description Project File Line Suppression State Error CS0548 'Login.IsValid': property or indexer must have at least one accessor How to fix?!
my connection string isnt working, the part where it has the path to the file is in quotes and it ends the starting ones so the part where the path is ,is not in the quotes, tried jsut removing them but didnt work, tried leaving only the file name but didnt work , says it cant find the file, how do i fix it?
SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True") - Here "DataDirectory" is your current directory of project i.e. the same folder where you have your ".sln" solution file.
You have to share more info to offer a solution. However in the meanwhile have a look at this Stack-Overflow thread: stackoverflow.com/questions/33606833/cause-of-errorcs0161-not-all-code-paths-return-a-value
For those who are stuck at 10:10 and can't find the path: you need to go to Database Properties, but not the one on the right side of the screen, it's the one he's clicking at 6:15 . Pause at 6:15 and look at the right side of his screen, you can see "Connection String" , just copy and paste it. Thank you vor the video btw it really helped!
thankss bro i was stuck here :)
Do we need to install any local Database like SQL Server for this to work?
10:10 You don't explain anything, by copying and changing name of the database it isn't working.
Thank you ❤
Thanks dude! you deserve a sub and a like
Thanks for kind words. Keeps me motivated.
Super helpful!! Thank you!
Much appreciated. Glad it was helpful.
Hey there, @Teacher_ali I need help with the txtusername part. May I get help ASAP, thank you I learned a lot of this video.
may i ask?
where did you get this path " (@"Data Source=(LocalDB)/MSSQLLocalDB;AttachDBFilename=|DataDirectory|\Database1.mdf;Integrated Security=True")) "
Right click on your database.mdf -> go to property-> there you will find connection string. Copy whole connection string
is posible to use PostrgeSQL for .net application ?
Do we need to install any local Database like SQL Server for this to work?
Yes we need SQLServer LocalDB
do you know how to change the name of the application? like in taskbar it is called Form1 but in file explorer its different
System.InvalidOperationException: 'The SelectCommand property has not been initialized before calling 'Fill'.'
PLEASE HELP!
I have a problem, can you help me?
Hey where did you get that " "@"Data Source=(LocalDB)..." On 10:07. I copied it and then run it. Log in was okay but the dashboard won't open and a pop up said "Exception Unhandled" plssss replyyy help me
This is location of your database. Your LocalDB database source. You can search your path with your DB name as well to find exaction location.
how do you get the user which is signed in as a string?
This is "Username" variable and should refer your connected database.
i coppied but dont worked, can you make a pastebin or something to copy it?
so in here at 0:45 i don't have the form (windows form) how can i find this?
An exception occurred which says 'No process is on the other end of the pipe'. Please help
is that possible when i click login it navigate to my google account?
Yes sure but you need to have knowledge of APIs and need to connect to Google API for that.
@@Teacher_Ali Asslam-o-Alaikum Sir Please upload the video on this Topic with complete detail and source code I'm really thankful to you. You are so Brilliant and Good Teacher for me.
Regard By: Ayaan Ansari from PAKISTAN
How did u declare the query bro
When users try to log into my program, this error appears
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
You need to have SQLServer LocalDB installed. Program won't run without SQL server on the local machine.
@@Teacher_Ali Did you mean I have to have LocalDB installed on my computer or on all of my clients' computers?
@@croowwz Yes anywhere you use it you need to have LocalDB installed.
@@Teacher_Ali I have to install it on all my clients' computers??
@@Teacher_Ali Will this work as a remote connection Data Source=DESKTOP-HMJHK87\\CROWZ;Initial Catalog=loginForm;Integrated Security=true
final solution? r-right adolf
I need some help.
System.Data.SqlClient.SqlException: 'Invalid column name
Can I use this for sign up/registration?
Yes you can modify as you like with any number of fields.
@@Teacher_Ali Thank you!
Can you make a video on how to create a form which can be used to create logins. So that the username and password the user chooses gets added to the login database please
Sure I want to redo the whole login form, user creation form as well as main form in latest version of Visual Studio. Will try to get it uploaded asap.
Where I have typed string query it is saying invalid initializer member declaration and SQLConnection does not contain a definition for query
Please could you help
It is line 32 on you tutorial code
u didnt do a good job on how to generate the string so I cant seem to get it right
Tnks Teacher So How To You Give Me The Cod
My service based database not workinggg
what if i have to add background image to this form??
You can use "BackgroundImage" property of form object.
bro what keys did you press at 6:51
Nevermind you clicked update
Where do you get the code 10:10?
This is a data source string you have to define to exactly point to the location of database file. Note that reference path is not absolute but relative.
private bool IsValid
Severity Code Description Project File Line Suppression State
Error CS0548 'Login.IsValid': property or indexer must have at least one accessor
How to fix?!
private bool isValid()
@@findnixx thank you.
THE HELL I TOOK 5 HOURS AND YOU DID NOT EXPLANE THE DATABASE COPY AND PASTE
what did she paste 10:09 ??
NOBODY KNOW
yuo plet connection string, go to your dB and click properties
@@august6943 where is connection string bro help
@Haider Ali She got it at going to the DataBase and clicking modify connection then advanced then at the bottom the long thing of stuff
@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDBFilename=|DataDirectory|\Login.mdf;Integrated Security=True" inside the brackets
What to do if I want to show the second window after login at exact same position where first form was, what to do?
Set position of new form exactly same as login form and just display it.
A lot of missed points
not a bad video but man the music is god awful!
loil
Creepy sound
Make better vids
Thanks. Any suggestions are welcome.
my connection string isnt working, the part where it has the path to the file is in quotes and it ends the starting ones so the part where the path is ,is not in the quotes, tried jsut removing them but didnt work, tried leaving only the file name but didnt work , says it cant find the file, how do i fix it?
SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True") - Here "DataDirectory" is your current directory of project i.e. the same folder where you have your ".sln" solution file.
Error CS0161 'LoginForm2.isValid()': not all code paths return a value PLEASE HELP!
You have to share more info to offer a solution. However in the meanwhile have a look at this Stack-Overflow thread: stackoverflow.com/questions/33606833/cause-of-errorcs0161-not-all-code-paths-return-a-value