How to operate MySQL Databases in VB. NET

This is a class library written in VB. NET to connect to MySQL. You can use this class library to directly operate MySQL databases.
　　
Before using this class library, you must install
ODBC MySQL 3.51: http://www.mysql.com/downloads/api-myodbc-3.51.html
Driver ODBC. Net: http://www.microsoft.com/downloads/details. aspx? Familyid = 6ccd8427-1017-4f33-a062-d165078e32b1 & displaylang = en
　　
There are three classes in this library:
Manipstringformysql: This class modifies the sgbd string
Mysql_requettes: send a request
Mysql_utils: Test sgbd data
　　
The following is an example of using this library to operate MySQL.
 

Code:

1. 'Operate Dataset
3. Public shared function mydbcdataset (byval reqsql as string ,_
4. Byval labase as string, byval server as string ,_
5. Byval password as string, byval user as string ,_
6. Byval nomdataset as string) as Dataset
7. 'Xxion à un server MySQL
8. 'Avec le driver ODBC 3.51 avec requette qui renvoie UN Dataset
9. Dim myconstring as string = _
10. "Driver = {MySQL ODBC 3.51 driver}; server =" & server _
11. & "; Database =" & labase & "; uid =" & User _
12. & "; Password =" & password & "; option = 3 ;"
14. Dim mydbcconnexion as new odbcconnection (myconstring)
15. Try
16. Dim ds as new dataset ()
17. Dim cmd as odbcdataadapter = new
18. Odbcdataadapter (reqsql, myconstring)
19. Dim mycommand as new odbccommand ()
20. Dim mydatareader as odbcdatareader
21. Cmd. Fill (DS, nomdataset)
22. Mydbcconnexion. Close ()
23. Return DS
24. Catch mydbcexception as odbcexception
25. '
26. Httpcontext. Current. response. Write (mydbcexception. tostring)
27. Catch myexception as exception
28. '
29. Httpcontext. Current. response. Write (myexception. tostring)
30. End try
31. End Function
33. 'Call the Function
35. Dim mondatasettemp as dataset = mysql_requettes.mydbcdataset (
36. SQL,
37. Constantes. odbcbase,
38. Constantes. odbcserver,
39. Constantes. odbcpwd,
40. Constantes. odbcuser,
41. "Mondataset ")

The class library used by this program can be downloaded at the address below: http://www.codeproject.com/dotnet/MySQLConnexion/MySQLConnexion.zip