ADO Recordset to HTML table

Abhiman

New member
Joined
Jun 17, 2011
Messages
1
Programming Experience
1-3
Hello

I am trying to display recordsets as HTML tables. So far I have succeeded in storing the recordset data in a string and writing it as HTML. For this i have used the GetString() method. I have used code from ADO GetString Method for this purpose. The code i am using is as follows:
str=rs.GetString(,,"</td><td>","</td></tr><tr><td>"," ")
%>
<table border="0" width="80%">
<tr>
<td><%Response.Write(str)%></td>
</tr>
</table>
rs is the ADO recordset here.
But the HTML table generated does not have the line breaks that was inserted when inserting data into the sql table. I am using multiline asp textboxes to populate the table. Say someone presses enter for a new line while storing data. When i access the data the same format is shown. But in the HTML table all the sentences are in the same line. Is there anyway to solve this? Please help.
 

JohnH

VB.NET Forum Moderator
Staff member
Joined
Dec 17, 2005
Messages
15,604
Location
Norway
Programming Experience
10+
Is this really related to VB.Net development?
 
Top Bottom