..OK i'm fairly new to all of this, so apologies if this has been covered, link's to exisitng threads would be great!
Basically i would like to understand how to pass an XML file, based on a schema, to an existing web service in order to update a SQL DB.
To test this, i've created a simple database with a single table, firstname, lastname. I've created a web service in VS2005 which connects to this db, deployed it on my local IIS and can successfully query the db via the web service IE page. Marvellous.
What i need to do now is populate the database by passing an XML file to the web service itself. I know this involves creating a new asp.net project and adding the web service in as a reference, but that's where I get stuck!
Any help would be truly appreciated..
Thanks
Basically i would like to understand how to pass an XML file, based on a schema, to an existing web service in order to update a SQL DB.
To test this, i've created a simple database with a single table, firstname, lastname. I've created a web service in VS2005 which connects to this db, deployed it on my local IIS and can successfully query the db via the web service IE page. Marvellous.
What i need to do now is populate the database by passing an XML file to the web service itself. I know this involves creating a new asp.net project and adding the web service in as a reference, but that's where I get stuck!
Any help would be truly appreciated..
Thanks