Storing HTML code into SQL 2005 by using asp.net2

hi,
i wabt to insert a rich text format(*.rtf) file type with a picture into sql
database. i have done this issue by converting rtf into web page and save the
html code into sql server table. but the problem is when the web page has a
picture, the picture could not be shown. whats the problem?

Rick
Sat Nov 25 07:31:57 CST 2006

Probably you are trying to store binary data, the picture, into a string
field and it contains characters that cannot be stored.

Maybe you should encode the picture into Base64 when you store it and then
decode when you want to use it.

Rick

"pmn" <pmn@discussions.microsoft.com> wrote in message
news:CE6ED0A4-3F1D-43C8-8FB3-4F758F26DF37@microsoft.com...
> hi,
> i wabt to insert a rich text format(*.rtf) file type with a picture into
> sql
> database. i have done this issue by converting rtf into web page and save
> the
> html code into sql server table. but the problem is when the web page has
> a
> picture, the picture could not be shown. whats the problem?

Cor
Sat Nov 25 08:47:03 CST 2006

pmn,

HTML cannot contain images, only references in the format of url tags to
pictures.

Cor

"pmn" <pmn@discussions.microsoft.com> schreef in bericht
news:CE6ED0A4-3F1D-43C8-8FB3-4F758F26DF37@microsoft.com...
> hi,
> i wabt to insert a rich text format(*.rtf) file type with a picture into
> sql
> database. i have done this issue by converting rtf into web page and save
> the
> html code into sql server table. but the problem is when the web page has
> a
> picture, the picture could not be shown. whats the problem?

Dave
Sun Nov 26 00:10:53 CST 2006

Hi,

Why / how are you converting RTF to HTML?

If you simply want to insert RTF source into the database, then use the
varchar or text data type for your column.

--
Dave Sexton

"pmn" <pmn@discussions.microsoft.com> wrote in message
news:CE6ED0A4-3F1D-43C8-8FB3-4F758F26DF37@microsoft.com...
> hi,
> i wabt to insert a rich text format(*.rtf) file type with a picture into
> sql
> database. i have done this issue by converting rtf into web page and save
> the
> html code into sql server table. but the problem is when the web page has
> a
> picture, the picture could not be shown. whats the problem?

pmn
Sun Nov 26 03:24:01 CST 2006

hi Rick, what i want to do is to isert a formateted text into sql. you can
imagin that i want to design a news website and the news could be every
things including text and pictures.

"Rick" wrote:

> Probably you are trying to store binary data, the picture, into a string
> field and it contains characters that cannot be stored.
>
> Maybe you should encode the picture into Base64 when you store it and then
> decode when you want to use it.
>
> Rick
>
> "pmn" <pmn@discussions.microsoft.com> wrote in message
> news:CE6ED0A4-3F1D-43C8-8FB3-4F758F26DF37@microsoft.com...
> > hi,
> > i wabt to insert a rich text format(*.rtf) file type with a picture into
> > sql
> > database. i have done this issue by converting rtf into web page and save
> > the
> > html code into sql server table. but the problem is when the web page has
> > a
> > picture, the picture could not be shown. whats the problem?
>
>
>