Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data is not updating in Excel | Excel Worksheet Functions | |||
Updating Excel data with a newer version of Excel data | Excel Programming | |||
Office & WebServices Issue | Excel Programming | |||
Webservices References Tool 2.0 - Error: No Deserializer found .. | Excel Programming | |||
HTML and realtime webservices used with Excel | Excel Programming |