Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Web Services > Problem passing a modified string contained within a dataset over a web service

Reply
Thread Tools

Problem passing a modified string contained within a dataset over a web service

 
 
eazilyled@yahoo.co.uk
Guest
Posts: n/a
 
      03-12-2007
I have been having a problem when passing a modified string contained
within a dataset over a web service.

The dataset is populated on a server using an ADO.NET data adapter /
SQL Server 2005 database, and then passed over the wire using web
services to a client win forms app. The dataset contains a table
called 'Note', which in turn contains a string column called 'Body'.
The client app can then edit the value of the 'Body' column and send
the dataset back over to the server using web services for the changes
to be committed to the database.

This all works fine, except when the value of the 'Body' column in one
of the rows starts off as "\r\n" , i.e. just a carriage return, and
then gets modified to "\r\nt". So the values on the client side before
being sent to the server are:

dataset.Tables["Note"].Rows[0]["Body", DataRowVersion.Original] = "\r
\n"
dataset.Tables["Note"].Rows[0]["Body", DataRowVersion.Current] = "\r
\nt"

... the values the server gets are

dataset.Tables["Note"].Rows[0]["Body", DataRowVersion.Original] = ""
<- an empty string!
dataset.Tables["Note"].Rows[0]["Body", DataRowVersion.Current] = "\r
\nt"

This causes my data adapter on the server side to throw a
DBConcurrencyException when committing the changes as it thinks the
data in the database has been modified by someone else (my data
adpater is using a SqlCommandBuilder with the ConflictOption set to
CompareAllSearchableValues).

Has anyone else seen problems similar to this? We are using Visual
Studio 2005 with SP1.

Regards,
Rick

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
VOIP over VPN over TCP over WAP over 3G Theo Markettos UK VOIP 2 02-14-2008 03:27 PM
Calling a Web Service using Axis, from within an Axis Web Service running under Tomcat hocho888 Java 1 04-29-2005 08:26 PM
Problem passing a typed dataset to a web service Justin Crossley ASP .Net Web Services 1 11-18-2004 03:14 PM
Referencing web service complex data type within a second web service (like a delegate) Mike Dearman ASP .Net Web Services 1 06-23-2004 03:11 PM
Calling an Asynch web service within a web service. Tony T. ASP .Net Web Services 0 04-25-2004 11:46 PM



Advertisments