iam creating an online customer ordering system, and i will want to connect to a mysql dtabase that i have created.
You cant directly connect to MySQL database using ADO.NET library. You need to download MySQL .NET connector to connect database. Connector/Net contains fully-managed ADO.NET driver for MySQL.
Connector has DLL(s) that you need to refer in your project.