OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.

Fast C# .NET Core Live Project in Windows Forms and SQL

Mega Learning

Hi There.

With my 23 years programming skills I am with you to share my knowledge with you.

So

If you try you will be a c sharper.

If you wanna make a lot of money.

If you wanna find best jobs in programming.

If you Want to learn the C# .NET Core

If you are beginners or student looking for a tutorial that teach c# with real project in simplest way.

If you want really to be a programmer so it is best place that you can start to learn C#.

This course includes :

Read more

Hi There.

With my 23 years programming skills I am with you to share my knowledge with you.

So

If you try you will be a c sharper.

If you wanna make a lot of money.

If you wanna find best jobs in programming.

If you Want to learn the C# .NET Core

If you are beginners or student looking for a tutorial that teach c# with real project in simplest way.

If you want really to be a programmer so it is best place that you can start to learn C#.

This course includes :

  • Start using C# with Visual Studio 2022 From Scratch

  • Designing Main Form

  • Using SQL in C# by ADO. NET

  • SQL Server, Its installation and working

  • Create database App with SQL and C#

  • SAP Crystal Reports to design amazing reports in C#

  • Working with settings in Application

  • Design: "Incoming Letters List" Form

  • Design: "Incoming Letters Data Entry" Form

  • Design: "Outgoing Letters" Form

  • Design: "Outgoing Letters Data Entry" Form

  • Deeper look at: TableAdapter, Dataset and Datatable

  • Customizing DataGridView

  • Create database for incoming letters

  • Add analog clock to sidebar

  • Add login user image to sidebar

  • and …

Do not hesitate to start learning C# .NET Core 6

Every thing will be discussed with sample project and you will have lot of fun within my course.

Say Hi C# world and lets go .

Enroll now

What's inside

Learning objectives

  • Live full graphical project by c# .net core + sql database from scratch
  • Easily learn from scratch to create pro windows apps by .net core - sql database in c#
  • Using c#.net core to create sql database apps
  • Sap crystal reports to design reports in c#
  • Sql server, it's installation & using in c#
  • Using aes to encrypt and decrypt password
  • Design of amazing graphical main form
  • Backup and restore form for sql database
  • Design about us form by using the versioning info of app
  • Design users management form
  • Graphical login form
  • Using images: crop, resize, load & save images
  • Adding permission for each user
  • Design sql database and use it in c# by ado. net
  • Design "sql connection setting" form
  • Show more
  • Show less

Syllabus

Introduction
Introduction to this course
Download project files of this course
Designing Main Form
Read more
Start Secretariat Application in C# .NET 6
Adding main panels
Minimize and close buttons
Top menu buttons
Add calendar to sidebar
Add analog clock to sidebar
Customize appearance of analog clock
Add login user image to sidebar
Data entry menu by treeview
SQL - Quick Review of SQL Server
Who should watch this section!
Download and install SQL 2014 on Windows 10 and Windows 7
Start using SQL server and SSMS
Working with SQL database
Using SQL Server configuration manager
Using SQL Server Table
SQL Numeric Data types
SQL English Text Data types
SQL Unicode Text Data types
GUID datatype in SQL
How to Attach, Detach and offline the SQL database
Identity and Auto Increment Column in SQL Server
SQL Date Time Data types
Project => Create "Phone Book" database in SQL
Select Query In SQL
Where clause
Using SQL in C# by ADO.NET
What is 'incoming letters' form?
Structure of ADO .NET to use database in C#
Create database for incoming letters
Connect SQL Db to C# by : TableAdapter, Dataset, ...
Deeper look at: TableAdapter, Dataset and Datatable
How to Back up and restore C# project?
Design: "Incoming Letters List" Form
Add "incoming letters list" form and set common properties
Loading data in to DataGridView
Customizing DataGridView
Adding record navigator to form
Add top buttons to form
Adding Search panel to form
Searching SQL data by ID in C#
Searching SQL data by 'Subject' in C#
Searching SQL data by 'Reg Date' in C#
Design: "Incoming Letters" Form
Add "incoming letters" form and set common properties
Add top buttons to form: Add, Edit, Delete, Save Cancel
Add sys date & time to footer and set values by C#
Add user name & id to footer and set values by C#
Adding data entry items to form
Bind the data entry items to bindingsource
C# code for New, Edit and save buttons
C# code for Delete and Cancel buttons
Customize date format by App culture
Assign default values for date, time controls and...
Set mask to date and time maskedtexboxes
Validate the date before saving in SQL db
Connect data entry form to it's parent form
Connect 'Incoming letters list' to main form
Save the null values in the date columns
Design: "Outgoing Letters" Form
Quick tour of 'Outgoing letters' form
Creating SQL database for 'Outgoing letters'
Connecting 'Outgoing letters' SQL table to C#
Design 'Outgoing letters list' form
Design 'Outgoing letters' data entry form
Connect 'Outgoing letters list' to main form
Save the null values in the date columns of "Outgoing Letters"
Design: Users Management
Quick tour of "Users Management"
Creating SQL database for 'Users'
Connecting 'Users' SQL table to C#
Design 'App Users List' form
Design 'App Users' data entry form
Add User photo to data entry form
Design "Login Form"
Add protection to "Users Data Entry" form
Connecting "App User" form to main form
User Permissions
Quick tour of "User Permissions"
Create database for "User Permissions"
Add permission columns from SQL to C# Datatable
Adding permission sections to "Users Form"
Bind permission Checkboxes to Bindingsource
Load user permission data in the "Main Form"
C# code to load user permission by column name
Load permission for the "Main Form"
Load permission for all other forms
Reload permissions by closing the "User List" form
Design: Backup and Restore Forms
Quick tour of "Backup & Restore"
Design the "Backup" and "Restore" forms
C# code for "Browse Button on the "Backup Form"
Backup data in SSMS ( SQL Server Management Studio)
Backup SQL database in C#
Show message and progress panel while backing up
Restore data in SSMS ( SQL Server Management Studio)

