CRUD application using C#, SQLite, and Windows Forms

CRUD application using C#, SQLite, and Windows Forms, available at $44.99, has an average rating of 3.35, with 32 lectures, based on 64 reviews, and has 237 subscribers.

You will learn about C# programming using Windows Forms and SQLite as the database and where we will create an Applicaiton that can Create, Read, Update and Delete records. Keep the code to a minimum and as simple as possible You will gain skills using SQLite database and DB Browser to create and manage the database. You will feel more confident using C# and Windows Forms after this course. This course is ideal for individuals who are Anyone that needs to understand how to create a SQLIte CRUD database application using C# and Windows Forms. It is particularly useful for Anyone that needs to understand how to create a SQLIte CRUD database application using C# and Windows Forms.

Enroll now: CRUD application using C#, SQLite, and Windows Forms

Summary

Title: CRUD application using C#, SQLite, and Windows Forms

Price: $44.99

Average Rating: 3.35

Number of Lectures: 32

Number of Published Lectures: 32

Number of Curriculum Items: 32

Number of Published Curriculum Objects: 32

Original Price: $22.99

Quality Status: approved

Status: Live

What You Will Learn

C# programming using Windows Forms and SQLite as the database and where we will create an Applicaiton that can Create, Read, Update and Delete records.

Keep the code to a minimum and as simple as possible

You will gain skills using SQLite database and DB Browser to create and manage the database.

You will feel more confident using C# and Windows Forms after this course.

Who Should Attend

Anyone that needs to understand how to create a SQLIte CRUD database application using C# and Windows Forms.

Target Audiences

Anyone that needs to understand how to create a SQLIte CRUD database application using C# and Windows Forms.

This course, with 10 sections, will give you the knowledge how to use C# to create a full CRUD (create, read, update, delete) application using Windows Forms and SQLite.

Now with Part 2 available you will have 15 sections where I added Exception handling and Search functionality.

We are going to use Visual Studio 2017 Community edition and create this CRUD application with SQLite as the database. We will also be using a supporting tool for SQLite that is called DB Browser. We will use DB Browser to create the database, and also when we’re extending the database in Part 2.

For those of you have Visual Studio 2019, you can just go ahead and join in. I have tested all code using Visual Studio 2019 without any issues.

You will find a number of downloads in some of the section /lectures that will help you with some details and definitions. You will also find the source code itself for download.

Tools and development environment can be downloaded for free – full instructions inside this course in regard to installation and configuration.

At the end of this course, you will be confident of writing your own CRUD applications using C# and SQLite database.

You can find more detailed information at my BLOG. See my instructor page for the link

Course Curriculum

Chapter 1: Introduction 1

Lecture 1: 1. Welcome note,

Lecture 2: Go through the different section of this course.

Chapter 2: Download and install needed software

Lecture 1: Download instructions

Lecture 2: Installation of DB Browser

Lecture 3: Installation of Visual Studio 2017 Community

Chapter 3: Creation of the Database

Lecture 1: Creation of the database using DB Browser

Chapter 4: Creation of our project

Lecture 1: The creation of the User Interface (UI)

Lecture 2: Installation of SQLite library (NuGet)

Chapter 5: Database connection and Read & Create

Lecture 1: Create the database connection, Read the data entered in Section 2.

Lecture 2: Code refactoring and changes of the User Interface (UI)

Lecture 3: Create records in the databse

Chapter 6: Updata a record in the database

Lecture 1: Update Part 1

Lecture 2: Update Part 2

Chapter 7: Delete records in the database

Lecture 1: Delete a record in the database.

Chapter 8: Buttons, buttons, and more buttons

Lecture 1: Button Part 1

Lecture 2: Button Part 2

Chapter 9: Bonus section – DataGridView double-click event

Lecture 1: Double-Click event and Message boxes.

Chapter 10: Wrap-Up of this course

Lecture 1: Wrap-Up

Chapter 11: Section 11 – Introduction for Part 2

Lecture 1: Introduction

Chapter 12: Section 12 – Extending database and UI

Lecture 1: Database changes

Lecture 2: Code clean-up

Lecture 3: UI changes

Lecture 4: Updates of database methods

Chapter 13: Section 13 – Exception handling

Lecture 1: Try/Catch/Finally example

Lecture 2: Different types of errors

Lecture 3: Modifying methods 1

Lecture 4: Modifying methods 2

Lecture 5: Modifying methods 3

Lecture 6: Modifying methods 4

Chapter 14: Section 14 – Search functionality

Lecture 1: Add search UI

Lecture 2: The search code

Chapter 15: Section 15 – Thank you!

Lecture 1: Course Wrap-up Part 2

Instructors

Peder Thornstrom
Cyber Security Consultant

Rating Distribution

1 stars: 2 votes

2 stars: 5 votes

3 stars: 18 votes

4 stars: 27 votes

5 stars: 12 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!