Web Services

Re: update a sql table

dgelosini — Tue, 27 Oct 2009 11:40:26 GMT

when submit from infopath the web service that i've created, i receive this error:

System.Web.Services.Protocols.SoapException: Impossibile elaborare la richiesta. ---> System.Data.SqlClient.SqlException: Invalid object name 'SalesReport'.
   in System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   in System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   in System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   in System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   in System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   in System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   in System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   in Brevini.Moss.Service.SqlServer.ExecuteNonQuery(String sql) in C:\Documents and Settings\DGelosin.BPTCORP\Desktop\Brevini.Moss.Service\Brevini.Moss.Service\Helpers\SqlServer.cs:riga 170
   in Brevini.Moss.Service.MossService.UpdateSalesReprotbystatus(String caq) in C:\Documents and Settings\DGelosin.BPTCORP\Desktop\Brevini.Moss.Service\Brevini.Moss.Service\MossService.asmx.cs:riga 189
   --- Fine dell'analisi dello stack dell'eccezione interna ---

But the table SalesReport exist and i reach this with no problem from other pc.

What is the problem?

Re: update a sql table

ErnestoM — Tue, 20 Oct 2009 16:40:57 GMT

Hi Daniele,

In order to accomplish this, you need to write code (i.e. create your own web service). This is time consuming and will only work with one form. Qdabra developed DBXL as a generic web service, which will allow this operation (and many more) for any form.

There has to be an investment of some sort on your part: whether you spend the time on coding this yourself, or hiring someone to code it for you, or purchasing something like the DBXL solution. Writing the code for a web service is not an easy task; keep your fingers crossed that a generous member of this community will volunteer his or her time to write this code for you.

Good luck.

update a sql table

dgelosini — Sat, 17 Oct 2009 10:28:36 GMT

Compliments for the forum is beautyful and helpful.

I'm here for ask you an help to write code for a web services that allow me to update a fild in a sql table from infopath form services form in sharepoint, is the first time that i need a web services and i would to do this.

The form is very simple it composed of two fields (year,month) and referred to this field i need to update the table changing the field called Status from 0 to 1.

It's very simple, but for me write a code for this it's very difficult, i need a help.

I'm also considering to buy the dbxl solution but at the moment i can't giutify the investment.

Thanks

Daniele