C#: Connecting to mysql database

Question

I would like some information on how to connect to a MySQL database using C#. I would also like to know on how to retrieve data from the MySQL database and put the retrieved information in a listview.

Thanks