Csharp6windowsforms Course

With a real database project!

Last updated 2022-01-10 | 4.5

- Create and runs Windows Forms applications
- Understand blocks of code
- curly braces
- comments
- Understand how to use string interpolation
- and add new line characters

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

* 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

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

How does this course work 1 lectures

Course overview Preview 02:11

Lesson Objectives: Overview of the content of the course

Learning the fundamentals 9 lectures

Create and run the first program Preview 06:30

Lesson Objective: Create and run a Windows Forms application

Display a message with a label Preview 09:02

Lesson Objectives: Understanding how to use labels to display messages

Creating and using a single variable Preview 09:55

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

Describing objects with multiple data types Preview 10:36

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

Reading input, applying methods, and producing output Preview 08:28

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

Reading, converting and displaying values Preview 08:11

Lesson Objective: Understanding how to read and produce numerical output

Doing practical math on two variables Preview 11:15

Lesson Objectives: Learn how to operate on multiple variables

Representing unchanging quantities with constants Preview 11:47

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

General Visual Studio usage tips Preview 06:43

Lesson Objectives: Learn about several different features of Visual Studio

Controlling program flow 12 lectures

Using if/else blocks with check boxes Preview 05:56

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

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

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

Changing variable values using "x++" and "++x", Part 1 Preview 07: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 2 Preview 09: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 1 Preview 10: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 2 Preview 05:25

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

Updating progress bars with for loops Preview 09:19

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

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

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

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

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

Using the ternary operator, Part 1 Preview 07:35

Lesson Objectives: Design the interface and add basic conversion functionality

Using the ternary operator, Part 2 Preview 11:34

Lesson Objectives: Finish the project started in the previous lesson

Creating more stable programs with TryParse Preview 11:45

Lesson Objective: Create more stable code with TryParse

Operators 5 lectures

Operators that evaluate and assign in place Preview 07:21

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

Checking two conditions with the logical and operator Preview 10:06

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

Checking two conditions with the logical or operator Preview 11: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 logic Preview 09: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 1 Preview 12:51

Lesson Objectives: Creating a program that uses switch blocks

Methods and arrays 12 lectures

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

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

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

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

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

Lesson Objectives:Finishing the program started in the previous program

Folder browser project with arrays, Step 1 Preview 09:16

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

Folder browser project with arrays, Step 2 Preview 08:01

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

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

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

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

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

Using lists and out keyword, Part 1 Preview 13:04

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

Using lists and out keyword, Part 2 Preview 12:41

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

Making use of the Split method with params Preview 09:39

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

Using Linq methods, Part 1 Preview 08:11

Lesson Objectives: Build the interface and features to count words

Using Linq methods, Part 2 Preview 10:55

Lesson Objectives: Adding features that sort data

Creating, Saving, Reading, Previewing And Printing Files 6 lectures

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

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

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

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

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

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

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

Lesson Objectives: Add dialog boxes for previewing and printing documents

Add professional printing to printers and files Preview 06:55

Lesson Objectives: Add code to print to printers and files

Break from programming: High level overview of the many pieces of a project Preview 10:29

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

Database Project 19 lectures

Get SQL Server 2014 with management console Preview 04:58

Lesson Objectives: Learn how to get SQL Server

Install SQL Server 2014 Preview 03:58

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

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

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

Create the main form and the business forms Preview 08:23

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

Add interface components to the business contacts form Preview 06:25

Learning Objectives: Add the business contacts user interface elements

Create the database model Preview 07: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 database Preview 12:57

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

Write code to save new records Preview 16:54

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

Write code to edit existing records Preview 11:08

Lesson Objectives: Learn how to edit existing records

Write code to delete existing records Preview 16:12

Lesson Objectives: Learn how to delete records

Write code to search for records Preview 08:56

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

Write code to save images, Part 1 Preview 10:11

Lesson Objectives: Write code to enable image saving and retrieval

Write code to save images, Part 2 Preview 08:57

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

Exporting the project as an installable file Preview 06:32

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