MySQL and VB 2010 Database Administration

[fidgramos]

Good Day!

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.

ex. Me.BindingSource.MoveFirst()

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
ago).

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.

Thank you.

[SystemX]

The way i work with MYSQL is always the php side. Meaning i use online MYSQL and make php files to connect to the database to read.write ect.

Then for VB i would use webrequests to read/write to the php file. So all the MYSQ work is done through a php script. This is much easyer than it sounds and the php file code would only be a few lines of code to connect to the database.

Then VB code can be just a few lines for the webrequests.

Thanks

[fidgramos]

My reason for using vb 2010 is that my Project would require printing several reports and I am not sure on how to do it in other programming languages. I am not trained with PHP and as far as Object Oriented Programming, it is VB that I have a little bit of background. If only I knew how to do things with PHP then I might be able to do it. However, I have to produce this the soonest time possible.

If you can help me in any way, I would really appreciate that.

[fidgramos]

The way i work with MYSQL is always the php side. Meaning i use online MYSQL and make php files to connect to the database to read.write ect.

Then for VB i would use webrequests to read/write to the php file. So all the MYSQ work is done through a php script. This is much easyer than it sounds and the php file code would only be a few lines of code to connect to the database.

Then VB code can be just a few lines for the webrequests.

Thanks

Some examples please.

[techgnome]

Ignore PHP...it isn't relevant to the question or problem at hand.
Look in the database fourm... there is a database faq&tutorial thread... should answer some of the basic questions.

-tg

[techgnome]

In fact, here... here's a link to it directly...
http://www.vbforums.com/showthread.php?t=337051

-tg