Updating Data through Webservices using Excel

D

dilishtv

Hi All,

I have created an Excel File which can display the data from a
webservice.
(Used Soap Tool Kit 3.0 with Excel 2003.)
Now I need to modify and update the data through webservice. As the
webmethod requires a dataset or xmlnodelist, I have converted the
modified data to xml format and assigned to a xmlnodelist. while
calling the webmethod it displays following error
-----------------Error----------------
System.Web.Services.Protocols.SoapException: Server was unable to
process request. ---> System.InvalidOperationException: Update unable
to find TableMapping['Emp'] or DataTable 'Emp'.
at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String
srcTable)
at
Microsoft.ApplicationBlocks.Data.SqlHelper.UpdateDataset(SqlCommand
insertCommand, SqlCommand deleteCommand, SqlCommand updateCommand,
DataSet dataSet, String tableName)

--- End of inner exception stack trace ---
--------------------------------------

I found some methods which says to modify the webservice methods. but I
cannot modify the webmethod.
Is there any way to update a webservice using Excel

Thanks in Adv.
 
D

dilishtv

I found all questions are answered very quickly and all most all threds
contains atleast 3 replys too.
I doubt am in a wrong location with a wrong question..

Pls help me gurus
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top