Difference between revisions of "C#:Access a MySQL Database Table from .Net"

From Progzoo
Jump to: navigation, search
(New page: =Read from a MySQL database= <question xmlns:htm="http://www.w3.org/1999/xhtml" lang="cs" className='Demo'> To read from a '''non''' SQL Server database you can use the classes in System.D...)
 
Line 1: Line 1:
=Read from a MySQL database=
 
 
<question xmlns:htm="http://www.w3.org/1999/xhtml" lang="cs" className='Demo'>
 
<question xmlns:htm="http://www.w3.org/1999/xhtml" lang="cs" className='Demo'>
 
To read from a '''non''' SQL Server database you can use the classes in System.Data.OdbcClient
 
To read from a '''non''' SQL Server database you can use the classes in System.Data.OdbcClient

Revision as of 08:02, 19 June 2008

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]