MYSQL

While I was trying to convert TreeView Control to work with MySQL I encounter an error with concurrent connection using DataReader. The error message was “ There is already an open DataReader associated with this Connection which must be closed first”. Even the Microsoft KB does not help in solving this problem. The workaround on this problem is to create another connection to avoid this error

I received a lot of email if I can make a tutorial on how to connect VB.NET with MySQL. So here it is. I am planning to continue this tutorial that is similar on my previous article on Database Programming Made Easy. The only difference with the previous one is that I will be using MySQL instead of MS Access and MS SQL Server. This tutorial will teach you how to connect Visual Basic .NET 2008 to

a simple database app that can be used to manipulate your website's MYSQL database, applicable in administrating your web databse from your Windows based PC .Connection is via MySQL ODBC 3.51 Driver. CAn perform CRUD and it shows how to connect and query records in a remote server (for this sample i used www.freesql.org) using ADOdb control and datagrid to show data from remote server.. I'll Post