ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Updating Data through Webservices using Excel (https://www.excelbanter.com/excel-programming/363808-updating-data-through-webservices-using-excel.html)

[email protected]

Updating Data through Webservices using Excel
 
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.UpdateD ataset(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.



All times are GMT +1. The time now is 01:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com