How to Connect the VB 2005 to MySQL

Here is how to connect Visual Basic.Net to the MySQL database:
1. In the project - add reference - on the tab. Net - find MySql.Data - click OK
2. In the namespace - imports mysql.data.mysqlclient
3. In the form load or in the module or whatever form
type this code to connect with mysql

1
2
3
4
5
6

Dim myString As StringmyString = "server=localhost; " _
& "uid=root;" _
& "pwd=;" _
& "database=mysql;"
Dim conn As New MySqlConnection(myString)
conn.Open()

Process’s command is same as our command to do SQL Server or Access

Tags: , , , ,

This entry was posted on Wednesday, October 22nd, 2008 at 12:40 pm and is filed under MySQL, Php. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

« Previous Post
« How do I install WordPress in Windows XP?
Next Post »
What’s DHCP »

5 Responses to “How to Connect the VB 2005 to MySQL”

  1. Resolving Query Problems Using Subquery says:

    October 31st, 2008 at 6:56 am

    [...] a correct information about the data (note : this query will not working in previous version of MySQL 6, paradox database, and interbase 6) : 1 2 3 4 5 6 7 8 9 10 SELECT a.productid, a.descriptions, [...]

  2. BEN says:

    June 26th, 2010 at 7:25 am

    Pillspot.org. Canadian Health&Care.Special Internet Prices.No prescription online pharmacy.PillSpot.org. Vitamins@buy.online” rel=”nofollow”>.…

    Categories: Eye Care.Pain Relief.Anxiety/Sleep Aid.Stomach.Vitamins/Herbal Supplements.Skin Care.Antidiabetic.Antiviral.Womens Health.Mens Health.Stop SmokingAnti-allergic/Asthma.Mental HealthBlood Pressure/Heart.Weight Loss.Antidepressants.Antibi…

  3. Plastic says:

    August 29th, 2010 at 9:34 pm

    hanger http://scoatejq3hh4.AACEHARDWARE.INFO/tag/Plastic+Hanger+hanger/ : Hanger…

    Plastic…

  4. ps2 says:

    August 29th, 2010 at 9:46 pm

    ps2 http://mps2gq0b.AUTOSECTIONS.INFO/tag/Repair+Fuse+ps2+PS2/ : Repair…

    ps2…

  5. My says:

    August 30th, 2010 at 3:18 am

    House http://i1992aceu0.02JEEPPARTS.US/tag/Stranger+in+My+House+Scrubs+tabletop/ : My…

    Scrubs…

Leave a Reply