MySQL

Re: connecting mySQL with Visual Web Developer 2005

ac. — Sat, 23 Aug 2008 13:53:46 GMT

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

Re: connecting mySQL with Visual Web Developer 2005

ac. — Sat, 23 Aug 2008 11:37:03 GMT

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

G0ggy — Fri, 22 Aug 2008 13:23:33 GMT

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.

Re: connecting mySQL with Visual Web Developer 2005

ac. — Fri, 22 Aug 2008 11:35:34 GMT

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

G0ggy — Thu, 21 Aug 2008 11:11:26 GMT

Have you referenced the class library?

Imports MySql.Data.MySqlClient

connecting mySQL with Visual Web Developer 2005

ac. — Thu, 21 Aug 2008 10:59:38 GMT

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.