connecting mySQL with Visual Web Developer 2005

Last post 08-23-2008 9:53 AM by ac.. 5 replies.

Sort Posts:

  • connecting mySQL with Visual Web Developer 2005

    08-21-2008, 6:59 AM
    • Member
      point Member
    • ac.
    • Member since 08-19-2008, 8:34 AM
    • Posts 4

    Hi,

     

    Can anybody tell my how to exactly do it?

     I downloaded the connector but, I cant see it on the add new connections..

     

    I'm using vista and 2005 express edition of the Visual Web Developer.

     

    Thanks in advance.

    Ac

  • Re: connecting mySQL with Visual Web Developer 2005

    08-21-2008, 7:11 AM
    • Participant
      1,061 point Participant
    • G0ggy
    • Member since 05-22-2007, 1:58 PM
    • Posts 294

     Have you referenced the class library?

    Imports MySql.Data.MySqlClient


    Remember to mark as answer the solution which helped you.
  • Re: connecting mySQL with Visual Web Developer 2005

    08-22-2008, 7:35 AM
    • Member
      point Member
    • ac.
    • Member since 08-19-2008, 8:34 AM
    • Posts 4
    G0ggy tnx for the reply. I don't know how to do it.. how do I reference the said library?
  • Re: connecting mySQL with Visual Web Developer 2005

    08-22-2008, 9:23 AM
    • Participant
      1,061 point Participant
    • G0ggy
    • Member since 05-22-2007, 1:58 PM
    • Posts 294

     Assuming you have installed the .NET class connector for MySQL, you need to add the reference (Website - Add Reference) then you can use the MySQL classes in your page by using the class declaration which was in my previous post.

    MySQL website includes a vast help section on the MySQL connector.



    Remember to mark as answer the solution which helped you.
  • Re: connecting mySQL with Visual Web Developer 2005

    08-23-2008, 7:37 AM
    • Member
      point Member
    • ac.
    • Member since 08-19-2008, 8:34 AM
    • Posts 4

    Thanks, I already added a reference to MySQL.Data.dll.

    But what I mean is, when I go to database explorer, and add data connections, I can't find the MySQL data source.

     I created a table in MySQL and I also have no idea how to point my website to use that table.

     

  • Re: connecting mySQL with Visual Web Developer 2005

    08-23-2008, 9:53 AM
    • Member
      point Member
    • ac.
    • Member since 08-19-2008, 8:34 AM
    • Posts 4

    Thanks a lot GOggy.. I've been researching online and found this

     

    http://www.15seconds.com/issue/050210.htm
    http://www.codeproject.com/KB/database/MySQLCsharp.aspx
     

    I think this solves my problem (haven't tried it though.. still busy with my exams)

    thank anyway..

     

    More power,
    Ac

Page 1 of 1 (6 items)