[RESOLVED] Connect to MySQL with C#

[Arc]

Hey guys, I have done some searching and found a couple things on this subject but I have not found a full example.

I have never programed with C# or any .net languages so I am pretty lost here. I am a web developer and I use php exclusively so i do understand the concepts, but I would like a working example if anyone can provide it.

The MySQL DB is on a seperate server and this application will be a desktop app not web based.

I looked at connectionstrings.com but i am not sure If I should be using MyODBC or OleDB or ADO or what. And I am not sure what to put in the "using" area of the app or what I need to download or anything.

Also, the easier the setup is for the user who installs the app the better. I don't want them to have to download any special drivers to get this to work (But I assume the distribution package will include all necesary components).

I was reading something on the MYODBC page that has a certain liscence with it...Since this will be a commercial app, I would rather not deal with liscences and such.


I appreciate any input you can give me on this.

Thanks!

Ohh btw, I am using VS 2005 Standard if that matters.