Removing Carriage returns
- From: "Steve Wolfie" <stevewolfie@xxxxxxxxxxxxxxxx>
- Date: Fri, 24 Jun 2005 16:35:12 -0700
Hello All:
In response to the question I posted 6/17, I have followed the advice of the
very helpful people in this forum, and found that the suggestion for
importing from a dataset into excel is best done by writing a .csv file with
a streamwriter. Thanks for that.
However, I have a new problem. the dataset contains input from textboxes in
an asp.net page. The problem now is that if a carriage return in input in a
multi-line textbox, then the csv file is written accordingly. I already
used the textbox1.replace("," , "") method to strip out the commas in the
file, so that it would not cause excel to advance to the next column, but i
need to know how to stop the carriage returns from being written to the sql
database in the first place.
So... What is the character for carriage return? I want to write it similar
to this.
SqlDataAdapter1.insertcommand.parameters("@comments").value =
txtcomments.text.replace("CARRIAGE RETURN", " ")
Problem is... what am i supposed to use where I have written carriage return
above?
Thanks a million.
Steve
.
- Follow-Ups:
- Re: Removing Carriage returns
- From: William \(Bill\) Vaughn
- Re: Removing Carriage returns
- Prev by Date: ADO Data Control Error Message "Unexpected end of statement"
- Next by Date: Re: Removing Carriage returns
- Previous by thread: ADO Data Control Error Message "Unexpected end of statement"
- Next by thread: Re: Removing Carriage returns
- Index(es):
Relevant Pages
|
|
