ASP.NET

2-Aug-07 5:47

Hi, I have a field in my sql database that is populated with a lot of parragraph and line breaks, but when I use DetailsView to display the field I get only a big parragraph, any help

orsini

Fred_Smith2-Aug-07 7:22

2-Aug-07 7:22

use string.replace function to replace all line breaks with <br> tags

orsini2-Aug-07 7:42

2-Aug-07 7:42

thanks you so much
could you give me an example. i mean not the whole code, but how will be the line.

Fred_Smith2-Aug-07 7:48

2-Aug-07 7:48

if s = your string returned fromt he database, you'd use

s.replace(vbCrLf, "<br />")

in VB - you'll have to look up the C++ or C# versions yourself if you need them... but the VB constant vbCrLf is just the carriage-return line-feed characters which are Chr(13) and Chr(10), so you can maybe work this out yourself... ie, the VB equivalkent is

s.replace(Chr(13) & Chr(10), "<br />")

(it's probably the same in C except for the ; at the end)

orsini2-Aug-07 7:56

2-Aug-07 7:56

thanks, i will try that,

orsini2-Aug-07 9:00

2-Aug-07 9:00

Sorry before i come here i try to make this works , but i can't here is my code, went to the documentation and didnt no find anything, could you help me with that?

<asp:sqldatasource id="SqlDataSource1" runat="server" connectionstring="<%$ ConnectionStrings:vpx_newConnectionString %>"
="" selectcommand="SELECT [pname], [pdescription] FROM [vpx_products]" oldvaluesparameterformatstring="original_{0}">

Dim s As String = SqlDataSource1.SelectCommand("pdescription")
s.replace(Chr(13) & Chr(10), "")

Fred_Smith2-Aug-07 11:38

2-Aug-07 11:38

well, no.. you either need to do this (sort of thing) in the ItemDatabound event, or else in the ItemTemplate of your datalist control instead of just binding it directly to the pdesciption field you have to call a function to format the display, passing the data as argument

<ItemTemplate>
<%# myFormatFunction( DataBinder.Eval(Container.DataItem, "pdescription") ) %>
</ItemTemplate>

Then in your code behind the function would be

Function myFormatFunction (ByVal s As String) As String
Return s.replace(vbCrLf, "<br />")
End Function

orsini3-Aug-07 3:34

3-Aug-07 3:34

Thank you so much, finally I made it work, i rated your answer as 5, you are the man, lol

Fred_Smith4-Aug-07 6:44