[2.0] Connect to db through webservice

[vbcode1980]

Hi,

I want to write a desktop application to connect with an Access database on our corporate website. Unfortunately, the website is hosted on a server that does not allow remote connections from outside its network. (Except for visiting the websites of course) This means I can't connect to the database directly.
So I figured, I have to write a webservice or something that can be placed on the website to connect with the database. Then my app can communicate with this webservice, and the webservice can pipe through all data.

Any clues on how to proceed with this? I've never written a webservice before, just remember a presentation in which someone demonstrated something like I'm trying to do.

Cheers,
VBCode1980

[popskie]

You can create a webservice.
then write a method that return a dataset, table, dataadapter or any data container object that suite for your requirements.

[Muller2]

Go here: http://www.codeproject.com/cs/webservices/

There are loads on articles on webservices in c# that should put you on the right path

Al