Save this course

Save Fast C# .NET Core Live Project in Windows Forms and SQL to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Fast C# .NET Core Live Project in Windows Forms and SQL with these activities:
Review SQL Fundamentals
Solidify your understanding of SQL fundamentals before diving into the course's database aspects. This will make it easier to follow along with the database design and querying sections.
Show steps
  • Review basic SQL syntax and commands (SELECT, INSERT, UPDATE, DELETE).
  • Practice writing simple queries against a sample database.
  • Familiarize yourself with database concepts like tables, columns, and relationships.
Brush Up on C# Basics
Reinforce your C# foundation to better grasp the course's application development aspects. This will help you understand the code examples and build your own Windows Forms application.
Show steps
  • Review C# syntax, data types, and control flow statements.
  • Practice writing simple C# programs to reinforce your understanding.
  • Familiarize yourself with object-oriented programming concepts in C#.
Read 'C# 8.0 and .NET Core 3.0 – Modern Cross-Platform Development'
Supplement your learning with a comprehensive guide to C# and .NET Core. This book will provide additional context and examples to deepen your understanding of the course material.
View C# 8.0 and .NET Core 3.0 – Modern Cross... on Amazon
Show steps
  • Read the chapters related to C# syntax, .NET Core fundamentals, and Windows Forms development.
  • Work through the examples provided in the book to reinforce your understanding.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Build a Simple CRUD Application
Apply your knowledge by building a simple CRUD (Create, Read, Update, Delete) application using C#, Windows Forms, and SQL Server. This hands-on project will solidify your understanding of the course material.
Show steps
  • Design a simple database schema with a few tables.
  • Create a Windows Forms application with controls for data entry and display.
  • Implement CRUD operations to interact with the database.
  • Test your application thoroughly.
Document Your Learning Journey
Reinforce your understanding by documenting your learning process. This will help you identify areas where you need more practice and solidify your knowledge.
Show steps
  • Create a blog or journal to document your progress.
  • Summarize key concepts and techniques learned in each module.
  • Reflect on challenges faced and solutions found.
Explore 'SQL Server 2019 Administration Inside Out'
Expand your knowledge of SQL Server administration to gain a more comprehensive understanding of database management. This book will provide insights into the underlying database system.
View SQL Server 2022 Administration Inside Out on Amazon
Show steps
  • Read the sections related to database backup and restore, security, and performance tuning.
  • Experiment with the techniques described in the book to improve your database administration skills.
Contribute to a .NET Open Source Project
Deepen your understanding of C# and .NET Core by contributing to an open-source project. This will provide valuable experience working with real-world code and collaborating with other developers.
Show steps
  • Find a .NET open-source project that interests you.
  • Explore the codebase and identify areas where you can contribute.
  • Submit bug fixes, documentation improvements, or new features.
  • Participate in code reviews and discussions.

