Learn C# With Windows Forms and SQL Server

With a real database project!

Created byT O

Last updated 7/2021

English

What you'll learn

Create and runs Windows Forms applications
Understand blocks of code, curly braces, comments
Understand how to use string interpolation, and add new line characters
Understand how to represent changing quantities with variables
Understand how to use += and = operators
Create and use objects like labels and their properties like Text
Explain the meaning of a keyword
Use several different data types like boolean, decimal, string and others
Understand methods and how to use method chaining
Use methods that convert values to numerical form for mathematical operations
Read and operate on decimal data types
Round calculation results and display formatted output
Understand how to control the order of operations for mathematical symbols
Control the layout of various control on a form
Learn how to work with rich text boxes, and place variables in the right place to achieve certain effects
Learn how to work with radio buttons, index variables and while loops that count up and count down
Learn how to use foreach loops to repeat blocks of code
Learn how to combine loops and if blocks to create powerful code
Learn how to work with combo boxes, and the ternary operator to make decisions
Learn about operators, operands, and how to combine them properly
Learn how logical conditions are used to perform a variety of checks on operands
Use the TryParse method to create stable applications that do not crash
Use the Date time constructs to read and produce dates in a variety of formats
Use various compound operators like /=, -= and the trackbar control
Use date time pickers, and date time objects to make decisions
Learn how to use tool tips, switch blocks, check list boxes
Create methods using traditional and expression bodied member notation
Understand the concept of a parameter and a return value
Understand how to work with numeric up/down controls, and class files
Understand how the private and public access modifiers matter and why static classes are needed
Work with folder browsers, control enabling and disabling
Learn how to use arrays, directories and foreach loops with arrays
Understand how to work with collections and the datagridview control
Work with lists to find the maximum, minimum, average and sum of list entries
Work with arrays and convert arrays to lists
Learn how to use the out keyword to create methods that can set multiple values so the methods are more useful
Learn how to save files, and use try/catch blocks to create stable code
Learn how to open files, and work with menu strips
Learn how to search for, highlight and replace text
Learn how to use font boxes, print preview controls and add ability to print
Describe name spaces, classes, the major components of a Windows Forms project
Learn how to create multiple document interface programs with multiple layouts
Learn how to get and install SQL server and the management console
Learn how to work with different database types in SQL server
Learn how to use datagrid views, data adapters, data tables and basic SQL queries
Learn how to insert records into tables
Learn how different data types in SQL work
Learn how to use the using statement and parameters
Learn how to work with collections, binding sources, data updates
Learn how to perform searches of data
Learn how to save images and preview enlarged images
Learn how to work with microsoft excel in code
Learn how to export information from our program to excel using nested for loops
Learn how to write records to a text file
Learn how to export data to Microsoft word
Learn how to download and save internet files using different methods

Course content

11 sections • 79 lectures • 12h 35m total length

Course overview2:11
Lesson Objectives: Overview of the content of the course

Create and run the first program6:30
Lesson Objective: Create and run a Windows Forms application
Display a message with a label9:02
Lesson Objectives: Understanding how to use labels to display messages
Creating and using a single variable9:55
Lesson Objectives: Understand how to create, use and displays variables and their values
Describing objects with multiple data types10:36
Lesson Objectives: Understanding how to use several different data types to describe objects
Reading input, applying methods, and producing output8:28
Lesson Objectives: Understanding how to read input, process input and produce output
Reading, converting and displaying values8:11
Lesson Objective: Understanding how to read and produce numerical output
Doing practical math on two variables11:15
Lesson Objectives: Learn how to operate on multiple variables
Representing unchanging quantities with constants11:47
Lesson Objective: Understanding how to use constants to represent unchanging quantities
General Visual Studio usage tips6:43
Lesson Objectives: Learn about several different features of Visual Studio

