I am working on a project using MySQL and Visual Basic 2010. I have a database in MySQL which I have bound to my
VB 2010 program using the MySQL .NET Connector. I was able to bind it not via code but by going to Data > Add Data
Sources in the Visual Basic IDE. I did it this way because I found it hard to display my data on textboxes using the
datareader function of the .net connector. I was able to just drag textboxes and create command buttons that allows
me to navigate through my database.
I am not quite sure on how to do add, edit, save and delete data using VB 2010. I know how to do this via the MySQL
Workbench but I am having a hard time in VB 2010 since I am not that familiar with it. I did some reading and still
I can't get it to work the way I want it to. I think it is different comparing to VB6 (this is what I've used 5 years
I am not even sure if this is the correct way of doing this or there is an easier and more efficient way.
For those of you who have experience working with MySQL and VB 2010, I would like to ask for your guidance in this matter
or perhaps you can link me to a complete step by step tutorial. The tutorials that I have seen only made examples by
using the Console.Writeline command which I found to be not working in VB 2010, I wanted to display data in textboxes, datagrids
etc. and not on the console as so as to create a good program. Also on how to compute using VB 2010 and MySQL database.
Please help me in any way you can. Please if you're not too busy, perhaps we can also do this via chat.