Career center

Learners who complete Fast C# .NET Core Live Project in Windows Forms and SQL will develop knowledge and skills that may be useful to these careers:
Desktop Application Developer
A Desktop Application Developer creates software applications that run on desktop operating systems. This course, focusing on C# .NET Core, Windows Forms, and SQL, directly aligns with the skills needed to design, develop, and implement desktop applications. You'll gain hands-on experience in building graphical user interfaces, managing data using SQL Server, and creating functional application features, as demonstrated through the course's emphasis on building full graphical projects. Learning to connect a C# application to an SQL database, as taught in this course, will be very valuable on the job for a Desktop Application Developer.
See salaries and explore the career path for Desktop Application Developer
Database Application Developer
A Database Application Developer specializes in creating and maintaining applications that interact with databases. This course provides a solid foundation in using C# .NET Core to build applications that connect to SQL Server databases, a critical skill for this role. You'll gain practical experience in designing database schemas, writing SQL queries, and implementing data access layers using ADO.NET. The course emphasizes the creation of data entry forms and reports, essential components of many database applications. This is why someone who wants to become a Database Application Developer should enroll in this course.
See salaries and explore the career path for Database Application Developer
Report Writer
A Report Writer designs and develops reports using various reporting tools. This course directly aligns with the skills needed to create reports using SAP Crystal Reports in C#, a key feature covered in the course. You'll learn to design and generate reports from SQL Server databases, incorporating data from various sources and presenting it in a user-friendly format. The course's hands-on approach to building applications with reporting capabilities provides practical experience essential for a Report Writer. Learning Crystal Reports and SQL is important for the Report Writer.
See salaries and explore the career path for Report Writer
Software Engineer
A Software Engineer designs, develops, tests, and maintains software systems and applications. This course may be useful for aspiring Software Engineers looking to specialize in developing applications using C# and SQL. You'll learn to build a complete application from scratch using C# .NET Core, incorporating features such as data entry forms, user management, and database integration. The skills to design databases and implement data access layers are applicable to a wide range of software development projects. The course's coverage of ADO.NET and SQL Server provides experience directly relevant to many software engineering roles.
See salaries and explore the career path for Software Engineer
Full-Stack Developer
A Full Stack Developer works on both the front-end and back-end components of web applications. This course may be useful for those interested in using C# .NET Core for back-end development, especially when interacting with SQL databases. By learning to build Windows Forms applications with database connectivity, you'll gain a foundational understanding of data management and application logic that is transferable to web development. The course's focus on SQL Server and ADO.NET is applicable to building robust and scalable web application back-ends, a common tool of a Full Stack Developer.
See salaries and explore the career path for Full-Stack Developer
Business Intelligence Developer
A Business Intelligence Developer designs and develops strategies to help businesses analyze data. This course may be useful because it covers SQL Server and SAP Crystal Reports, both relevant tools for business intelligence. The course provides skills in database design and report creation, which are fundamental to developing BI solutions. The course's emphasis on connecting C# applications to SQL Server for data retrieval and manipulation is directly applicable to building data dashboards and analytical tools. A Business Intelligence Developer must be fluent in database management, and this course may help them achieve that.
See salaries and explore the career path for Business Intelligence Developer
Data Analyst
A Data Analyst interprets data and turns it into information which can offer ways to improve a business. This course may be useful for Data Analysts to enhance their skills in accessing and manipulating data stored in SQL Server databases using C#. While primarily focused on application development, the course provides practical experience in writing SQL queries and using ADO.NET to retrieve and process data, a valuable skill for data analysis tasks. Moreover, the course makes use of SQL Server, one of several systems that a Data Analyst will use on the job to extract and work with data.
See salaries and explore the career path for Data Analyst
Application Support Analyst
An Application Support Analyst provides technical support for software applications. This course may be useful by giving you insight into the structure and functionality of C# .NET Core applications that connect to SQL Server databases. Understanding how these applications are built can help in diagnosing and resolving application issues more effectively. The course's focus on database connectivity and data management can be particularly valuable in troubleshooting data-related problems encountered by users. The Application Support Analyst will gain valuable insight from this course.
See salaries and explore the career path for Application Support Analyst
Software Development Engineer in Test
A Software Development Engineer in Test develops, maintains, and executes automated tests to ensure software quality. While not directly focused on testing, this course may be useful by providing a deeper understanding of C# .NET Core and SQL Server, the technologies being tested. Understanding how applications are built and how data is accessed helps in creating more effective and targeted test cases. The course experience in developing Windows Forms applications can be valuable in understanding the user interface and functionality that needs to be tested, potentially making one a stronger Software Development Engineer in Test.
See salaries and explore the career path for Software Development Engineer in Test
Software Consultant
A Software Consultant advises clients on how to best use software and technology to achieve their business goals. This course may be useful for a Software Consultant to understand the capabilities and limitations of C# .NET Core for building Windows applications with SQL Server databases. This knowledge can inform recommendations to clients about technology choices and project feasibility. Understanding the practical aspects of developing such applications, as covered in this course, can enhance the consultant's credibility and effectiveness. This is how this course may be useful to the Software Consultant.
See salaries and explore the career path for Software Consultant
Independent Consultant
An Independent Consultant provides expert advice and guidance to clients on a project basis, often specializing in a particular technology or industry. This course may be useful for Independent Consultants looking to expand their expertise in C# .NET Core development with SQL Server. The hands-on experience gained in building Windows Forms applications with database connectivity can be valuable for consulting projects involving custom software development or database integration. The practical skills acquired in this course can enhance an Independent Consultant’s ability to deliver effective solutions, something that clients especially value.
See salaries and explore the career path for Independent Consultant
Solutions Architect
A Solutions Architect is responsible for designing and implementing IT solutions that meet specific business needs. This course may be useful for gaining a practical understanding of how to build Windows-based applications using C# .NET Core and SQL Server, a common technology stack in many organizations. Understanding the development process, database integration, and user interface design, as covered in this course, is valuable for designing robust and scalable solutions. A Solutions Architect can be more effective on the job after grasping the basics of .NET.
See salaries and explore the career path for Solutions Architect
IT Support Specialist
An IT Support Specialist provides technical assistance to computer system users. While this course focuses on software development, it may be useful for gaining a better understanding of how applications are built and how databases function. This knowledge can be valuable in troubleshooting application issues and providing more effective support to end-users. The course's coverage of SQL Server and database connectivity can be particularly useful for resolving data-related problems. The IT Support Specialist can better solve issues in applications.
See salaries and explore the career path for IT Support Specialist
Software Architect
A Software Architect makes high-level design choices and dictates technical standards, including software coding standards, tools, and platforms. A course teaching C# .NET may be useful to a Software Architect because they must understand the capabilities of different languages. Software Architects should understand what is possible and how long it will take. While architects typically require significant experience, this course may help them learn more about the practical considerations when using this language.
See salaries and explore the career path for Software Architect
System Administrator
A System Administrator is responsible for the configuration, maintenance, and reliable operation of computer systems and servers. While primarily focused on software development, this course may be useful by providing a deeper understanding of how applications interact with databases and operating systems. This knowledge can be valuable in troubleshooting application deployment issues and optimizing system performance. The course's coverage of SQL Server may be particularly relevant for managing and maintaining database servers. The System Administrator needs to know how the system interacts with the hardware.
See salaries and explore the career path for System Administrator

