C# MySql CRUD : Insert Update Delete View and Search


How to Implement CRUD Operations Like Insert Update Delete View and Search in C# Using MySql Server.

In this Step by Step Tutorial, we will discuss how to create a c# application to implement CRUD Operations like Insert Update Delete View and Search Using MySql Server Stored Procedures. Sample Demo Project is Created in Windows Form Application Even though You can use this method in any c# application with MySql DataBase.

? Best C# Book from Amazon (Affiliate)

Download Project From :

☕ Buy me a Coffee (Channel Support through Donation)

Subscribe to this channel Link to this video
➤ ➤

________________ ? Related Videos __________________
: Similar Mvc Tutorials
: Similar C# Video Tutorials

________________ ? About this Channel ______________
CodAffection – [ New videos every Monday at 12:30 PM UTC. ].
This channel is all about teaching and motivating software developers to build applications/ websites in various technologies/ programming languages like Angular, NodeJS, Asp.Net, C#, JavaScript, SQL, Python, etc.

________________ ? Social Media Links ______________
Blog :
Facebook :
Twitter :
Youtube :

________________ ? Most Recommended Books _______
Code Complete(2nd Edition) :
The Art of Computer Programming :
Clean Code :
Design Patterns :
The Pragmatic Programmer :

________________ ? Purchase for Developers _________
? Laptops
MacBook Air :
Dell XPS 9570 :
ASUS ZenBook 13 :
Lenovo Ideapad :
⌨️ Keyboard : Das 4 Professional :
?️ Mouse : VicTsing :
? Headphone : Mpow 059 Bluetooth :

________________ ? All Playlist _______________________
: Angular
: Asp.Net Core
: Node JS
: Asp.Net MVC
: Web API
: MEAN Stack
: C# Tutorial
: Asp.Net WebForm
: C# WinForm
: Crystal Report
: Common C# Excercises
: CG Exercises in C Program

#CSharpTutorial #CodAffection #CodAffectionCSharpTutorial



  1. https://goo.gl/RFY5C2 : Subscribe to CodAffection
    https://goo.gl/ejEvDb : MS SQL CRUD Operations in SQL Server
    https://goo.gl/NhNQeZ :Export Excel in C# Applications
    https://goo.gl/WsgPbp :C# User Registration With DB

  2. Thank you very very very much for you kindness. Someday, when I become a software billionare I will remember you and reward you for this class.

  3. The connection string is this one:

    string connectionString = @"Server=localhost;Database=bookdb;Uid=root;Pwd=root;";

    However when I test the program in Visual Studio 2017, I always get the same error after clicking the 'Search' button:


    On the left you can see I successfully connected from Visual Studio
    to the bookdb from MySQL Workbench, but I'm unable to correctly connect
    from the project itself to the bookdb, even when the connectionstring
    seems to be all right

    Any ideas?


  4. Can you make a video where you have to tabels with a relationship, one to many etc. and how you can show a entryfield in the GUI. Thanks a lot for this video, its GREAT ! 🙂

  5. I have an error like this , please tell me how to fix this : 'MySql.Data.MySqlClient.MySqlException' occurred in MySql.Data.dll

    The host localhost does not support SSL connections.

  6. your tutorial is really great but I need to make the published program not project can you make a new tutorial for that (like for transferring our application to another computer)

  7. how to fix the error when txtBookName shows an error " txtBookName doesnot exist in the current context" ….can anyone please help me.

  8. Bro your tutorials are so good easy to understand I request you to make a tutorial on like how to give product discount like 5%, 10%, 12%, etc depends customers visit to my medical retail pharmacy I hope you will help me

  9. In the line mysqlCon.Open(); I get the error: System.NullReferenceException: 'Object reference not set to an instance of an object.' And I cannot find anything wrong in my connectionstring.

  10. can someone please assist me i have followed the tutorial exactly how he did it but i keep getting this error…….
    An unhandled exception of type 'System.ArgumentException' occurred in System.Data.dll

  11. I don't have that mysql folder in my drive C do I need to download something so I can have that dll that needs to be added on the references part?


Please enter your comment!
Please enter your name here