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.
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.
