CRUD application using C#, SQLite, and Windows Forms

Visual Studio 2017/2019 Community, C#, SQLite, DB Browser

3.35 (62 reviews)

Udemy

platform

English

language

Databases

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.

Why take this course?

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

Reviews

Jay

September 15, 2023

There were some inconsistencies in the presentation that confused me, but overall a very good course to teach basics of C# and SQLite. Recommended.

George

January 17, 2023

The instructor makes the course very hard to follow as he is unprepared and has to keep correcting his own mistakes. He has also chosen as an example a 12 field record as an example, which makes for extremely long command strings, making the possibility of typing mistakes very likely. I'm an experienced programmer, and I had trouble following it, especially when he says "I'll just pause this while I type the code in", and then presents the student with a huge line of pre-written code which vanishes off the screen at both sides. The quality of the sound is pretty poor as well, I had to have my sound turned up to the top stop to hear episode 12 at all.

Rodolfo

December 18, 2022

The course provides a good intro to SQLite with a simple to follow example, I'd say good stuff. However , I did find irritating the sound quality of some of the lectures

Dickson

September 21, 2020

The instructor took a subject area I often found intimidating and really simplified it. I'm looking forward to more material from him.

Mirosław

August 21, 2020

Voice in each part is different. Too many words for simple information. This presentation can be 50% shorter!

David

June 16, 2020

So Far so Good. I am trying this with WFP so there are a few differences that I have to work through

Constantino

March 31, 2020

I liked the course but I need to pause and zoom in on the screen a lot of the time. It would be great if you were able to zoom in when you typing in code. I would also recommend providing the files as a resource. I also noticed that the volume from one video to the next would be way different. Going for soft to loud, too loud. Anyways good information.

Joel

August 15, 2019

The instructor accomplish the initial objectives of the course and added a couple of bonus objectives at the end. The instructor was very knowledgeable of the subject matter and was clear in communicating the topics at hand. However, the video recording needs improvement. The sound volume was not consistent throughout. At times it was so low you had to turn up the volume all the way, then when the next video started you are blasted because the volume had changed. Another issue with the video, the instructor needed to zoom in to where he was typing the code so it could be readable on the screen. His entire Visual Studio was left on the screen throughout the video, making it hard to read the code. All in all, I enjoyed the course and learned a few things in the process. I am looking forward to a more advance course on SQLite using C# with a more in-depth explanation of SQLite and ADO .NET constructs, such as, DataAdapters, DataReaders, ExecuteNonQuery, etc. I would also see an application that uses multiple tables, as well as, Parent and Child Tables and Rollbacks.

Jesus

April 4, 2019

I think this is a good course to teach anybody to develop a CRUD program in a very easy way. If you are looking for a way to CRUD a table instead of Entity Framework, this is the right course.

Mike

April 3, 2019

Several video glitches, a skipped section here, a couple of duplicated sections there... Overall, it was useful, and I was able to catch up on the missing clip. Also, I'm playing at 2x speed to not be bored.

Daniel

February 23, 2019

The information presented is exactly what I was looking for. Some previous knowledge of programming can be handy, but is not required. Some knowledge is assumed though.

Charts

Price

Rating

Enrollment distribution

CRUD application using C#, SQLite, and Windows Forms - Distribution chart