0

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?

Improve this question

1 Answer 1

Reset to default
2

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!

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.