VS .NET: Connecting to MySQL

I would like to connect to a MySQL database from VS .NET.
The MySQL server is on another computer, connected in LAN.
I have tried various ways but failed to do it because I don't really understand the concept.

(For Delphi programmers)
I can do it in Delphi, quite simple:
- Drop a TDatabase, set AliasName to testdb (In BDE, the type is MySQL ODBC 3.51 Driver), and DatabaseName to testdb (this is the database in the MySQL server, not to be confused with the previous one).
- Drop a TQuery, setting DatabaseName to testdb, SQL to "select * from tb_customer"
- Drop a TDataSource and a TDBGrid, setting their DataSet and DataSource
- Activate/enable all of them, and the data in table tb_customer is already shown without even compiling/running it.

How can I do the same thing in VS .NET?
Thank you.
LVL 6
HardiAsked:
Who is Participating?
 
boy8964Connect With a Mentor Commented:
When I first time connecting .net to mysql, I could not do it utill I have readed this article. url is here:
http://dev.mysql.com/tech-resources/articles/dotnet/

It may help you to.
0
 
HardiAuthor Commented:
Thank you. I'll try it later
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.