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.
http://www.mysql.com/downloads/connector/net/

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.

Category:

Science & Technology

Tags:

• MySQL
• Visual Studio
• Visual Basic
• Database
• Tutorial

[Evilmasterization]

Thank you, help me a lot

[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.

[AloneinSpace]

Hey Thank you very much for posting this video you help so much !Could you make a sequel where they would be performed on the same basis of writing and erasing add new data?All best man !