Learn C# With Windows Forms and SQL Server
4.6 (173 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,048 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn C# With Windows Forms and SQL Server to your Wishlist.

Add to Wishlist

Learn C# With Windows Forms and SQL Server

With a real database project!
Best Seller
4.6 (173 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,048 students enrolled
Created by Tom O.
Last updated 4/2017
English
Current price: $10 Original price: $100 Discount: 90% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 11 hours on-demand video
  • 8 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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

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!

Parts of promo video PowerPoint licensed from PresenterMedia.

Who is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
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
About the Instructor
Tom O.
4.4 Average rating
1,649 Reviews
17,722 Students
19 Courses
Web, Math, Stats., and Physics Expert
  • I have nine years experience as a teacher of mathematics, physics, statistics, and programming. I worked for five years as a database programmer using various technologies such as .NET, Clipper, SQL, SQL Server, SAS, Excel, and others. I'm the publisher of one of the most successful programming courses on udemy, called "Learn C# With Visual Studio 2013". Currently, I work as a mathematics and computer science teacher at a college in NY.
  • Related Education:
  • Master of Science in Applied Statistical Computing, Kennesaw State University
  • Bachelor of Arts, Pure Mathematics, Queens College
  • Associates of Science in Computer Programming
  • Creator of more than 1620 math, physics, statistics and programming videos
  • Programmer of more than 500 educational simulations