Re: export text show as html

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Mar 12, 6:02 pm, "Jani Järvinen [MVP]"
<j...@xxxxxxxxxxxxxxxxxxxxxx> wrote:
Hi Amir,

i was wandering if there is an easy way to export text from my
database to an html report...

Unless you want to use general-purpose reporting systems/engines like
Crystal Reports for this task, it is best to write your own code.

I've lost count of how many database-data-to-html applications I've written
during the years, but in every single one the basic principle has been the
same: run a SQL query, loop through the results, and generate your HTML code
based on the data.

From your question it is difficult to say whether you find the database side
or the HTML generation side more difficult, but outputting HTML is quite
simple actually. Also, you could use a web page editor two design an HTML
file skeleton, and then embed certain special tags inside it. Then your C#
application would replace those tags with the database data.

It is also possible to convert your database stuff into XML format, and then
use XSLT (XSL transformations) to generate the HTML from these XML files.

Good luck!

--
Regards,

Mr. Jani Järvinen
C# MVP
Helsinki, Finland
j...@xxxxxxxxxxxxxxxxxxxxxxxxxx://www.saunalahti.fi/janij/

Thnx for the info. Actually dont find niether of the sides (db,html)
difficult just wandered maybe they had a feature for that.
thnx a lot,
amir.

.

Relevant Pages

  • Re: [FAQ] addslashes() and striplashes()
    ... How do I use addslashes() and stripslashes() when dealing with HTML ... Use addslasheswhen INSERTing or UPDATEing data into the database. ...
    (comp.lang.php)
  • Re: Virtual SBS server
    ... I have been posting in HTML since I became an MVP for SBS 5 years ago. ... With regard to Outlook over HTTP, it might be a bit faster since you don't have the VPN overhead to contend with. ... >>Depending on the database VPN may work, ... >desktop so making the server do all the work would be ...
    (microsoft.public.backoffice.smallbiz)
  • Re: following radio & hidden does not work..... help please.
    ... So you query the database for records and present the concatenated fname and lname for the user to choose from. ... This works the same with a radio button or a select statement. ... This is a HTML or PHP question! ...
    (alt.html)
  • Re: Photographs in British Naturism
    ... source code file, html, jsp, php or what ever), the only factor is ... not to the server if it's serving a html file, ... Currently, it's programmed to generate HTML pages from the text which operators have typed into the database through the admin interface. ...
    (uk.rec.naturist)
  • Re: GridView
    ... Dim cmd As New CommandField ... I tried to enter html text into the database table but that only ... I'm using a GridView to list data from a table in my database. ...
    (microsoft.public.dotnet.framework.aspnet)