Using if/else blocks with check boxes5:56
Lesson Objective: Creating and using if/else blocks with check boxes
Using if/else blocks with strings and methods10:13
Lesson Objective: Understand how to use if/else blocks with strings and methods like Contains
Changing variable values using "x++" and "++x", Part 17:54
Lesson Objective: This lesson shows how to build an interface with several parts, and how to place and display a variable for the first time when a form loads
Changing variable values using "x++" and "++x", Part 29:11
Lesson Objectives: Finish the project started in the last lesson on x++ and ++x
Printing 1,2,3,4,5 with while loops and radio buttons, Part 110:27
Lesson Objective: Create an interface and code a while loop carefully
Printing 5,4,3,2,1 with while loops and radio buttons, Part 25:25
Lesson Objective: Understanding how to run a while loop to show decreasing values
Updating progress bars with for loops9:19
Lesson Objectives: Learn how to use a for loop to fill a progress bar
Iterating over collections with foreach loops, Part 110:12
Lesson Objectives: Create an interface and code a foreach loop to repeat a task
Iterating over collections with foreach loops, Part 25:24
Lesson Objectives: Create another foreach loop to complete the project started previously
Using the ternary operator, Part 17:35
Lesson Objectives: Design the interface and add basic conversion functionality
Using the ternary operator, Part 211:34
Lesson Objectives: Finish the project started in the previous lesson
Creating more stable programs with TryParse11:45
Lesson Objective: Create more stable code with TryParse

Operators that evaluate and assign in place7:21
Lesson Objectives: Understand how to use the remainder operator in an application
Checking two conditions with the logical and operator10:06
Lesson Objective: Understanding how to use the logical and operator and multiple if/else blocks
Checking two conditions with the logical or operator11:16
Lesson Objectives: Understanding how to use the logical or operator to make a decision with a calendar control
Combining logical operators to express more complex logic9:01
Lesson Objectives: Create a program that can scan a textbox and pick out a variety of characters
Making decisions with switch blocks and methods, Part 112:51
Lesson Objectives: Creating a program that uses switch blocks

Making decisions with switch blocks and methods, Part 213:26
Lesson Objectives: Create a couple methods that accept and return values
Create a static class for storing utility methods, Part 19:51
Lesson Objectives: Creating a program that will use an external class file
Create a static class for storing utility methods, Part 28:46
Lesson Objectives:Finishing the program started in the previous program
Folder browser project with arrays, Step 19:16
Lesson Objectives: Learn how to create an interface with a folder browser
Folder browser project with arrays, Step 28:01
Lesson Objective: Use arrays and the Directory class to list files
Datagrid view control project with loops, Step 112:56
Lesson Objective: Make the interface and write the first version of the code
Datagrid view control project with loops, Step 25:55
Lesson Objective: Improve the code so the application does not crash
Using lists and out keyword, Part 113:04
Lesson Objectives: Create user interface and create code to summarize data
Using lists and out keyword, Part 212:41
Lesson Objectives: Create a static class file for holding the Summarize method
Making use of the Split method with params9:39
Lesson Objectives: Understand how to use the Split and ConvertAll methods
Using Linq methods, Part 18:11
Lesson Objectives: Build the interface and features to count words
Using Linq methods, Part 210:55
Lesson Objectives: Adding features that sort data

Create the interface and add ability to save files11:31
Lesson Objective: Build the interface and add features to save files
Add the ability to read files and prevent crashes9:33
Lesson Objectives: Creating the ability to open saved files and preventing crashes
Add menu items that allow locating and highlighting a word11:44
Lesson Objectives: Add code to search for, highlight and replace text
Add features to change font, preview and print12:49
Lesson Objectives: Add dialog boxes for previewing and printing documents
Add professional printing to printers and files6:55
Lesson Objectives: Add code to print to printers and files
Break from programming: High level overview of the many pieces of a project10:29
Lesson Objectives: Review the concepts of a name space, a class, a method and more

