I currently 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 w3schools for this purpose. The code i am using is as follows:
<table border="1" width="100%">
rs is the recordset here.
But the HTML table generated does not have the line breaks that was inserted when inserting data into the sql table. Please help.