Learn C# With Windows Forms and SQL Server

Learn C# With Windows Forms and SQL Server, available at $69.99, has an average rating of 4.31, with 79 lectures, based on 1288 reviews, and has 6875 subscribers.

You will learn about 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 This course is ideal for individuals who are This is a good course for those who want to learn C# through Windows Forms. or This is not a course for those who want to learn C# through Console Applications or This is a course for those interested in database projects. It is particularly useful for This is a good course for those who want to learn C# through Windows Forms. or This is not a course for those who want to learn C# through Console Applications or This is a course for those interested in database projects. .

Enroll now: Learn C# With Windows Forms and SQL Server

Summary

Title: Learn C# With Windows Forms and SQL Server

Price: $69.99

Average Rating: 4.31

Number of Lectures: 79

Number of Published Lectures: 79

Number of Curriculum Items: 79

Number of Published Curriculum Objects: 79

Original Price: $89.99

Quality Status: approved

Status: Live

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

Who Should Attend

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.

Target Audiences

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.

Update

8/3/2020: Replaced video 60 on exporting to Excel to clarify or improve some subtle technical details.  

8/8/2020: Added video 63 on how to work with the identity_cache in SQL Server to avoid identity gaps

Thank you for stopping by.

Most important: Before enrolling, please take the time to read the course curriculum, and watch the free preview videos so you can be sure my way of presenting information is one that truly works for you. This will give you a strong indication of what to expect throughout the course. Please kindly do not enroll until you have done this. Also, please remember that I am only one person, and I cannot as one person think of everything that you might want covered. If that’s the case, please send me a message and tell me what you feel should be added. Thank you.

1. Lessons 2-39: Introduction to C# as a review for those who are new to programming in C# or are coming from a different language. 

   1. This is not meant to be exhaustive but to simply prepare you for the database project.

   2. It’s a review of basic programming concepts.

2. Lessons 40-45: Text editor project to illustrate more advanced coding.

   1. This project show more practical applications of C#. 

3. Lessons 46-62: Variety of advanced techniques used in building a database project.

   1. Here you learn how to combine C# and SQL Server.

   2. The code in these lessons gets quite sophisticated. 

   3. Make sure you have MS Office installed for this part or you will not be able to complete the project.

   4. If you’re going to use the code as saved on GitHub for this part, it will be more challenging to configure than the code for the simple lessons.

   5. Make sure you look under lesson resources when you do this project. There are updates stored there.

4. Lessons 63-66: Miscellaneous small projects that show a variety of possibilities with C#.

It’s important that you type and run all the code, as I do. To take it one step further, simply ask and answer this question: how can I make one meaningful modification to the code to produce a new effect? Consistently asking and answering this question as you watch the videos will allow you to improve your skills beyond what I show you. 

Please note I develop the material at a relatively leisurely rate, so if I speak too slowly, please watch the videos at 1.25x. 

I’m the author of “Beginning C# Hands-On The Core Language” and “C# Hands-On The Advanced Features”, both from PACKT.

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.

Course Curriculum

Chapter 1: How does this course work

Lecture 1: Course overview

Chapter 2: Learning the fundamentals

Lecture 1: Create and run the first program

Lecture 2: Display a message with a label

Lecture 3: Creating and using a single variable

Lecture 4: Describing objects with multiple data types

Lecture 5: Reading input, applying methods, and producing output

Lecture 6: Reading, converting and displaying values

Lecture 7: Doing practical math on two variables

Lecture 8: Representing unchanging quantities with constants

Lecture 9: General Visual Studio usage tips

Chapter 3: Controlling program flow

Lecture 1: Using if/else blocks with check boxes

Lecture 2: Using if/else blocks with strings and methods

Lecture 3: Changing variable values using x++ and ++x, Part 1

Lecture 4: Changing variable values using x++ and ++x, Part 2

