Learn C With Windows Forms and SQL Server

Learn C With Windows Forms and SQL Server

What you’ll 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

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

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 gapsThank 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.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. This is not meant to be exhaustive but to simply prepare you for the database project. It’s a review of basic programming concepts. Lessons 40-45: Text editor project to illustrate more advanced coding.This project show more practical applications of C#. Lessons 46-62: Variety of advanced techniques used in building a database project.Here you learn how to combine C# and SQL Server.The code in these lessons gets quite sophisticated. Make sure you have MS Office installed for this part or you will not be able to complete the project. 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. Make sure you look under lesson resources when you do this project. There are updates stored there. 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.

Overview

Section 1: How does this course work

Lecture 1 Course overview

Section 2: Learning the fundamentals

Lecture 2 Create and run the first program

Lecture 3 Display a message with a label

Lecture 4 Creating and using a single variable

Lecture 5 Describing objects with multiple data types

Lecture 6 Reading input, applying methods, and producing output

Lecture 7 Reading, converting and displaying values

Lecture 8 Doing practical math on two variables

Lecture 9 Representing unchanging quantities with constants

Lecture 10 General Visual Studio usage tips

Section 3: Controlling program flow

Lecture 11 Using if/else blocks with check boxes

Lecture 12 Using if/else blocks with strings and methods

Lecture 13 Changing variable values using “x++” and “++x”, Part 1

Lecture 14 Changing variable values using “x++” and “++x”, Part 2

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

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

Lecture 17 Updating progress bars with for loops

Lecture 18 Iterating over collections with foreach loops, Part 1

Lecture 19 Iterating over collections with foreach loops, Part 2

Lecture 20 Using the ternary operator, Part 1

Lecture 21 Using the ternary operator, Part 2

Lecture 22 Creating more stable programs with TryParse

Section 4: Operators

Lecture 23 Operators that evaluate and assign in place

Lecture 24 Checking two conditions with the logical and operator

Lecture 25 Checking two conditions with the logical or operator

Lecture 26 Combining logical operators to express more complex logic

Lecture 27 Making decisions with switch blocks and methods, Part 1

Section 5: Methods and arrays

Lecture 28 Making decisions with switch blocks and methods, Part 2

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

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

Lecture 31 Folder browser project with arrays, Step 1

Lecture 32 Folder browser project with arrays, Step 2

Lecture 33 Datagrid view control project with loops, Step 1

Lecture 34 Datagrid view control project with loops, Step 2

Lecture 35 Using lists and out keyword, Part 1

Lecture 36 Using lists and out keyword, Part 2

Lecture 37 Making use of the Split method with params

Lecture 38 Using Linq methods, Part 1

Lecture 39 Using Linq methods, Part 2

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

Lecture 40 Create the interface and add ability to save files

Lecture 41 Add the ability to read files and prevent crashes

Lecture 42 Add menu items that allow locating and highlighting a word

Lecture 43 Add features to change font, preview and print

Lecture 44 Add professional printing to printers and files

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

Section 7: Database Project

Lecture 46 Get SQL Server 2014 with management console

Lecture 47 Install SQL Server 2014

Lecture 48 Make the database to be used with the project

Lecture 49 Create the main form and the business forms

Lecture 50 Add interface components to the business contacts form

Lecture 51 Create the database model

Lecture 52 Write code to connect to the database

Lecture 53 Write code to save new records

Lecture 54 Write code to edit existing records

Lecture 55 Write code to delete existing records

Lecture 56 Write code to search for records

Lecture 57 Write code to save images, Part 1

Lecture 58 Write code to save images, Part 2

Lecture 59 Exporting the project as an installable file

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

Lecture 61 Add ability to export records to text files

Lecture 62 Add ability to export data to Microsoft Word

Lecture 63 Making SQL Server keep the ID sequential using Identity_Cache

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

Section 8: Miscellaneous

Lecture 65 Download files synchronously and asynchronously

Lecture 66 Image viewer project

Lecture 67 File copier project, Part 1

Lecture 68 File copier project, Part 2

Section 9: Search all columns of data grid view project

Lecture 69 Update to SQL Server 2019

Lecture 70 Setup the database in local DB

Lecture 71 Finish the mini project

Section 10: Using nullable data types with databases

Lecture 72 Create a small table in SQL Server

Lecture 73 Create a small class in C#

Lecture 74 Write complete code using decimal nullables

Lecture 75 Add ability to display results in a label

Section 11: Project on copying between two datagridview objects

Lecture 76 Project overview

Lecture 77 Make interface and connect to tables in Local DB

Lecture 78 Add SQL Query

Lecture 79 Write the code

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.

Course Information:

Udemy | English | 12h 35m | 5.02 GB
Created by: T O

You Can See More Courses in the Developer >> Greetings from CourseDown.com