![]() |
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