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

Preview in Mapt

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

Tom Owsiak

With a real database project!

Quick links: > What will you learn?> Table of content

Video
$84.15
RRP $98.99
Save 14%
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$84.15
RRP $98.99

Frequently bought together


Learn C# With Windows Forms and SQL Server [Video] Book Cover
Learn C# With Windows Forms and SQL Server [Video]
$ 98.99
$ 84.15
A 17 Hour C# Course with Intro to SQL and C# 7.0 [Video] Book Cover
A 17 Hour C# Course with Intro to SQL and C# 7.0 [Video]
$ 99.99
$ 85.00
Buy 2 for $35.00
Save $163.98
Add to Cart

Video Details

ISBN 139781788990356
Course Length10 hours 59 minutes

Video Description

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!

Style and Approach

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.

Table of Contents

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

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

Authors

Table of Contents

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

Video Details

ISBN 139781788990356
Course Length10 hours 59 minutes
Read More

Read More Reviews

Recommended for You

A 17 Hour C# Course with Intro to SQL and C# 7.0 [Video] Book Cover
A 17 Hour C# Course with Intro to SQL and C# 7.0 [Video]
$ 99.99
$ 85.00
Learn To Program Tic-Tac-Toe with C# and Visual Studio [Video] Book Cover
Learn To Program Tic-Tac-Toe with C# and Visual Studio [Video]
$ 42.99
$ 36.55
Machine Learning with C++ [Video] Book Cover
Machine Learning with C++ [Video]
$ 124.99
$ 106.25
Server-Side Development with Kotlin and Spring Boot [Video] Book Cover
Server-Side Development with Kotlin and Spring Boot [Video]
$ 124.99
$ 106.25
Advanced Server-Side Programming with Node.js [Video] Book Cover
Advanced Server-Side Programming with Node.js [Video]
$ 124.99
$ 106.25
Learning GraphQL with React and Relay [Video] Book Cover
Learning GraphQL with React and Relay [Video]
$ 124.99
$ 106.25