Visual Basic Programming Tutorial - Connecting to a MySQL Database with VB.NET Using ADO.NET

In this Visual Basic 2010 programming tutorial, we'll be connecting to and pulling data from a MySQL database, utilizing the ADO.NET connector provided at http://www.mysql.com/products/connector/

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.

Category:

People & Blogs

Tags:

• Visual
• Basic
• Programming
• MySQL
• Connection
• Tutorial
• windows
• Game
• Development
• Aardaerimus
• ADO.NET
• ADO
• VB.NET
• VB
• 2010

[victorpictor]

Great video! Don't you happen to have a tutorial to connect to a Postgresql server?

[Aardaerimus]

@victorpictor Thank you, Victor. :-)

Unfortunately, I've never attempted a connection to postgresql with VB, though there does appear to be a couple different data providers out there for it. Try googling "npgsql" or "psqlODBC". Hope this gets you on the right path. :-)

[Rardon99]

if u compile a program with SQL in it dose other PC have to have SQL installed on them to run yr program?

great videos btw ::)

[Aardaerimus]

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

[DrunkenWaffle]

Whoa! I wish I knew how to do this... Really want to learn how to make an online game. Maybe I can figure it out using this tutorial!

*watches*

:O!!! C++ Driver for MySQL? This sounds exciting. Alright, I'm looking into this.

[Aardaerimus]

@DrunkenWaffle Yup! The C++ Driver is on the same download page. :-D

Should be very similar, connection-wise. I've also used this with ASP, and just learned the same with PHP. Good stuff! :-)

A DB makes certain kinds of storage soooo nice. Good for "save game" data, and user accounts, and lotsa other stuffs, and the nice thing is all the data you pull to and enter from your game or application is also easily pulled into web pages.

I've made my own web apps and forums from scratch with it. :-D

[DrunkenWaffle]

@Aardaerimus :O! Awesome! You will definitely pull an awesome project together in the future... I can't wait to see it :D

I'm definitely looking into this soon. :P