C# Console and Windows Forms Development with LINQ & ADO.NET
4.2 (27 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
9,538 students enrolled

C# Console and Windows Forms Development with LINQ & ADO.NET

Learn to build a practical Data Driven MDI Windows Forms Application using C#, LINQ and SQL Server Express.
4.2 (27 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
9,538 students enrolled
Created by Trevoir Williams
Last updated 4/2020
English
English [Auto]
Current price: $119.99 Original price: $199.99 Discount: 40% off
1 day left at this price!
30-Day Money-Back Guarantee
This course includes
  • 13 hours on-demand video
  • 1 article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Understand how to Create and run Console Applications
  • Understand how to Create and run Windows Forms Applications
  • Understand Basic C# Syntax - blocks of code, curly braces, comments
  • Understand how to use string interpolation, concatenation and general manipulation
  • Understand Variables and Objects
  • Understand how to use C# operators for math and logic tasks
  • Understand Windows Forms Visual Elements and Controls
  • Understand different data types, when they are used and how they behave.
  • Understand Methods and their return types
  • Understand how to build Classes
  • Understand how to create Windows Forms and how to manipulate them (Open, Close, Hide, etc)
  • Understand how to pass data between forms
  • Understand how to connect Windows Forms applications to a database
  • Understand how to write LINQ queries.
  • Understand how to connect to and upload a project to GitHub
Course content
Expand all 38 lectures 13:11:55
+ Development Environment Setup
4 lectures 18:43
Install .Net Core SDK
01:31
Setup GitHub Account
02:28
Tour Of Visual Studio
11:05
+ C# Console Programming - Basic Control Structures
7 lectures 02:38:30
Write a Simple Hello World Program
15:06
Input and Output Programs
17:47
C# Data Types and Conversion
22:17
Operators in C#
16:39
Condition Statements
32:08
Repetition Statements
27:57
Methods and Return Types
26:36
+ C# Console Programming - More Advanced Concepts
4 lectures 01:46:21
String Manipulation Functions
21:24
Handling Exceptions
12:52
Classes and Objects
37:10
Arrays, Lists and Other Collections
34:55
+ Winforms Applications - The Basics
8 lectures 02:21:02
Create a Simple Winforms Application (Car Rental Application)
25:58
Understand Winforms Controls, Properties and Events
21:15
Form Validation and Exception Handling
34:01
Create Database in SQL Server
09:36
Create Database Model with ADO.NET
12:53
Select Data from the Database Using LINQ
15:12
Submit to Database from Form
16:46
+ Multi Document Interface (MDI) and More Database Operations
2 lectures 30:11
Creating Additional Forms and Windows
13:38
Create an MDI Application
16:33
+ Managing Database Changes and CRUD Operations
6 lectures 02:55:09
View Data In A Grid
28:32
Managing Database Changes
18:23
Create and Edit Records (Using one form)
47:45
Vehicle Data Validations and Exception Handling
07:07
Manage Car Rental Records
45:20
Enhancing Application Flow and User Experience
28:02
+ User Management and Login Functionality
4 lectures 02:19:00
Simple Login Form
38:59
Control Features Based on User Roles
34:31
User Password and Active Status Reset
20:58
Add New Users and Password Reset
44:32
Requirements
  • A Computer
  • Internet
  • Willingness to Learn
Description

Overview

In this course, you will learn C# programming for desktop applications. This journey will have you becoming proficient in

  • Visual Studio Interface and Shortcuts

  • Console Application Development with C#

  • Data Driven Graphical User Interface Applications using Windows Forms 

  • Managing Databases with SQL Server Management Studio

  • Developing User and Roles Managed Interfaces and functions

  • Using Utility Classes for cleaner code

  • Developing Multi-Document Interface (MDI) Applications

  • Applying Object Oriented Programming with C#

  • Adding a Visual Studio Project to Source Control

These lessons assume no prior knowledge of programming or the C# language, and will have you up and running in no time. By the end of this course, you will have enough knowledge to build a functional Windows Forms Application, connected to a Microsoft SQL Server Database, with all your program code and changes being tracked on GitHub.

Get an "Entry Level" .NET Developer job in an organization, with the skills you will get from this course.

Why Learn C# Language

C# is the most versatile programming language in .NET Framework and .NET Core. Not only can you build Windows client applications, but you can also use C# to build Web and mobile apps.

C# can be used to build:

  1. Windows client applications using Windows Forms, WPF and UWP.

  2. Web applications with ASP.NET and ASP.NET Core.

  3. Native iOS and Android mobile apps using Xamarin.

  4. Libraries, components, and console applications

  5. Cloud and Azure apps

  6. Block chain apps

  7. Not only is C# language supported and maintained by Microsoft, but it also has a strong community support. More than 5 million developers use C# language. .NET Core and C# compiler are open source and the adoption is growing in open source community.


Build A Strong Foundation in C# Programming:

  • Understand C# Syntax

  • Understand Datatypes and Variables

  • Understand Sequence, Decision and Repetition Control Structures

  • Understand String Manipulation

  • Understand Date and Time Manipulation

  • Understand Object Oriented Programming, Classes and Objects

  • Understand Visual Studio

  • Understand Debugging Techniques

  • Understand Event Driven Development

  • Develop Console Applications

  • Develop Windows Forms

  • Develop Data Driven Applications

  • Understand LINQ and Data Queries with C# Syntax

  • Setup Login and User Management Functionality

Content and Overview

This course is very beginner friendly and chock full of development tips. This huge course offers premium content, smartly broken up to highlight a set of related activities based on each module. We will also look at troubleshooting and debugging errors as we go along; implementing best practices; writing efficient logic and understanding why developers do things the way they do. Your knowledge will grow, step by step, throughout the course and you will be challenged to be the best you can be.

By the time you have finished the course you will have moved around in Visual Studio and examined logic and syntax errors so much, that it will be second nature for you when working in the .NET environment. This will put your new learned skills into practical use and impress your boss and coworkers.

The course is complete with working files hosted on GitHub, with the inclusion of some files to make it easier for you to replicate the code being demonstrated. You will be able to work alongside the author as you work through each lecture and will receive a verifiable certificate of completion upon finishing the course.

Clicking the Take This Course button could be the best step you could take towards quickly increasing your income and marketability! Also, remember that if you don't think the course is worth what you spent, you have a full 30 days to get a no questions asked refund!


It's time to take action! This deal will not be available forever!

Click the "Buy Now" button Today!

Every hour you delay is costing you money...

See you in the course!

Who this course is for:
  • Anyone wanting to learn LINQ
  • Anyone wanting to learn .NET Programming with C#
  • Anyone Wanting to learn Desktop Development with Windows Forms