data retrive from database
-
i want to design a feedback form n which i have kept a multiline textbox for putting comments of the user and then hit the submit button to submit the comment into the database. but when i want to retrive those comments from the database & view them in a grid,i just got the continious lines of data...my requirement is i want to view the data in that manner and style in which i have enterd it during the submission process with the same style and manner...can anybody help me in this regard how to do it or can give me any link regarding this..(like paragraph,heading...etc..) thanks in advance..
pradip kishore
-
i want to design a feedback form n which i have kept a multiline textbox for putting comments of the user and then hit the submit button to submit the comment into the database. but when i want to retrive those comments from the database & view them in a grid,i just got the continious lines of data...my requirement is i want to view the data in that manner and style in which i have enterd it during the submission process with the same style and manner...can anybody help me in this regard how to do it or can give me any link regarding this..(like paragraph,heading...etc..) thanks in advance..
pradip kishore
Pradip Kishore wrote:
but when i want to retrive those comments from the database & view them in a grid,i just got the continious lines of data
Actually you don't. You get the data exactly as it was put in to the database. Multiple lines and all. The problem is the way browsers render HTML. They view your text as HTML and in HTML a carriage return or newline character does not signify a new line. You must replace the newlines with <br/> in order to be formatted properly in the web page. So, this becomes an ASP.NET problem, not a database problem.
Upcoming events: * Glasgow Geek Dinner (5th March) * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos