C# App Start To Finish Lesson 14 - Create Team Form Part 3

Check out this video to see how we are going to build a complete application from start to finish in C#. Using .NET and Visual Studio, we will construct an application that is fit to launch. The application will use Winforms, a class library, events, SQL database, text file data storage (in CSV format), custom events and more. This is a 25-hour course that will allow you to follow along as I build an entire application, all for free!

[arnoldhattingh]

If more people find this video series, you will be a youtube sensation in no time. Congrats on 10k. Best series on the net!!!

[gabrielsonoflight]

Hello from a brazilian-portuguese guy in Portugal, Tim! And thank you very much!

[DrowninGGaming]

"I always seem to get it wrong, except for when I don't and then I question myself" - Quotes to live by!

[lucio]

2 years ago there were 10K subs, now we are almost 100K. Great work, Tim!

[Empathies]

I also noticed the bug in the ConverToTeamModels method
now I'm kinda proud of myself that I already noticed this before it was mentioned in the video ^^

Aside from that I'm absolutely loving this tutorial series! So many side-notes that really improve efficiency.
I'm hoping to finish this course very soon so I can start a project of my own with the skills I'm learning from you!

[DrowninGGaming]

Hey Tim, i'm not sure if this has been picked up on in future lectures, but I noticed during the testing of the TextFile portion of the lecture that my TeamModels.csv would only store 1 team and whenever I tried to add another team it would simple overwrite the first team (I tested the SQL saving and that worked fine, so I turned my attention to the TextFile section and I remembered from previous lectures that the when writing the text files we basically get the existing information, and from there create a new text file with the new lines and overwrite the old file).
 
So after a bit of digging I realised that the output.Add(t); wasn't added to the foreach(string line in lines) within the ConvertToTeamModels method, after adding this my text file now adds teams fine.

[lalofuentes]

Hi Tim, this is the best ever course I have followed on the Internet about a programming language. It was not easy to find, but so far is really fulfilling my expectations. It's exactly what I was looking for, a real example from 0 to end, step by step. Better yet, every subject is very well explained. I used to program in structured languages many years ago and this lockdown has driven me to look for something I had postponed for so long.


Congratulations Tim, keep up with the good work!!

[cameronwildey]

I may be missing something but, why do you not have to place output.Add(t); in the ConvertToTeamModels method?

[brad]

Damn, Tim. You are one smart dude. Thanks for this. I can't wait to finish the project up by following along then I can check out all your other vids.

[KevMcWare]

Great course Tim, I'm playing catch-up. Maybe some validation on an empty Team Name? Bet you cover it later.

[rickomba]

Hi Tim, Just wondering whether at the end you will include a piece on packaging & deploying the application. If you hadn't considered it could you kindly include it.

[studentsheaven-dv]

Everytime I anticipate things and try to do it myself and guess what I'm wrong. A second later Tim explains it and my love for C# revives. After this I'm going to take the MySqL course inshaAllah.

[odaneb]

Hi Tim, for some reason when I create a new record in the People table, the Ids went from 1, 2 to 1002, 2002, 2003, etc. I am not sure which part of the code is setting this value increment and how it got misaligned. I am assuming that this is an issue with the SQL stored procedure, but just wondering if there are any suggestions to figure out where this issue is coming from. It doesn't break the application, but it's unexpected and not clean to have these Id values inserted. Thanks in advance!

[yossefelkilany]

It is a grace from Allah to have such amazing free content.
It really is MIND BLOWING. I don't know how to thank you the proper way. But, Thank You.

Real mentorship, experience, organization and fun!

[kemmrich]

Since I did the text file part for the create prizes and create people steps, I thought I would skip the text stuff from now on. Then I decided that I should just do it all and learn -- I am sure I will use text files at some point. Accidentally had
output = $"{p.Id}|"; when creating the team members delimited list. Took me quite a while to figure out I needed:
output += $"{p.Id}|"; (the plus sign!). I am learning how to use the visual studio debugger! Excellent so far. I figured I have to send some money your way. Probably will sign up for the MVC add-on for the TournamentTracker or maybe the weekly challenges (or both!) in the new year.

[NoGamer]

Hey Tim I'm revisiting your old course, just to have working app before i try mvc asp.net ui. And i wonder if i can use generics to do most of db work in 1 method. i did something like foreach (property in properties){p.Add(property.Name, property.GetValue(model, null));} and few more lines to get id and stuff and it mostly works for every model which we save as whole to db like person, prize etc.
But the question is can i make my life easy with methods like 13:20 where we save into tables that connect our data like teamMembers table. Or maybe this isn't even possible cause that method don't even seem to be possibly generic?

[huzaifatinwala]

Would be lying if I said I didn't get lost a couple of times during that video.
But stuck it out somehow :)
Great video, Tim.

[karendoran]

I don't think anything was getting added to the output list? Should we put output.add(t) after the first foreach loop?

[yangryu]

46:41 wouldn't it be better to save team Id instead of team name to stay the same format as the sql datasabe?
Cause in sql it's 1, 1, 1 but in textfile its 1, teamname, 1. Isnt it better to stay sync? Also on the sql database side there are two tables but in textfile database theres just 1csv file, making it kinda confusing at first.

[Tiptup]

Tim, your videos are absolutely fantastic thank you for doing them. I'm going through a lot of them and reshaping and greatly enhancing what I learned myself when I was in high school and boy the good practices and slow detailed explainations are massively helpful.

I have a question and I know this is an old video, for the last method you implemented you did it as a normal function passing in the List<Person model>, I'm wondering why you didn't implement it as an extension method, specifically the List<PersonModel>).

Thanks!