Create a C# Application from Start to Finish - Complete Course
video description
Date: 2022-03-14
Related videos
Comments and reviews: 10
Erzs-bet
Hi Tim! Your tutorial is fantastic, you are a really good teacher. Most of the time I am able to follow what happens on the screen (even though I am a beginner) and I have managed to create my SQL tables and the stored procedures. The majority of the stored procedures had very obvious names, and I understood the concept that these SQL commands connect the tables by using id-s, so I was able to create them by checking the first example and using my Database Diagram. But I got stuck when I tried to create the spPeople_GetAll and spTournaments_GetAll procedures.
I got two questions for you (or anybody, who has already completed the course):
1, I assume that the People_GetAll procedure would use the PersonId value to insert all the information from People table INTO TeamMembers table (since this is the only connection the People table has). Is this correct, or I have misunderstood something?
2, How should I set the parameters for spTournaments_GetAll? Again, I assume that I need to use TournamentId to connect with the Matchups, TournamentEntries and TournamentPrizes tables (since they all contain the TournamentId value). Should I create multiple inner joins? I don't know much about SQL and I would really appreciate some advice because I am clueless right know... :(
reply
Hi Tim! Your tutorial is fantastic, you are a really good teacher. Most of the time I am able to follow what happens on the screen (even though I am a beginner) and I have managed to create my SQL tables and the stored procedures. The majority of the stored procedures had very obvious names, and I understood the concept that these SQL commands connect the tables by using id-s, so I was able to create them by checking the first example and using my Database Diagram. But I got stuck when I tried to create the spPeople_GetAll and spTournaments_GetAll procedures.
I got two questions for you (or anybody, who has already completed the course):
1, I assume that the People_GetAll procedure would use the PersonId value to insert all the information from People table INTO TeamMembers table (since this is the only connection the People table has). Is this correct, or I have misunderstood something?
2, How should I set the parameters for spTournaments_GetAll? Again, I assume that I need to use TournamentId to connect with the Matchups, TournamentEntries and TournamentPrizes tables (since they all contain the TournamentId value). Should I create multiple inner joins? I don't know much about SQL and I would really appreciate some advice because I am clueless right know... :(
reply
FreeER
Wait is this a 24 hour video? Wow that's more than I was expecting and I thank you for it! I doubt it's trivial just to compile this into one let alone create the content. Also thanks again lol been trying to find something that's not just -here's how to do variables and oh there's a paywall at COMMENTS- since I already have amateur experience with C, Lua etc. and just kinda need a walkthrough of some real programming to gets better feel for the language\libraries.
Also glad I finally figured out how to use JavaScript on mobile to speed up YouTube to 3.5x since I'm currently without a desktop that has easy browser extensions for it lol 8 hours is much more reasonable than 24 or even 12.
reply
Wait is this a 24 hour video? Wow that's more than I was expecting and I thank you for it! I doubt it's trivial just to compile this into one let alone create the content. Also thanks again lol been trying to find something that's not just -here's how to do variables and oh there's a paywall at COMMENTS- since I already have amateur experience with C, Lua etc. and just kinda need a walkthrough of some real programming to gets better feel for the language\libraries.
Also glad I finally figured out how to use JavaScript on mobile to speed up YouTube to 3.5x since I'm currently without a desktop that has easy browser extensions for it lol 8 hours is much more reasonable than 24 or even 12.
reply
Rippitup8
Love the tutorial so far. Im following along on VS and taking notes.. Ive got to 4 and a half hours so far and just thought id leave a comment as ive just gotten past a part where you say 'its fine to be a bit lost and to think its a little confusing, we're not doing 'hello world', its a difficult tutorial so just because you find it hard doesnt mean youre not going to be a programmer. keep going and i know i can get you through this!'... there are loads of parts ive had to rewatch a handfull of times and its easy to get downhearted so it was nice to hear a bit of encouragment, really made me feel more confident and motivated to stick with it. Thanks ;)
reply
Love the tutorial so far. Im following along on VS and taking notes.. Ive got to 4 and a half hours so far and just thought id leave a comment as ive just gotten past a part where you say 'its fine to be a bit lost and to think its a little confusing, we're not doing 'hello world', its a difficult tutorial so just because you find it hard doesnt mean youre not going to be a programmer. keep going and i know i can get you through this!'... there are loads of parts ive had to rewatch a handfull of times and its easy to get downhearted so it was nice to hear a bit of encouragment, really made me feel more confident and motivated to stick with it. Thanks ;)
reply
Batu
Hello Guys i need your help.
Im trying to follow along but there is a problem with referencing the library to the windows form app. Im at 4:57:44 ruffly. Does anyone know how to connect the Library to the Windows Form App on the 2022 Version?
I already tried to change the language version of the library, creating a package and i tried adding net472 to the target frameworks. It all failed.
Thanks in advance!
reply
Hello Guys i need your help.
Im trying to follow along but there is a problem with referencing the library to the windows form app. Im at 4:57:44 ruffly. Does anyone know how to connect the Library to the Windows Form App on the 2022 Version?
I already tried to change the language version of the library, creating a package and i tried adding net472 to the target frameworks. It all failed.
Thanks in advance!
reply
Risato
This is a brilliant video. I've been working as a programmer for about 2 years in Japan now but I am working in a team and just doing a programming so I haven't made any desltop system from the scratch by myself so I was wondering if I could get some knowledge from youtube video! This is exactly what I wanted to watch! It is a long video so I haven't finished watching this but I will continue watching!!!
reply
This is a brilliant video. I've been working as a programmer for about 2 years in Japan now but I am working in a team and just doing a programming so I haven't made any desltop system from the scratch by myself so I was wondering if I could get some knowledge from youtube video! This is exactly what I wanted to watch! It is a long video so I haven't finished watching this but I will continue watching!!!
reply
Monkey
How to access all the attributes of a trigger of task scheduler
I want to compare the values present in the trigger of a task, for e.g. months of year, days of week, which week these values need to be accessed in order to compare them. I can get to know whether the task is enable or not using Task.Definition.Triggers[0].Enabled, but How can I get months, which week and other details!?
reply
How to access all the attributes of a trigger of task scheduler
I want to compare the values present in the trigger of a task, for e.g. months of year, days of week, which week these values need to be accessed in order to compare them. I can get to know whether the task is enable or not using Task.Definition.Triggers[0].Enabled, but How can I get months, which week and other details!?
reply
I'm
I know that this tut focuses more on how to achieve the output but in my own opinion it would be better to use switch statement at this part 5:15:13, I think it isnt hard to explain its concept. I dont know if its just me but I really hate looking at methods that are filled with if statements. I dont know it feels so wrong to me, maybe because of my game developer perspective
reply
I know that this tut focuses more on how to achieve the output but in my own opinion it would be better to use switch statement at this part 5:15:13, I think it isnt hard to explain its concept. I dont know if its just me but I really hate looking at methods that are filled with if statements. I dont know it feels so wrong to me, maybe because of my game developer perspective
reply
Magic
If you are doing this in visual studio 2022 there is a chance that you will get an error complaining about -SqlClient- upon opening the connection to your database, if this is the case then simply go to Project >Manage NuGet Packages and than search for -System.Data.SqlClient-, install it and everything should be good.
reply
If you are doing this in visual studio 2022 there is a chance that you will get an error complaining about -SqlClient- upon opening the connection to your database, if this is the case then simply go to Project >Manage NuGet Packages and than search for -System.Data.SqlClient-, install it and everything should be good.
reply
Jeff
I have in the past when trying to sync data locally to a database. Used a flag if it has synced to database. When you sync the database just update the file with the record id. I am curious if you considered that but opted to not do that. Was it the fact that managing 2 id fields on the local file seemed problematic?
reply
I have in the past when trying to sync data locally to a database. Used a flag if it has synced to database. When you sync the database just update the file with the record id. I am curious if you considered that but opted to not do that. Was it the fact that managing 2 id fields on the local file seemed problematic?
reply
Mohamadnour
Thanks for this great course . in section 8 of SQL there are no steps how to build the tables and how to write the stored procedure. the table it can be mange by looking to the diagram but what about the second part ??? it will be use during the course or it is an additional part for the database.
reply
Thanks for this great course . in section 8 of SQL there are no steps how to build the tables and how to write the stored procedure. the table it can be mange by looking to the diagram but what about the second part ??? it will be use during the course or it is an additional part for the database.
reply
Add a review, comment
Other channel videos