Reading list

We've selected two books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Fast C# .NET Core Live Project in Windows Forms and SQL.
Cover image
C# 8.0 and .NET Core 3.0 – Modern Cross-Platform...
Save
Provides a comprehensive guide to C# and .NET Core, covering topics relevant to the course. It offers in-depth explanations and practical examples that can enhance your understanding of the concepts taught in the course. While not strictly required, it serves as a valuable reference for further exploration and solidifying your knowledge. It is commonly used as a textbook in academic settings.
C# 8.0 and .NET Core 3.0 – Modern Cross-Platform...
Paperback
Check
C# 8.0 and .NET Core 3.0 – Modern Cross-Platform...
Kindle Edition
Check
Cover image
SQL Server 2022 Administration Inside Out
Save
Delves into the administration aspects of SQL Server, providing a deeper understanding of database management. While the course focuses on using SQL within C#, this book offers valuable insights into the underlying database system. It is more valuable as additional reading for those interested in database administration. It is commonly used as a reference by database professionals.
SQL Server 2022 Administration Inside Out
Kindle Edition
$$

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Similar courses are unavailable at this time. Please try again later.
Effort
38 total hours
Via
Udemy
Instructor
Mega Learning
Language
English
Share and help others discover this course.
Facebook LinkedIn X Reddit Link Email
Don't miss out
Enroll today to gain access to this course
Enroll in this course
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser