
This is an introduction of this course.
Welcome note
What database(s) to use
Course objectives
Who am I?
Walk-around of the application we will build
In Part 2 I'll go through the different section in this training.
In this lecture we will download all necessary software DB Browser and Visual Studio 2017 Community
Installation of DB Browser
Installation of Visual Studio 2017 Community
The database we will be using through out the course is created in this lecture.
In this lecture we will create our project and also create the User Interface (UI)
We will install a software library for SQLite using NuGet in our project.
We will write the code to connect to the database and read out the data we entered in Section 2. When complete we have the R in CRUD.
Code refactoring is always very important to keep a clean and tidy codebase. It also make the application more maintainable.
After this Lecture we will have the C in CRUD
In this lecture we will start to do as some functionality in regards to menus connected to the DataGridView.
In this lecture we will finalize the Update functionality and at the end we will have U in CRUD.
In this Lecture we will write the code to Delete a record in the database. At the end we will have completed D in CRUD.
It also means that we have reached our objectives for this course. Do not fear, we have more work to do...
In Part 1 and Part 2 we will handle the application workflow, using the Buttons.
In Part 1 and Part 2 we will handle the application workflow, using the Buttons.
DataGridView is a great tool but reading a complete record here is not effective. We use a double-click event to display the record in our UI.
Now this CRUD application is complete and so is the Course. I will also mention what will happen after this.
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