Learn C# With Windows Forms and SQL Server

With a real database project!

4.43 (1312 reviews)

Udemy

platform

English

language

Programming Languages

What you will 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

Course Gallery

Learn C# With Windows Forms and SQL Server – Screenshot 1 — Screenshot 1 – Learn C# With Windows Forms and SQL Server

Learn C# With Windows Forms and SQL Server – Screenshot 2 — Screenshot 2 – Learn C# With Windows Forms and SQL Server

Learn C# With Windows Forms and SQL Server – Screenshot 3 — Screenshot 3 – Learn C# With Windows Forms and SQL Server

Learn C# With Windows Forms and SQL Server – Screenshot 4 — Screenshot 4 – Learn C# With Windows Forms and SQL Server

Loading charts...

Comidoc Review

Our Verdict

This course offers a solid foundation for understanding and developing C# Windows Forms applications with practical SQL Server integration. Despite needing some minor theoretical deepening and slight smoothing of the SQL module download process, it still provides great value in teaching realistic programming situations. Suitable for beginners willing to get started with C# forms development and advanced programmers seeking to sharpen their skills on database projects.

What We Liked

Covers a wide range of topics in C#, particularly focused on Windows Forms and SQL Server integration
Real-world database project providing valuable hands-on experience
Instructor is thorough and explains the code, practical applications being highlighted
Instructor available to answer questions and ensure understanding
SEO long-tail keywords: C# Windows Forms apps with SQL Server, C# forms real-world project, in-depth C# training, C# for database developers

Potential Drawbacks

Beginners may find some topics repetitive and could potentially reduce the video length
Some theoretical explanations could go deeper; focus is more on doing than explaining underlying concepts
Insufficient SQL topic coverage, lacks naming conventions guidance and proper function/class writing details
Module 7 has issues with downloadable examples, affecting user experience
SEO long-tail keywords: beginner's guide to C# naming convention, advanced theory in C# courses, C# form app tutorial improvements