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.

Trying to stay on task...

Wow... So many new goodies to play with and so very little time.

Sorry, if the updates are coming a bit slowly. The four dollars I've made via Google over the past few years just isn't quite enough to allow me to quit my day job. ;-)

So, work has had me really busy, and in my little bit of spare time I've been trying to diversify my talents by learning PHP with MySQL, exploring XNA with VB and trying to memorize the basic configuration, trying to support old tutorials, and considering ideas for new tutorials.

I know, I know... Just more excuses, right? :-P

Well, I have been working on another tutorial, though it's not quite as "game-centric" as the others. Actually, it is - but it isn't. I'll be outlining the very, very basics of employing a database (MySQL) for things like user account storage. While it promises to be a very elementary video, I will not be outlining MySQL configuration, and will expect that you already have an operable database and know how to create and manage your own tables. All I will be demonstrating is how you can connect to it with VB.NET using the ADO.NET driver.

In the first video we'll focus on:
1.) Establishing a connection to a MySQL database with Visual Basic 2010
2.) Accessing table data
3.) Joining two tables with SQL to access relational data (TOONS by USER ACCOUNT)
4.) Closing the connection

Depending upon how this tutorial is received, future videos may go a bit deeper and may include record insertion and whatnot.

Sooo, that's where I'm at, right now.

Take care, and thank you for stopping by! :-)

Aardaerimus

XNA is on the way!!! *HAPPY HAPPY, JOY JOY*

The XNA over VB barrier has finally been shattered - many thanks to Kalamus1 for his demonstration and for pointing me to a tremendous new resource by rm2kdev: http://www.xnatutor.com/


I still have a long road of learning ahead of me to fully understand and transition my older works to XNA, but I'm thinking that it will be a huge benefit to us all.

With GDI+ I was putting up with frame rates of around 22FPS - at super low resolution even - and many users were bogging down to around 1FPS... When Kalamus1 sent me my own tutorial source adapted to XNA, I totally freaked! My shoddy 22 FPS had exploded to nearly 4000FPS!

The next test was to run the project at full screen. It scaled up very nicely and was still blazing along at around 3000FPS.

Mind you, this was on my monster quad-core workhorse computer at work. The next test would be to execute the project on my older dual-core laptop, at home. The results were still a screaming 2400 FPS!

Keep in mind that most production games will be ticking along at significantly slower speeds. Playing World of Warcraft, for instance, I'm lucky to be getting between 25-35 FPS, and it's still smooth. People with souped up machines and high-end video cards might be enjoying between 60-120 FPS on modern games.

With that in mind, even 1000 FPS would be ridiculous. Of course, this should decline steeply as the complexity of  our code routines grow, and in some instances we might even be forced to limit the FPS to a fixed rate, but at least we can shed the nagging concern that our apps may well give an abysmal performance on machines that may not have been as gutsy as the primary development environment.

Another VB Game Programming Tutorial ~ Creating Classes and Managing Object Arrays

This Visual Basic programming tutorial is designed to complement my Visual Basic Game Programming series, but is not limited to game design. It is designed to teach you how to create a custom VB Object Class, store your class to an object array, then create and delete multiple instances of that class on the fly.

In this VB programming video, we will be performing the following tasks:
1.) Building a simple game/application loop
2.) Build a (GDI+) graphical interface for painting objects to the main form
3.) Build a custom class with graphical properties and embedded timer objects and self-contained events
4.) Teach the objects to interface with the form environment while remaining autonomous
5.) Create a class/object array to store a desired number of objects from our class
6.) Use random numbers to dynamically generate new and diverse instances of our custom class
7.) Destroy specific objects by deleting them from our array when certain conditions are met.

PROJECT SOURCE CODE: http://www.aardaerimus.com/downloads/classtutorial/

A Suite Symphony Playing in the Key of 'Free' - Part One

I'd wager that most code hobbyists, like myself, lack the resources (read 'cash') to blow on expensive tools for their projects.

For that reason, I just thought I'd pass on a number of awesome - and totally free - goodies to help create your project content. Just because they're free does not mean they aren't powerful. Also, this does not necessarily mean that they're lacking in complexity and have no learning curve.

I'll start with a few of my favorite graphics tools.

GRAPHICS & SPRITING TOOLS:

