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.
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.