Get SQL Server 2014 with management console4:58
Lesson Objectives: Learn how to get SQL Server
Install SQL Server 20143:58
Lesson Objectives: Learn how to create the database to be used
Make the database to be used with the project11:16
Lesson Objectives: Create a script to make a table in SQL Server
Create the main form and the business forms8:23
Lesson Objectives: Understand how to create parent and child forms, and apply layouts
Add interface components to the business contacts form6:25
Learning Objectives: Add the business contacts user interface elements
Create the database model7:45
1. Add a connection to your database in the SQL Server Object Explorer
2. Add a LINQ to SQL Classes
3. Drag and drop connection to .dbml
4. Add a binding source. Binding sources provide data access to entire forms, not just one control.
Set binding source dataSource to AddressBook -> BizContact form
Write code to connect to the database12:57
Lesson Objectives: Write code to connect the program to the database in SQL Server
Write code to save new records16:54
Lesson Objectives: Save records from the form to the SQL Table
Write code to edit existing records11:08
Lesson Objectives: Learn how to edit existing records
Write code to delete existing records16:12
Lesson Objectives: Learn how to delete records
Write code to search for records8:56
Lesson Objectives: Learn how to combine a search box with Linq and a combo box
Write code to save images, Part 110:11
Lesson Objectives: Write code to enable image saving and retrieval
Write code to save images, Part 28:57
Lesson Objectives: Add image previews and catch errors when saving images
Exporting the project as an installable file6:32
Lesson Objectives: Make a couple small changes to the code and confirm features work
Add ability to export to excel, updated 8/3/202021:08
Add ability to export records to text files7:49
Lesson Objectives: Add code to write records to a text file
Add ability to export data to Microsoft Word17:23
Lesson Objectives: Print the data grid view to Work
Making SQL Server keep the ID sequential using Identity_Cache7:41
Update to working with @ in the parameter names, 8/2/202010:50

Requirements

Students must have Visual Studio Community 2015 Downloaded and Installed
Please be sure to read the curriclum before enrolling so you can feel confident this course meets your needs.
Please watch the free preview videos to be sure my style of presentation agrees with your learning style.

Description

Update

8/3/2020: Replaced video 60 on exporting to Excel to clarify or improve some subtle technical details.

8/8/2020: Added video 63 on how to work with the identity_cache in SQL Server to avoid identity gaps

Thank you for stopping by.

Most important: Before enrolling, please take the time to read the course curriculum, and watch the free preview videos so you can be sure my way of presenting information is one that truly works for you. This will give you a strong indication of what to expect throughout the course. Please kindly do not enroll until you have done this. Also, please remember that I am only one person, and I cannot as one person think of everything that you might want covered. If that's the case, please send me a message and tell me what you feel should be added. Thank you.

Lessons 2-39: Introduction to C# as a review for those who are new to programming in C# or are coming from a different language.
1. This is not meant to be exhaustive but to simply prepare you for the database project.
2. It's a review of basic programming concepts.
Lessons 40-45: Text editor project to illustrate more advanced coding.
1. This project show more practical applications of C#.
Lessons 46-62: Variety of advanced techniques used in building a database project.
1. Here you learn how to combine C# and SQL Server.
2. The code in these lessons gets quite sophisticated.
3. Make sure you have MS Office installed for this part or you will not be able to complete the project.
4. If you're going to use the code as saved on GitHub for this part, it will be more challenging to configure than the code for the simple lessons.
5. Make sure you look under lesson resources when you do this project. There are updates stored there.
Lessons 63-66: Miscellaneous small projects that show a variety of possibilities with C#.

It's important that you type and run all the code, as I do. To take it one step further, simply ask and answer this question: how can I make one meaningful modification to the code to produce a new effect? Consistently asking and answering this question as you watch the videos will allow you to improve your skills beyond what I show you.

Please note I develop the material at a relatively leisurely rate, so if I speak too slowly, please watch the videos at 1.25x.

I'm the author of "Beginning C# Hands-On The Core Language" and "C# Hands-On The Advanced Features", both from PACKT.

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!

Parts of promo video PowerPoint licensed from PresenterMedia.

Who this course is for:

This is a good course for those who want to learn C# through Windows Forms.
This is not a course for those who want to learn C# through Console Applications
This is a course for those interested in database projects.

Learn C# With Windows Forms and SQL Server

What you'll learn

Explore related topics

Course content

How does this course work1 lecture • 2min

Learning the fundamentals9 lectures • 1hr 22min

Controlling program flow12 lectures • 1hr 45min

Operators5 lectures • 51min

Methods and arrays12 lectures • 2hr 3min

Creating, Saving, Reading, Previewing And Printing Files6 lectures • 1hr 3min

Database Project19 lectures • 3hr 19min

Miscellaneous4 lectures • 56min

Search all columns of data grid view project3 lectures • 24min

Using nullable data types with databases4 lectures • 35min

Requirements

Description

Who this course is for: