You can get a ton more projects by changing the 'spring07' to variations of spring and fall. Example: spring08, fall06, etc. The course has recently switched to teaching Python so anything past 08-09 won't give you any C projects. The C projects are in a reasonable order, so if you start with the first project and work your way up, you'll learn a lot. If you start with a project in the middle or at the end you probably won't be able to do it as they gradually introduce new topics such as pointers and memory management. The resources on that link under 'lectures' introduce all of the topics you need to know in order to complete the projects, and you can supplement them by using google.
Dim Adapter As New OleDbDataAdapter
Dim Command As New OleDbCommand
Dim xFrom As String = dtpFrom.Value.ToString.Substring(0, dtpFrom.Value.ToString.IndexOf(" "))
Dim xTo As String = dtpTo.Value.ToString.Substring(0, dtpTo.Value.ToString.IndexOf(" "))
sqlQuery = MainQuery ...