connecting remote mysql database using c#.net

Question

i am developing c# windows application.In that i want to connect to mysql database which resides in another system.please help me to solve this? thank you in advance

Answer 1

Assuming that you know how to connect to and query a database, you'll need the following:

1. The ADO.NET provider for MySQL
2. The hostname or IP address of the server
3. A user ID and password to connect with

Add a reference to the MySQL provider. From there, it works just like connecting to a SQL Server box, except the class names are a bit different and some minor SQL dialect is also different.

Of course, if you don't already know how to connect to a database, you'll need to start a bit slower. I'd recommend you Google yourself a basic data-access tutorial.

Good luck!