Solved

C# read data from mysql that is not localhost

Posted on 2013-06-05
5
405 Views
Last Modified: 2013-06-12
what is the best way to use c# to read data from website (data base is mysql) the host only allow to add mysql user from localhost

read only not write
0
Comment
Question by:teera
5 Comments
 
LVL 108

Assisted Solution

by:Ray Paseur
Ray Paseur earned 500 total points
ID: 39222734
Create a web service on the server that has the data base.   Use a RESTful design to access the data.
0
 
LVL 12

Expert Comment

by:adrian_brooks
ID: 39223160
I don't mean to be rude, but since when does C# topics end up in a PHP category?
0
 
LVL 82

Expert Comment

by:Dave Baldwin
ID: 39223267
" when does C# topics end up in a PHP category? "

When they put it there.  Doesn't mean it was a good idea...  but we'll see.  Since the host is not allowing external access directly to the database, the asker may end up using Ray's suggestion for a web service based on PHP.
0
 

Author Comment

by:teera
ID: 39224377
Hi experts

I can use php on that server so if I use php to generate some thing that c# can read but I am not sure what I should do
0
 
LVL 108

Accepted Solution

by:
Ray Paseur earned 500 total points
ID: 39224406
PHP can be used to produce any kind of browser output, including plain text, HTML, JSON, XML, etc.  So the output from the server will be usable in a RESTful interface.

Is your question about how do I read from a web service or how do I create a web service that others can read ??
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Hello All, I have been training on Multicast for a while now and whenever I start the topic , I find out that my friends /  Colleagues mention that they do not know how to test Multicast Joins. As most of the multicast would be video traffic and …
This article discusses four methods for overlaying images in a container on a web page
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now