C# .NET MySql only returns last result

C# .NET MySql only returns last result

References

Reference NO 1

http://stackoverflow.com/questions/15189158/c-sharp-net-mysql-only-returns-last-result

Reference NO 2

http://zetcode.com/db/mysqlcsharptutorial/

Reference NO 3

http://www.codeproject.com/Articles/71346/Connecting-to-MySQL-Database-using-C-and-NET

Reference NO 4

http://livshitz.wordpress.com/2011/10/28/returning-last-inserted-id-in-c-using-mysql-db-provider/

Reference NO 5

http://www.ianatkinson.net/computing/mysqlcsharp.htm

Reference NO 6

http://www.sitepoint.com/forums/showthread.php?422779-Retrieving-last-INSERT-ID-C-MySql

Reference NO 7

http://social.msdn.microsoft.com/Forums/vstudio/en-US/080f3b67-7996-414e-815a-0c4e4745014a/action?threadDisplayName=c-web-service-and-mysql

Reference NO 8

http://suite101.com/article/how-to-access-mysql-with-c-a115001