Replace vbCrLf

[David C]

We have an asp.net page that displays data from a SQL table that is updated
from a VB application. That application uses vbCrLf to denote line breaks.
How can I replace them with "<br />" before they get displayed in my
GridView? Thanks.

David

 

[Cowboy \(Gregory A. Beamer\)]

Options:

1. Use the row binding event to do a search/replace
2. Search/replace in your database, before you have the data in .NET

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://gregorybeamer.spaces.live.com/lists/feed.rss

or just read it:
http://gregorybeamer.spaces.live.com/

*************************************************
| Think outside the box!
|
*************************************************

 

[David C]

I want to use option 1 but I get an error. Below is what I have in the row
databound event:

Dim varControl

varControl = e.Row.FindControl("EventNotes")

varControl.Text = Replace(varControl.Text, vbCrLf, "<br />")

 

[David Wier]

What is the error you are getting?


David Wier
http://aspnet101.com
http://iWritePro.com - One click PDF, convert .doc/.rtf/.txt to HTML with no
bloated markup

 

[David C]

Nevermind. I looked at it again and the control name was misspelled.

David

 

[Lloyd Sheen]

Nevermind. I looked at it again and the control name was misspelled.

David

Turn on your options Strict and Explicit.

Compiler will tell you most of your problems before you run.

LS

 

[Jonathan Wood]

You want someone to help debug an error without saying what that error is?

 

[b_wind]

You can replace in SQL query or replace in datarowbind event.
suggest you replace in sql query, like:
select *,replace(TEXTFIELD,'
','<BR />') AS FIELD1 from table