LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data is not updating in Excel ywcaofjamestownDebbie Excel Worksheet Functions 1 December 1st 07 12:00 AM
Updating Excel data with a newer version of Excel data steviec334567 Excel Programming 1 April 26th 06 12:10 PM
Office & WebServices Issue Srini Excel Programming 0 March 21st 06 01:41 PM
Webservices References Tool 2.0 - Error: No Deserializer found .. Peter S. Excel Programming 0 June 9th 05 11:19 AM
HTML and realtime webservices used with Excel Ricky Excel Programming 0 March 7th 04 06:03 AM


All times are GMT +1. The time now is 04:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"