O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Learn C# With Windows Forms and SQL Server

Video Description

With a real database project!

About This Video

  • Learn more about C# and basic fundamentals, create projects and database.

In Detail

Microsoft C# remains one of the most popular programming languages today. In this course, you get an introduction to the language, using code and graphical windows. This course uses Microsoft Visual Studio 2015 Community. You'll learn about graphical objects like text boxes, radio buttons, dropdowns, and numerous programming features like loops and variables, and many others. The video lessons are on average about 10 minutes long. This course is definitely best for those who are patient. Before purchasing please be sure to review the curriculum carefully so you can be 100% sure this is the right course for you. On the bottom is a fairly complete database project, illustrating advanced coding techniques. Each video is in HD, and project files can be downloaded from GitHub. The link needed is stored under lesson resources. Thank you for reading, and let's get coding!

Table of Contents

  1. Chapter 1 : Learn C# With Windows Forms and SQL Server
    1. Course overview 00:02:11
  2. Chapter 2 : Learning the fundamentals
    1. Create and run the first program 00:06:30
    2. Display a message with a label 00:09:02
    3. Creating and using a single variable 00:09:55
    4. Describing objects with multiple data types 00:10:36
    5. Reading input, applying methods, and producing output 00:08:28
    6. Reading, converting and displaying values 00:08:11
    7. Doing practical math on two variables 00:11:15
    8. Representing unchanging quantities with constants 00:11:47
    9. General Visual Studio usage tips 00:06:43
  3. Chapter 3 : Controlling program flow
    1. Using if/else blocks with check boxes 00:05:56
    2. Using if/else blocks with strings and methods 00:10:13
    3. Changing variable values using "x++" and "++x", Part 1 00:07:54
    4. Changing variable values using "x++" and "++x", Part 2 00:09:11
    5. Printing 1,2,3,4,5 with while loops and radio buttons, Part 1 00:10:27
    6. Printing 5,4,3,2,1 with while loops and radio buttons, Part 2 00:05:25
    7. Updating progress bars with for loops 00:09:19
    8. Iterating over collections with foreach loops, Part 1 00:10:12
    9. Iterating over collections with foreach loops, Part 2 00:05:24
    10. Using the ternary operator, Part 1 00:07:35
    11. Using the ternary operator, Part 2 00:11:34
    12. Creating more stable programs with TryParse 00:11:45
  4. Chapter 4 : Operators
    1. Operators that evaluate and assign in place 00:07:21
    2. Checking two conditions with the logical and operator 00:10:06
    3. Checking two conditions with the logical or operator 00:11:16
    4. Combining logical operators to express more complex logic 00:09:01
    5. Making decisions with switch blocks and methods, Part 1 00:12:51
  5. Chapter 5 : Methods and arrays
    1. Making decisions with switch blocks and methods, Part 2 00:13:26
    2. Create a static class for storing utility methods, Part 1 00:09:51
    3. Create a static class for storing utility methods, Part 2 00:08:46
    4. Folder browser project with arrays, Step 1 00:09:16
    5. Folder browser project with arrays, Step 2 00:08:01
    6. Datagrid view control project with loops, Step 1 00:12:56
    7. Datagrid view control project with loops, Step 2 00:05:55
    8. Using lists and out keyword, Part 1 00:13:04
    9. Using lists and out keyword, Part 2 00:12:41
    10. Making use of the Split method with params 00:09:39
    11. Using Linq methods, Part 1 00:08:11
    12. Using Linq methods, Part 2 00:10:55
  6. Chapter 6 : Creating, Saving, Reading, Previewing And Printing Files
    1. Create the interface and add ability to save file 00:11:31
    2. Add the ability to read files and prevent crashes 00:09:33
    3. Add menu items that allow locating and highlighting a word 00:11:44
    4. Add features to change font, preview and print 00:06:55
    5. Add professional printing to printers and files 00:10:29
    6. Break from programming: High level overview of the many pieces of a project 00:12:49
  7. Chapter 7 : Database Project
    1. Get SQL Server 2014 with management console 00:04:58
    2. Install SQL Server 2014 00:03:58
    3. Make the database to be used with the project 00:11:16
    4. Create the main form and the business forms 00:08:23
    5. Add interface components to the business contacts form 00:06:25
    6. Create the database model 00:07:45
    7. Write code to connect to the database 00:12:57
    8. Write code to save new records 00:16:54
    9. Write code to edit existing records 00:11:08
    10. Write code to delete existing records 00:16:12
    11. Write code to search for records 00:08:56
    12. Write code to save images, Part 1 00:10:11
    13. Write code to save images, Part 2 00:08:57
    14. Exporting the project as an installable file 00:06:32
    15. Add ability to export records to Excel 00:17:45
    16. Add ability to export records to text files 00:07:49
    17. Add ability to export data to Microsoft Word 00:17:23
  8. Chapter 8 : Miscellaneous
    1. Download files synchronously and asynchronously 00:11:37
    2. Image viewer project 00:19:03
    3. File copier project, Part 1 00:11:51
    4. File copier project, Part 2 00:13:12