Lecture 5: Printing 1,2,3,4,5 with while loops and radio buttons, Part 1

Lecture 6: Printing 5,4,3,2,1 with while loops and radio buttons, Part 2

Lecture 7: Updating progress bars with for loops

Lecture 8: Iterating over collections with foreach loops, Part 1

Lecture 9: Iterating over collections with foreach loops, Part 2

Lecture 10: Using the ternary operator, Part 1

Lecture 11: Using the ternary operator, Part 2

Lecture 12: Creating more stable programs with TryParse

Chapter 4: Operators

Lecture 1: Operators that evaluate and assign in place

Lecture 2: Checking two conditions with the logical and operator

Lecture 3: Checking two conditions with the logical or operator

Lecture 4: Combining logical operators to express more complex logic

Lecture 5: Making decisions with switch blocks and methods, Part 1

Chapter 5: Methods and arrays

Lecture 1: Making decisions with switch blocks and methods, Part 2

Lecture 2: Create a static class for storing utility methods, Part 1

Lecture 3: Create a static class for storing utility methods, Part 2

Lecture 4: Folder browser project with arrays, Step 1

Lecture 5: Folder browser project with arrays, Step 2

Lecture 6: Datagrid view control project with loops, Step 1

Lecture 7: Datagrid view control project with loops, Step 2

Lecture 8: Using lists and out keyword, Part 1

Lecture 9: Using lists and out keyword, Part 2

Lecture 10: Making use of the Split method with params

Lecture 11: Using Linq methods, Part 1

Lecture 12: Using Linq methods, Part 2

Chapter 6: Creating, Saving, Reading, Previewing And Printing Files

Lecture 1: Create the interface and add ability to save files

Lecture 2: Add the ability to read files and prevent crashes

Lecture 3: Add menu items that allow locating and highlighting a word

Lecture 4: Add features to change font, preview and print

Lecture 5: Add professional printing to printers and files

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

Chapter 7: Database Project

Lecture 1: Get SQL Server 2014 with management console

Lecture 2: Install SQL Server 2014

Lecture 3: Make the database to be used with the project

Lecture 4: Create the main form and the business forms

Lecture 5: Add interface components to the business contacts form

Lecture 6: Create the database model

Lecture 7: Write code to connect to the database

Lecture 8: Write code to save new records

Lecture 9: Write code to edit existing records

Lecture 10: Write code to delete existing records

Lecture 11: Write code to search for records

Lecture 12: Write code to save images, Part 1

Lecture 13: Write code to save images, Part 2

Lecture 14: Exporting the project as an installable file

Lecture 15: Add ability to export to excel, updated 8/3/2020

Lecture 16: Add ability to export records to text files

Lecture 17: Add ability to export data to Microsoft Word

Lecture 18: Making SQL Server keep the ID sequential using Identity_Cache

Lecture 19: Update to working with @ in the parameter names, 8/2/2020

Chapter 8: Miscellaneous

Lecture 1: Download files synchronously and asynchronously

Lecture 2: Image viewer project

Lecture 3: File copier project, Part 1

Lecture 4: File copier project, Part 2

Chapter 9: Search all columns of data grid view project

Lecture 1: Update to SQL Server 2019

Lecture 2: Setup the database in local DB

Lecture 3: Finish the mini project

Chapter 10: Using nullable data types with databases

Lecture 1: Create a small table in SQL Server

Lecture 2: Create a small class in C#

Lecture 3: Write complete code using decimal nullables

Lecture 4: Add ability to display results in a label

Chapter 11: Project on copying between two datagridview objects

Lecture 1: Project overview

Lecture 2: Make interface and connect to tables in Local DB

Lecture 3: Add SQL Query

Lecture 4: Write the code

Instructors

T O
Spreader of Knowledge

Rating Distribution

1 stars: 11 votes

2 stars: 28 votes

3 stars: 133 votes

4 stars: 409 votes

5 stars: 707 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!