Need help with C# and MySQL: how to connect them

[carlossan]

Hello,

I am using VS2005, MySQL 5.0.24a, and I downloaded MySQL Visual Studio Connector 5, and the MySQL Visual Studio Plugin 1.0.

Using VS server explorer I can see my database and my tables (even the content of them).

What else do I have to do to connect a C# application with that database ?

I see that I cannot just drag and drop as it can be done with Microsoft SQL server (or ar least I don't know how to do it), so I'm guessing the connection between my c# application and the mysql database is programmatically done using ODBC. Am I right ?

Can somebody point me to some code/resource to learn how to do that connection ?

Regards,

Carlos

 

[richardko]

I think when I was trying to make the connection - this tutorial helped me make the connection. Here's a phrase from the tutorial that will probably help you. This says VB.Net but should work for C#.

"Before we can use Connector/NET with Visual Basic, we need to add a reference to our project. By adding a reference, we are telling VB.NET where to find MySQL Connector/NET in order to access the objects and methods of Connector/NET.

To add a reference, choose the Add Reference… option of the Project menu. Choose the Browse tab and browse to the Connector/NET installation, typically located at C:\Program Files\MySQL\MySQL Connector Net n.n.n\bin\.NET N.N (The path may vary depending on the version number of Connector/NET and the .NET Framework). Choose the MySql.Data.dll file and Connector/NET will be added to your project. You will also need to add a reference to System.Data.dll."

Here's a link to the tutorial:

http://www.vbmysql.com/articles/vbnet-mysql-tutorials/the-vbnet-mysql-tutorial-part-1/

 

[carlossan]

Thanks Richard,

I'm having some success now: I can see the data from the database in a text box. I'm now trying to see it in a DataGridView control...still with problems, but with some tests left to do.

Carlos