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

preview_player
Показать описание
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.
Рекомендации по теме
Комментарии
Автор

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

jkadoodle
Автор

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

MegaAnakinn
Автор

Thank you for this video! We need more :D

clauditza
Автор

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.

CuddleTrouble
Автор

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

PIIUX
Автор

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

efuraa
welcome to shbcf.ru