ASP.NET - PhpMyAdmin managed MySQL databases

my website provider allow to create database and tables in MySQL databases. (PhpMyAdmin is  used to manage MySQL databases) i have username & password for that phpMyAdmin login.

now i create the tables in that. But i dont know how to connect to that database and tables from my ASP.NET program.  So that only i can insert values to that tables and retrive from that database. currently i don' have MySQL in my local pc.

i need some detailed answer for this.

Who is Participating?
RejojohnyConnect With a Mentor Commented:
try the "server explorer" provided by VS.Net IDE .... Menu "View->Server Explorer" or "CTRL+ALT+S" .. try adding ur server to the server node ... this works for SQL server .. but never tried it for MYSQL .. after u add ur server .. exapnd the "server node" does ur server appear under the "SQL server" list? ...
i am not sure about this, but i think the server explorer would support mysql too  . .. seems that is the reasson y the author has not come back with any more questions too ...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.