Hi,
I would like to develop an xml webservice to download data from an xml file.
For example: a developer how will use my webservice gives the parameter of the webservice the path of the xml file and then hits invoke or submit button.
The xml webservice will then take the xml file and transfers the data into sql server either one line at a time or all in one go.

1)Does the above make sense to you. I mean is it how it is supposed to be done if someone wants to pass the data in an xml file through a webservice?

2) Lets say usinig the xml webservice, I get the data in the xml file. Then is it best to insert the data into sql table one row at a time (i.e. datareader) or use a dataset to do the insert ini one go? If it is best to use a dataset then how is this done, any guidance?

Thanks