My advice with regards to retrieving vast amounts of data from a database, would be to use a DataReader instead of a DataAdapter. This will speed things up considerably. On a second note, you should really be using the ADO.Net connector for MySQL rather than using OBDC. Here
MySQL Connector .Net[
^] is the download page.
Hope this helps