ODBC Connectivity with .net and Mysql.

1. First you have to install Mysql Odbc Connector from the below link.
    http://dev.mysql.com/downloads/connector/odbc/
    than install the driver.
2. You have to add DSN (Data Source Name) to the system.
    Procedure to add DSN:
    Control Panel -> Administrative tool -> Data Source ODBC -> Add User DSN -> Select
    Mysql ODBC Driver -> Finish.
     Data Source Name = Name of your DSN
     Description : Leave blank (not manditory)
     TCP/IP Server : localhost
      User : root
      Password : leave blank (not manditory)
      Database : Your database
   
  After that test connection and click ok..
You have successfully create your DSN.

Than you use this DSN to every form which you want to connect with database.
You can use this with create a odbc connection and pass the DSN as the argument.
EX:
      Dim con as new odbc connection("DSN=Your DSN Name")

This code you have to return under the class.

    

Installing Wamp in Window 7

 First of all go to C drive -> Window-> System32 and check whether your folder contains MSVCR100.dll and MSVCP100.dll files or not if it will found  then install the setup of wamp but if it will not found or one of them will present and other will not present than delete the present files.
Then go to this below link and download that package according to your
system configuration(means 32 bit or 64  bit).

http://www.atlava.com/forum/rumble-fighter/15031-fix-msvcp100-dll-and-msvcr100-dll-errors.html

After that ,install that package and then install wamp(32 bit or 64 bit).
It will install successfully.