C#:Access a MySQL Database Table from .Net
From Progzoo
To read from a non SQL Server database you can use the classes in System.Data.OdbcClient
- OdbcCommand
- OdbcConnection
- OdbcDataReader
The Odbc connection must be created first; this one is called MySQLscott.
- Download the mysql-odbc-connector from mysql.com
- Create the ODBC connection from Start/Control Panel/Administrative Tools/Datasources (ODBC)/System DSN
Read the name and population for each country with a population of more than 200000000.
[Font]
[Default]
[Show]
[Resize]
[History]
[Profile]
See also