MySQL sample ?

[Kid]

Hi

Is there some good MySQL database sample use C# or VC or MFC ?

Is there some good api or library that I can access MySQL without MySQL ODBC
driver ?

Thank for your grand help.

 

[Arne Vajhøj]

Is there some good MySQL database sample use C# or VC or MFC ?

Is there some good api or library that I can access MySQL without MySQL ODBC
driver ?

For .NET usage download and install MySQL Connector for .NET - it comes
with docs, but you don't need the docs - it works just like all other
ADO.NET providers - the class names just start with MySql.

For C/C++ you will need to pick between several API's. I will
suggest the standard MySQL C API. It is very simple to use and
if you have used MySQL from PHP then you have a good start.

Arne

 

[Alec S.]

Is there some good MySQL database sample use C# or VC or MFC ?

Is there some good api or library that I can access MySQL without MySQL ODBC
driver ?

See if your local library has any books on (My)SQL. I learned to write apps that
interface with MySQL using the sample programs in a couple of those. “MySQL :
the complete reference” by Vikram Vaswani was particularly useful.

 

[Arne Vajhøj]

http://forums.mysql.com/read.php?3,233976,233976

As Arne said, this works (essentially) in exactly the same way as the
SQL Server .NET native data provider...

Or Oracle or DB2 or PostgreSQL or FireBird or ...

When starting using parameters then one should note that
parameters are marked ?xxx not @xxx with MySQL and that
obviously also the data types enumeration is slightly
different.

And if one uses DbProviderFactory and IDb* interfaces
as one is supposed to do then there are no code changes
at all.

Arne