VB.NET Database Tutorial - Connect to a MySQL Database (Visual Basic .NET)

In this video, we will perform the following tasks:
1.) Creating the Connection Objects, a Connection String, and a Query String
2.) Connecting to our MySQL Database
3.) Drawing Data from our Database to our Windows Form
4.) Filtering our query results, and sorting the data
5.) Creating a Table Relationship to pull data from multiple tables
6.) Disconnecting from the Database

This tutorial assumes that you already have an operable MySQL database, access to the database, and a basic working knowledge of your database.

Tip Jar:

:-)

[AardaerimusDAritonyss]

And thank you, Kennycelt, for the positive feedback! :-D

[ahmadsaid]

Hello Aardaerimus - Full greeting from Dubai - I'm just suprised that you giving us these imp information for free :) - thank you very much mate - and keep going with ur projects - thanks again.

[SteveSmith-ghyh]

Great tutorial. It was extremely helpful and easy to follow.

[AardaerimusDAritonyss]

Always a pleasure to help where I can. :-D

[LookAnotherStreamer]

You made it easier to understand, For that you have my gratitude :D

[AardaerimusDAritonyss]

Awesome! I'm very happy to hear that this was helpful! Good luck on your projects, cubbigdog. :-D

[kennycelt]

Absolutely excellent tutorial, thanks so much.

[julesganalon]

super thanks bro! it was a big help for my thesis ! good job! more powers :)

[SuvroImran]

thanks Aardaerimus, this is very help full. i love this one.

[AardaerimusDAritonyss]

Hey there! Thanks for stopping in. :-) If you go to my channel you'll see that I have a follow-up tutorial under "Database Tutorials" showing how to insert and update records as well. :-D Enjoy!

[AardaerimusDAritonyss]

You could launch a query from the listbox selection with the Click event.

Create a query sub like: CheckUser(username as string)

Then add it to your Click event for your listbox like:

Have the query sub populate the form fields from the sub.

[budgetbeatsmusic]

Great stuff you put online, love to watch :D great work, good explain of the codes also, Great :) dim aardaerimus as topnotch programmer!

[gerritvoorn]

Thanks Aardaerimus,  
This is a very helpful tutorial, , I hope you've written more tutorial

[AardaerimusDAritonyss]

@Rardon99 Thank you Rardon99. :-)
Yes, they will have to have an functional and accessible installation of MySQL on their computer or another accessible server. What you CAN compile with your program are SQL scripts that will configure a new database on their server, and create the table structure. This is a standard practice for database applications.
Another environment, is a game server where the database is only accessible to the server (user accounts, etc.) and the users won't see it. :-)

[AardaerimusDAritonyss]

I definitely need to post a followup video to demo this. ;-) I'll PM you the instructions though.

[nikey]

If you don't mind being cheap you could install "WAMP", which has "MySQL", "Php", "Apache" and a few other things all bundled together.

This will install a WebGUI for dealing with MySQL Tables, called "PhpMyAdmin".

PhpMyAdmin is essentially the most used (imo) Database Manager.

[KieranCrown]

Awesome video. Helped a lot. Before I was using FTP for everything :/

[AardaerimusDAritonyss]

Welcome, AbuLaila Ahmed! :-) Sorry for the slow reply.

I haven't tried setting up the MySQL connection as a VB.NET "Data Source" but I believe that it is indeed possible. Once you've installed the ADO connector, you shoulf have the option of creating a new MySQL data source connection. :-)

[AardaerimusDAritonyss]

Wow! That's very exciting to hear! :-D

[AardaerimusDAritonyss]

I do all of my tutorials for free on my own time, so I feel that it's only fair to collect a few pennies in this way. That said, I fully support my viewers' right to ignore or block them. There are several browser based addons for blocking them. If you wish to block them, feel free, but I greatly appreciate the contributions of kind souls. :-)