Learn C# With Windows Forms and SQL Server [Video]

Book Image

Learn C# With Windows Forms and SQL Server [Video]

By : Tom O.

Book Image

Learn C# With Windows Forms and SQL Server [Video]

By: Tom O.

Overview of this book

<p><span id="description" class="sugar_field">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!</span></p> <h2><span class="sugar_field">Style and Approach</span></h2> <p><span class="sugar_field"><span id="trade_selling_points_c" class="sugar_field">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.</span></span></p>

Free Chapter

Learn C# With Windows Forms and SQL Server

Course overview

Learning the fundamentals

Create and run the first program

Display a message with a label

Creating and using a single variable

Describing objects with multiple data types

Reading input, applying methods, and producing output

Reading, converting and displaying values

Doing practical math on two variables

Representing unchanging quantities with constants

General Visual Studio usage tips

Controlling program flow

Using if/else blocks with check boxes

Using if/else blocks with strings and methods

Changing variable values using "x++" and "++x", Part 1

Changing variable values using "x++" and "++x", 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

Iterating over collections with foreach loops, Part 1

Iterating over collections with foreach loops, Part 2

Using the ternary operator, Part 1

Using the ternary operator, Part 2

Creating more stable programs with TryParse

Operators

Operators that evaluate and assign in place

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

Methods and arrays

Making decisions with switch blocks and methods, Part 2

Create a static class for storing utility methods, Part 1

Create a static class for storing utility methods, Part 2

Folder browser project with arrays, Step 1

Folder browser project with arrays, Step 2

Datagrid view control project with loops, Step 1

Datagrid view control project with loops, Step 2

Using lists and out keyword, Part 1

Using lists and out keyword, Part 2

Making use of the Split method with params

Using Linq methods, Part 1

Using Linq methods, Part 2

Creating, Saving, Reading, Previewing And Printing Files

Create the interface and add ability to save file

Add the ability to read files and prevent crashes

Add menu items that allow locating and highlighting a word

Add features to change font, preview and print

Add professional printing to printers and files

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

Database Project

Get SQL Server 2014 with management console

Install SQL Server 2014

Make the database to be used with the project

Create the main form and the business forms

Add interface components to the business contacts form

Create the database model

Write code to connect to the database

Write code to save new records

Write code to edit existing records

Write code to delete existing records

Write code to search for records

Write code to save images, Part 1

Write code to save images, Part 2

Exporting the project as an installable file

Add ability to export records to Excel

Add ability to export records to text files

Add ability to export data to Microsoft Word

Miscellaneous

Download files synchronously and asynchronously

Image viewer project

File copier project, Part 1

File copier project, Part 2

Customer Reviews

5 star

0

4 star

0

3 star

0

2 star

0

1 star

0

Chapter 7

Database Project

Content Locked

Section 8

Write code to save new records

Learn to save records from the form to the SQL Table.