HOW TO CONNECT C# WITH MYSQL DATABASE USING PHPMYADMIN

? Consider Supporting the Channel ? :
☕ Buying me a coffee https://buymeacoffee.com/programmingwith

Hello Everyone In this Tutorial we will learn step by step, how to create a c# application connect it with the MySQL database and add an Operation like View Using MySql PHPMyAdmin with wamp server. and in the next part of the video, we will learn how to insert, delete, update and search from the MySQL database using c# winform application.


HELLO EVERYONE IN THIS TUTORIAL I WILL SHOW YOU HOW
TO CONNECT MYSQL DATABASE WITH C# AND SHOW DATA FROM MYSQL DATABASE

STEP 1: WE NEED TO OPEA N VISUAL STUDIO CHOOSE WINDOWS FORM AND CREATE
NEW PROJECT AND NAME IT AS (csharpe_mysql).

STEP 2: WE NEED TO CREAA TE DATABASE IN MYSQL DATABASE OR YOU CAN USE
EXISTING DATABASE IN MYSQL DATABASE.

STEP 3: WE NEED TO OPEN OUR SOLUTION RIGHT-CLICKLICK ON THE REFERENCE AND
ADD (MySQL.data) TO OUR PROJECT FROM THE REFERENCE.


INSIDE THE REFERENCE WE DON'T HAVE MYSQL.DATA THERE.

SO WE NEED TO ADD THAT OKAY. SO LET'S ADD IT.


STEP 4: WE CAN DESIGN OUR FORM AND ADD DATAGRIDEVIEW TO OUR FORM SO THAT
WE CAN ABLE TO SEE OUR DATA FROM MYSQL DATABASE.


I will leave my design like that but if you want to make
yours more beautiful you push the video and continue when
you are done.


STEP 5: WE NEED TO ADD (using MySQL.data.mysqlclient) AT THE TOP
WHERE USING NAMESPACE ARE.


so let's view our code area to start our coding okay.


Conclusion

thank you for watching my tutorial please like share and subscribe to my channel for more upcoming tutorials and if you have any queries regarding the channel please leave your comments to the comments section. thank you once more.





STEP 6: WE CREATE OUR CONNECTION STRING.

STEP 7: WE CREATE OUR MYSQL CONNECTION.

STEP 8: WE RETRIEVE DATA FROM OUR MYSQL DATABASE.

STEP 9: WE WRITE THE REST OF THE CODE.

#singhatehalagie #c# #vb.net #vb #programmers #programming #code #sourcecode #mysql #phpmyadmin


#VisualStudio2019 Launch Event #Visual Studio2017 #materialskin #VisualStudio2015
#VisualStudio2012 #VisualStudio2011 #VisualStudio2010 #schoolmanagementsystem #librarymanagementsystem #billingmanagementsystem #winforms #materialskin #framwork, #linq #sqlserver #sqlserver2018 #sqlserver2014 #sqlserver2015 #sqlserver2008
#vb #vbnet #visualbasic #visualbasicdatabase #RetailPOS #PointOfSale #POS #EmployeeTrainingManagement #EmployeeManagement #EmployeeManagementSystem #EmployeeTrainingRecords #PersonnelManagement ##PersonnelManagementSystem #BankManagementSystem #BankingManagementSystem #BankManagement #Software #javaforandroid #CodeAMinute #iBasskungTutorial
#VisualCSharpe #CSharpe #Programming #MicrosoftAccess #AccessDatabase #SQLServer #MySQL #SQLite #phpMyAdmin #CrystalReports #EAN13BarcodeGenerator #Udemy #OnlineCourses #YouTube #playlist