Learn C# With Windows Forms and SQL Server

Learn C# With Windows Forms and SQL Server

English | MP4 | AVC 1920×1080 | AAC 44KHz 2ch | 10h 59m | 2.07 MB

With a real database project!

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!

What You Will Learn

  • Create and runs Windows Forms applications and understand blocks of code, curly braces, comments, use string interpolation, and add new line characters
  • Create and use objects like labels and their properties like Text
  • Use several different data types like boolean, decimal, string and others
  • Use methods that convert values to numerical form for mathematical operations
  • Learn how to work with rich text boxes, and place variables in the right place to achieve certain effects, with radio buttons, index variables and while loops
  • Learn about operators, operands, and how to combine them properly
  • 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
  • Learn how to use tool tips, switch blocks, check list boxes
  • 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
  • Learn how to use arrays, directories and foreach loops with arrays
  • Understand how to work with collections and the datagridview control
  • 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
Table of Contents

Learn C# With Windows Forms and SQL Server
Course overview

Learning the fundamentals
Create and run the first program
Creating and using a single variable
Describing objects with multiple data types
Display a message with a label
Doing practical math on two variables
General Visual Studio usage tips
Reading, converting and displaying values
Reading input, applying methods, and producing output
Representing unchanging quantities with constants

Controlling program flow
Changing variable values using x++ and ++x, Part 1
Changing variable values using x++ and ++x, Part 2
Creating more stable programs with TryParse
Iterating over collections with foreach loops, Part 1
Iterating over collections with foreach loops, Part 2
Printing 1,2,3,4,5 with while loops and radio buttons, Part 1
Printing 5,4,3,2,1 with while loops and radio buttons, Part 2
Updating progress bars with for loops
Using if_else blocks with check boxes
Using if_else blocks with strings and methods
Using the ternary operator, Part 1
Using the ternary operator, Part 2

Operators
Checking two conditions with the logical and operator
Checking two conditions with the logical or operator
Combining logical operators to express more complex logic
Making decisions with switch blocks and methods, Part 1
Operators that evaluate and assign in place

Methods and arrays
Create a static class for storing utility methods, Part 1
Create a static class for storing utility methods, Part 2
Datagrid view control project with loops, Step 1
Datagrid view control project with loops, Step 2
Folder browser project with arrays, Step 1
Folder browser project with arrays, Step 2
Making decisions with switch blocks and methods, Part 2
Making use of the Split method with params
Using Linq methods, Part 1
Using Linq methods, Part 2
Using lists and out keyword, Part 1
Using lists and out keyword, Part 2

Creating, Saving, Reading, Previewing And Printing Files#
Add features to change font, preview and print
Add menu items that allow locating and highlighting a word
Add professional printing to printers and files
Add the ability to read files and prevent crashes
Break from programming – High level overview of the many pieces of a project
Create the interface and add ability to save file

Database Project#
Add ability to export data to Microsoft Word
Add ability to export records to Excel
Add ability to export records to text files
Add interface components to the business contacts form
Create the database model
Create the main form and the business forms
Exporting the project as an installable file
Get SQL Server 2014 with management console
Install SQL Server 2014
Make the database to be used with the project
Write code to connect to the database
Write code to delete existing records
Write code to edit existing records
Write code to save images, Part 1
Write code to save images, Part 2
Write code to save new records
Write code to search for records

Miscellaneous
Download files synchronously and asynchronously
File copier project, Part 1
Image viewer project