asp.net - dynamic data site - display blob data

j420exe1
j420exe1 used Ask the Experts™
on
Hello Experts,

I have a dynamic data website and my model is pointed to an Oracle 11.2 db.  Using ODP.net, c#, asp.net, .net 4.0, EF 4.

One of my columns type blob contains html markup.  Any examples out there on how to get dynamic data site to render the html content in that column in a new page when the user clicks in that column?  I have searched and only found examples on how to display images but not other types of binary data, like, html or pdf docs.

Thanks in advance.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
You will need to convert the BLOB data back into a string or char representation then display it as you would any HTML.

From your previous question:  Make the DBA give you a CLOB unless you need to store actual binary data.

Author

Commented:
Went with CLOB type.  Inserts work.

Now trying to read the CLOB data into a datatable (new question):

c# - Fill datatable from Oracle recordset including CLOB
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
Again, why the "B" grade?

What would you have needed to give an "A" grade?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial