iam creating an online customer ordering system, and i will want to connect to a mysql dtabase that i have created.
mzeewashooo 0 Newbie Poster
JorgeM 958 Problem Solver Team Colleague Featured Poster
There are a few ways to connect. In general, you need the correct driver installed on the webserver, then create the connection string.
http://www.connectionstrings.com/mysql
http://www.mysql.com/downloads/connector/
ckchaudhary 5 Newbie Poster
riteshbest 0 Light Poster
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.
D/W Link: http://www.mysql.com/downloads/connector/net/
Connector has DLL(s) that you need to refer in your project.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.