Visual Studio, C# and SQL Server - Creating a Windows Forms CRUD Application
13,118
Published 2022-11-15
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.🥰
-
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.
-
Nice, Thanks! I did all steps. So next is small CRM app.
-
Amazing!
-
Thank you for this good tute
-
Thank you
-
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.
-
Thanks
-
Great video. Can you share the source code of this project?
-
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?
-
Can you share the source code of this project?