Learn C# With Windows Forms and SQL Server
4.4 (834 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,182 students enrolled

Learn C# With Windows Forms and SQL Server

With a real database project!
Bestseller
4.4 (833 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,182 students enrolled
Created by A O
Last updated 5/2018
English
English [Auto-generated]
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 11 hours on-demand video
  • 12 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Expand all 66 lectures 10:59:02
+ How does this course work
1 lecture 02:11

Lesson Objectives: Overview of the content of the course

Preview 02:11
+ Learning the fundamentals
9 lectures 01:22:27

Lesson Objective: Create and run a Windows Forms application

Create and run the first program
06:30

Lesson Objectives: Understanding how to use labels to display messages

Display a message with a label
09:02

Lesson Objectives: Understand how to create, use and displays variables and their values

Creating and using a single variable
09:55

Lesson Objectives: Understanding how to use several different data types to describe objects

Describing objects with multiple data types
10:36

Lesson Objectives: Understanding how to read input, process input and produce output

Preview 08:28

Lesson Objective: Understanding how to read and produce numerical output

Reading, converting and displaying values
08:11

Lesson Objectives: Learn how to operate on multiple variables

Doing practical math on two variables
11:15

Lesson Objective: Understanding how to use constants to represent unchanging quantities

Representing unchanging quantities with constants
11:47

Lesson Objectives: Learn about several different features of Visual Studio

General Visual Studio usage tips
06:43
+ Controlling program flow
12 lectures 01:44:55

Lesson Objective: Creating and using if/else blocks with check boxes

Using if/else blocks with check boxes
05:56

Lesson Objective: Understand how to use if/else blocks with strings and methods like Contains

Using if/else blocks with strings and methods
10:13

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 1
07:54

Lesson Objectives: Finish the project started in the last lesson on x++ and ++x

Changing variable values using "x++" and "++x", Part 2
09:11

Lesson Objective: Create an interface and code a while loop carefully

Printing 1,2,3,4,5 with while loops and radio buttons, Part 1
10:27

Lesson Objective: Understanding how to run a while loop to show decreasing values

Printing 5,4,3,2,1 with while loops and radio buttons, Part 2
05:25

Lesson Objectives: Learn how to use a for loop to fill a progress bar

Updating progress bars with for loops
09:19

Lesson Objectives: Create an interface and code a foreach loop to repeat a task

Iterating over collections with foreach loops, Part 1
10:12

Lesson Objectives: Create another foreach loop to complete the project started previously

Iterating over collections with foreach loops, Part 2
05:24

Lesson Objectives: Design the interface and add basic conversion functionality

Using the ternary operator, Part 1
07:35

Lesson Objectives: Finish the project started in the previous lesson

Using the ternary operator, Part 2
11:34

Lesson Objective: Create more stable code with TryParse

Creating more stable programs with TryParse
11:45
+ Operators
5 lectures 50:35

Lesson Objectives: Understand how to use the remainder operator in an application

Operators that evaluate and assign in place
07:21

Lesson Objective: Understanding how to use the logical and operator and multiple if/else blocks

Checking two conditions with the logical and operator
10:06

Lesson Objectives: Understanding how to use the logical or operator to make a decision with a calendar control

Checking two conditions with the logical or operator
11:16

Lesson Objectives: Create a program that can scan a textbox and pick out a variety of characters

Combining logical operators to express more complex logic
09:01

Lesson Objectives: Creating a program that uses switch blocks

Making decisions with switch blocks and methods, Part 1
12:51
+ Methods and arrays
12 lectures 02:02:41

Lesson Objectives: Create a couple methods that accept and return values

Making decisions with switch blocks and methods, Part 2
13:26

Lesson Objectives: Creating a program that will use an external class file

Create a static class for storing utility methods, Part 1
09:51

Lesson Objectives:Finishing the program started in the previous program

Create a static class for storing utility methods, Part 2
08:46

Lesson Objectives: Learn how to create an interface with a folder browser

Folder browser project with arrays, Step 1
09:16

Lesson Objective: Use arrays and the Directory class to list files 

Preview 08:01

Lesson Objective: Make the interface and write the first version of the code

Datagrid view control project with loops, Step 1
12:56

Lesson Objective: Improve the code so the application does not crash

Datagrid view control project with loops, Step 2
05:55

Lesson Objectives: Create user interface and create code to summarize data

Using lists and out keyword, Part 1
13:04

Lesson Objectives: Create a static class file for holding the Summarize method

Using lists and out keyword, Part 2
12:41

Lesson Objectives: Understand how to use the Split and ConvertAll methods

Making use of the Split method with params
09:39

Lesson Objectives: Build the interface and features to count words

Using Linq methods, Part 1
08:11

Lesson Objectives: Adding features that sort data

Using Linq methods, Part 2
10:55
+ Creating, Saving, Reading, Previewing And Printing Files
6 lectures 01:03:01

Lesson Objective: Build the interface and add features to save files

Create the interface and add ability to save files
11:31

Lesson Objectives: Creating the ability to open saved files and preventing crashes

Add the ability to read files and prevent crashes
09:33

Lesson Objectives: Add code to search for, highlight and replace text

Add menu items that allow locating and highlighting a word
11:44

Lesson Objectives: Add dialog boxes for previewing and printing documents

Add features to change font, preview and print
12:49

Lesson Objectives: Add code to print to printers and files

Preview 06:55

Lesson Objectives: Review the concepts of a name space, a class, a method and more

Break from programming: High level overview of the many pieces of a project
10:29
+ Database Project
17 lectures 02:57:29

Lesson Objectives: Learn how to get SQL Server

Get SQL Server 2014 with management console
04:58

Lesson Objectives: Learn how to create the database to be used

Install SQL Server 2014
03:58

Lesson Objectives: Create a script to make a table in SQL Server

Make the database to be used with the project
11:16

Lesson Objectives: Understand how to create parent and child forms, and apply layouts

Create the main form and the business forms
08:23

Learning Objectives: Add the business contacts user interface elements

Add interface components to the business contacts form
06:25

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

Create the database model
07:45

Lesson Objectives: Write code to connect the program to the database in SQL Server

Write code to connect to the database
12:57

Lesson Objectives: Save records from the form to the SQL Table

Write code to save new records
16:54

Lesson Objectives: Learn how to edit existing records

Write code to edit existing records
11:08

Lesson Objectives: Learn how to delete records

Write code to delete existing records
16:12

Lesson Objectives: Learn how to combine a search box with Linq and a combo box

Write code to search for records
08:56

Lesson Objectives: Write code to enable image saving and retrieval

Write code to save images, Part 1
10:11

Lesson Objectives: Add image previews and catch errors when saving images

Write code to save images, Part 2
08:57

Lesson Objectives: Make a couple small changes to the code and confirm features work

Exporting the project as an installable file
06:32

Lesson Objectives: Write data from a data grid view to Excel

Add ability to export records to Excel
17:45

Lesson Objectives: Add code to write records to a text file

Add ability to export records to text files
07:49

Lesson Objectives: Print the data grid view to Work

Add ability to export data to Microsoft Word
17:23
+ Miscellaneous
4 lectures 55:43

Lesson Objectives: Learn how to download files using two different methods

Preview 11:37

Lesson Objective: Learn how to build an image gallery project

Image viewer project
19:03

Lesson Objectives: Build interface for file copier project

File copier project, Part 1
11:51

Lesson Objectives: Finish the file copier project

File copier project, Part 2
13:12
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

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.

  1. 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.

  2. Lessons 40-45: Text editor project to illustrate more advanced coding.

    1. This project show more practical applications of C#. 

  3. 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.

  4. 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.