export text show as html

[amir]

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

[Jani Järvinen [MVP]]

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
ja***@removethis.dystopia.fi
http://www.saunalahti.fi/janij/

[amir]

On Mar 12, 6:02 pm, "Jani Järvinen [MVP]"
<[e-mail]:

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
[e-mail]://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.

[Todos Menos [MSFT]]

Dreamweaver does things like this

Visual Studio; we still don't understand the whole 'web development
persona' so you'll have to wait for the next version of 'Visual Web
Developer'

it should be out next month

-Todos

On Mar 12, 9:02 am, "Jani Järvinen [MVP]"
<[e-mail]:

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
[e-mail]://www.saunalahti.fi/janij/

[Jani Järvinen [MVP]]

Hi Todos,

Dreamweaver does things like this

Yeah, you could use newest versions of Dreamweaver for these kind of things,
but also Crystal Reports, or the many reporting engines out there, and so
forth.

But since Amir posted his question to this C# forum, it is pretty safe to
assume he wants to use Visual Studio for the job. Although better solutions
could be available, developers just love the challenge to code, don't they?
:-)

--
Regards,

Mr. Jani Järvinen
C# MVP
Helsinki, Finland
ja***@removethis.dystopia.fi
http://www.saunalahti.fi/janij/

[Todos Menos [MSFT]]

a) Dreamweaver supports C#
b) C# was never invented
c) C# newsgroup is the property of the VB folk. you dipshits
shouldn't have jumped on the bandwagon and supported a new language
just because it has a # in the name of the language. I mean-- how
friggin trendy


On Mar 14, 8:08 am, "Jani Järvinen [MVP]"
<[e-mail]:

Hi Todos,

Dreamweaver does things like this

Yeah, you could use newest versions of Dreamweaver for these kind of things,
but also Crystal Reports, or the many reporting engines out there, and so
forth.

But since Amir posted his question to this C# forum, it is pretty safe to
assume he wants to use Visual Studio for the job. Although better solutions
could be available, developers just love the challenge to code, don't they?
:-)

--
Regards,

Mr. Jani Järvinen
C# MVP
Helsinki, Finland
[e-mail]://www.saunalahti.fi/janij/

[Todos Menos [MSFT]]

Dreamweaver is BETTER with C# than Visual Studio
and I repeat

C# was never invented

On Mar 14, 8:08 am, "Jani Järvinen [MVP]"
<[e-mail]:

Hi Todos,

Dreamweaver does things like this

Yeah, you could use newest versions of Dreamweaver for these kind of things,
but also Crystal Reports, or the many reporting engines out there, and so
forth.

But since Amir posted his question to this C# forum, it is pretty safe to
assume he wants to use Visual Studio for the job. Although better solutions
could be available, developers just love the challenge to code, don't they?
:-)

--
Regards,

Mr. Jani Järvinen
C# MVP
Helsinki, Finland
[e-mail]://www.saunalahti.fi/janij/