GIMP - Gnu Image Manipulation Program [http://www.gimp.org]

Gimp is truly a powerhouse among 2D photo editors. Boasting most of the editing capabilities of expensive photo editors, like Adobe's popular Photoshop, Gimp is often the top free choice for spriting and other 2D graphics manipulation. There are numerous free plug-ins and brush packs available to extend its capabilities, as well.

Gimp handles all popular file formats like a champ.


Inkscape - Vector Drawing Program [http://inkscape.org]

Inkscape is a fairly simple, yet powerful vector graphics drawing program. With Inkscape, I found it tremendously easy to generate beautiful images for things like graphical buttons and logos. Of course, this is only scratching the surface of Inkscape's capabilities.

There are some really helpful tutorials and demonstrations of Inkscape's capabilities out on YouTube, and I found them to be very instrumental in getting me started.

GraphicsGale - Pixel Art & Animation Maker [http://www.humanbalance.net/gale/us/]

I only recently discovered this amazing little gem and it has totally altered my approach to pixel art and has dramatically decreased the amount of time it takes me to create sprites, icons, and tile objects for my games!

As a wanna-be game designer, I've found it surprisingly difficult to produce pixel art of any quality, and the more powerful photo-editors tend to only complicate the fine art of pixelcraft by possessing countless functions and menus that are really of little use for such up close and in-your-face artwork.

It really is so simple a seven year old can use it, but in its simplicity it is mighty.

To sweeten the deal even further, it can also be used to generate animations. This is a must-have tool, if you're designing your own 2D game!


Blender - 3D Modeling, Animation, and Game Creator [http://www.blender.org/]

Blender... Wow... Where to even start?? I still can't believe that this magnificent beast of a modeling program is free! Blender is right up there with the top dogs of 3D modeling. Possessing incredible 3D modeling, rendering, and movie production capabilities, countless plug-ins and extensions, scripting capabilities, and even a built-in game design environment, Blender stands in a class of its own.

I could rant and rave about it all day long, but I think I'd best just let the work of the Blender community stand on its own and show you what it can do:




Blender Art Gallery

Sintel

Big Buck Bunny

More Blender Made Movies


Most of these are fairly old. If you Google about a bit you'll find tons of mind-blowing art produced with Blender.

Awesome as it is, one major drawback with any major 3D design suite is the learning curve. Be prepared to invest a great deal of time in conquering this behemoth.

Lucky for us we can stand on the shoulders of the Blender heroes that have come before us and kindly created countless awesome tutorials.

Several Blender masters have produced tutorials that are an invaluable resource to the aspiring designer. Among my favorites are:

• Blender Guru - By Andrew Price (Check out his Nature Academy. I guarantee you'll be dazzled!)
• BlenderCookie - More awesome tutorials on virtually every facet of Blender

Good luck out there! If you know of any other awesome [FREE] graphics tools out there that you'd like to add to the list, then please feel free to share!

Take care, all!

~ Aardaerimus

Your thoughts on mundane items and activities in game?

Many games feature mundane activities, items, or objectives.

A few, for example, might be:

• Feeding your characters
• Day/night cycles
• Resting for character/party recovery
• Crafting

Numerous games have foregone such things, and have still been wildly successful - games like the Final Fantasy series, for instance. Many others, however, feature systems for time cycles, resource gathering, crafting, and other tasks that could be considered irrelevant to play or the general game objective - yet have found tremendous interest in game communities.

My question to you is:

Do you feel that adding mundane articles to games brings added realism and depth to a game, or do you feel that it's pointless or could possibly even detract from the enjoyment of a game, or simply should not be included unless it somehow adds to the story or is specifically required to complete a game?

Visual Basic Game Programming Tutorial - Part 7 - Saving and Loading Map Data

[Watch in 720p High Definition]


The 7th installment of my Visual Basic 2010 GDI+ game programming series.

In this video tutorial we're covering how to read and write comma delimited map data from/to a text file.

GDI+ Game Programming Series - Part 6 - Terrain Collision

[Watch in 720p High Definition]

GDI+ Game Programming Series - Part 5 - Transparent Brushes and Custom Dialog Boxes

[Watch in 720p High Definition]

GDI+ Game Programming Series - Part 4 UPDATE - Improved Key Input and Character Movement

[Watch in 720p High Definition]

GDI+ Game Programming Series - Part 4 - Key Input and Character Movement

[Watch in 720p High Definition]

GDI+ Game Programming Series - Part 3 - Graphics and Tile Mapping

[Watch in 720p High Definition]

GDI+ Game Programming Series - Part 2 - Handling Mouse Input

[Watch in 720p High Definition]