Need a code example for Ado.net to use with VC++ 2010 with MySQL database
Posted on 2011-03-09
I am new to databases and VC++.
II have installed MYSQL on my PC and I also have VC++ 2010 on the same machine.
I want to try to use an ADO.net to connect between the VC++ and MYSQL.
I understand that ADO.net has the advantage of using a DataSet over ODBC.
I need to create long tables from VC++ to the MYSQL and to update the values of the tables.
The MySQL and the VC++ are running on the same machine.
1) Is it better to use ADO.net than ODBC?
2) I was not able to find a working example with VC++ 2010 does anyone have a working example?
3) Also an example with ODBC can help.
4) I installed the MYSQL, the ADO connector and the MYSQL Workbench what else is needed for running the code?