VB.net application connected to a MySQL database

Hi all,
I am writing a program in VB.net 2008 and I want its users to be able to connect to a MySQL database on my host to alter specific fields there.

Anyone knows how to establish this connection?

 

Set the connection string in your web.config file like this:

<appSettings>
<add key="mySQLDSN" value="Driver={MySQL ODBC 3.51 Driver}; Server=YOUR_SERVER_OR_IP; Database=BD_NAME;uid=DB_USER; pwd=DB_PASS;" />
</appSettings>

Then open the connection like this:

Dim myODBCConnection as New OdbcConnection(ConfigurationManager.AppSettings("mySQLDSN"))
Dim myODBCCommand as New OdbcCommand

 

Ok, now how do I alter the database data? What tools do I need and what code please?

 

For that, you should buy a book to learn ASP.NET or google for some asp.net database tutorials like this one:

http://www.w3schools.com/ASPNET/default.asp

 

VB.NET has ways to access database , you do not need any tool you need to code it using VB.NET .