Re: newlines in ADO.NET

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: headware (headware_at_aol.com)
Date: 10/08/04 

Date: 8 Oct 2004 11:01:43 -0700

This turned out to be a problem with the web services that we were
using to connect to the database. Apparently when the data is
serialized to XML, the \r\n turns into just a \n.

Dave

headware@aol.com (headware) wrote in message news:<e3f4b0ae.0410071508.7fa1256c@posting.google.com>...
> I'm writing an ASP.NET page containing multi-line textboxes. When I
> read them in from the HTML form the newlines are the characters "\n\r"
> which makes sense to me. However, once they have been written into
> Access, which is what my ADO.NET code is connecting to, they become
> just "\n". This is screwing up the reports that we are generating in
> Access. I've looked at the Access file through a hex editor and
> verified this. Is this a Jet Engine thing (I'm using Jet OLEDB 4.0) or
> ADO.NET thing? Is there any way to force it to write "\r\n"? I know
> there are work arounds I can do in Access or in the code to make the
> reports show up correctly, but I'd like to be able to insert "\r\n"
> into the database. That would really work out best for us.
>
> Thanks,
> Dave

Relevant Pages

  • RE: Automated Import Newbee needs help
    ... use Office Access 2007 to replicate a database that was created in an earlier ... Dave Hargis, Microsoft Access MVP ... "terry" wrote: ...
    (microsoft.public.access.externaldata)
  • RE: PLEASE HELP!!!! License information for this component not fou
    ... "Dave" wrote: ... "Klatuu" wrote: ... can't refresh the links it has to another database file. ... equivalent version Access Run Time license. ...
    (microsoft.public.access.gettingstarted)
  • Re: Can a Confimration Field Value be used is asp coding?
    ... "Dave" wrote in message ... >> flexibility and thereby eliminate most of the FP database component ... >> ClassID is a unique number which I am using to drive other pages ... >> The problem is the confirmation page. ...
    (microsoft.public.frontpage.client)
  • Re: Architecture Question
    ... I have a Windows form application that currently uses a database local to the machine it is running on. ... We may also create another web form client in the future, and I would also like that to connect to the business logic server as well. ... heard that web services don't support transactions across multiple database servers, so if I can't use web services, what should I use? ... put the CSLA Framework together. ...
    (microsoft.public.dotnet.general)
  • Re: Subject: Re: OT: Dont create tables owned by informix -
    ... >> own and administer the database. ... >> There are going to be times when this is impossible - and Dave may be ... In a small shop, the same small group of people end up with all roles, so ... Using sudo is a sensible and reasonable mechanism - and it is largely safe. ...
    (comp.databases.informix)