Visual Studio, C# and SQL Server - Creating a Windows Forms CRUD Application

Published 2022-11-15
We will create a basic Windows Forms Application in Visual Studio with CRUD functionality. It will communicate with an SQL Server Database. It will Insert, Retrieve, Update and Delete Data using an SQL Server Database. The Application will be created in iterations, i.e., step by step. It will be some copy-paste to save time and not all details will be explained in detail. So, it is assumed that you are familiar with basic Visual Studio and C# Programming.

PowerPoint (PDF) used in the Video: www.halvorsen.blog/documents/programming/csharp/re…

Blog:
www.halvorsen.blog/

YouTube Channel @Industrial IT and Automation ​
youtube.com/IndustrialITandAutomation

Visual Studio and C# Resources:
www.halvorsen.blog/documents/programming/csharp/

Chapters:
00:00 Introduction
04:17 SQL Server Database
07:52 Visual Studio
08:22 Main Form
24:15 New Book Form
42:49 Edit Book Form
59:59: Finalizing Application

All Comments (12)
  • Thank you, it was great!!! You have introduce me to develop in forms and now I'am able to continue. Your help was very very important!!! I also appreciare it massively, God will give you a hundredfold.🥰
  • @tiber4159
    Ok, so I just finished this tutorial and Wow, I thought i was struggling with the basics but this has put so many pieces into place. Thank you for this, appreciate it massively.
  • @Janka642
    Nice, Thanks! I did all steps. So next is small CRM app.
  • @JgM-ie5jy
    Excellent. I especially liked how to use SQL Server from Visual Studio. The use of a config file to allow entering the connection string to the SQL Server database without having to hard-code it in the source code was a nice touch. A suggestion to make the app even more professional would be to replace the text boxes for the Author, Publisher and Category with combo boxes. I saw an example of how text boxes could allow poorly trained clerks in a large government organization to enter 46 different versions of the same manufacturer (even though it was a very well-known manufacturer). This combined with various flavors for the same model of equipment n a database of over 7 million records rendered the chore of creating various reports extremely difficult. A more professional approach would have been to have a centrally-administered list of manufactures and models shown in combo boxes to force the users to enter properly vetted data.
  • @jabescript
    Great video. Can you share the source code of this project?
  • @Maayan_1
    Hi Halvorsen, can I use WinForm to create a search bar connecting to database and find each item by typing is name or id and view it in the form window?