CODEWITHSUNDEEP
c#.netwindowsweb-applications
dilip
dilip

Reputation:

connecting remote mysql database using c#.net

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?

Upvotes: 0

Views: 1321

Answers (1)

mtutty
mtutty

Reputation: 21

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!

Upvotes: 2

Related Questions