Connect to MySQL with Visual Basic using Visual Studio 2010 - Tutorial

Important: Watch this full screen at 1080p resolution for best viewing.

Web address to download Connector/Net. This is required and installs the DLL needed to add to References.

I needed to do this recently and became frustrated with tutorials I found online. This shows you how to quickly get started and includes two different ways to read the data.

The command prompt at the beginning shows the database table I'll read in from Visual Studio, and I give read/write permission to a user referenced again in the connection string.

The indices used when filling in the textfield refer to the column index. You must specify the datatype when retreiving the data. Each while loop iteration is reading in a row.

[jkadoodle]

@Evilmasterization Glad you found it helpful! I made this just as I was figuring it all out myself. I realized shortly after that in addition to referencing the columns by index, you can also type in the column name in quotes. Much more useful.

[MegaAnakinn]

Thank you man! youre the best!
I needed to do some like this. im frustrated with tutorials online too.
two different ways to read the data and i only want it one
Thanlks a lot

[clauditza]

Thank you for this video! We need more :D

[CuddleTrouble]

I'm using VS 2005 so i had to use the connector version 6.1.6, but it still worked and i managed to connect it to a remote source without any problems.

[PIIUX]

Nice video! Thank you very much! it really helped me out with a project I am doing

[efuraa]

do you have an example of insert, update and delete?