Data type for a block of text?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey all, I'm coming from the ColdFusion world and am pretty new to .Net2. My
issue is, I've got a page where the content (with html formatting included)
is stored in a db table field. In MS Access, the field type was Memo, in
SSExpress I'm using nvarchar(max).

When I try to display the contents/paragraphs in my aspx page (using
Gridview) , I see all the html coding & formatting characters.

Am I using the right data type? Should I be using something other than
GridView? Am I even in the right forum for this question?

Also, I'm trying to find a listing of default value & binding functions like
"GetDate()" Any links?

Thanks in advance!
 
You are going to have to take control of this. Most likely, you are using an
AccessDataSource control? If so, the actually data is stored as XML, which
will escape the <, and a few other characters, to conform to XML standards.
If you actually view source, you probably see this

&lt;H1&gt;My Header&lt;/H1&gt;

instead of this

<H1>My header</H1>

You may do better with a DataReader and binding the data to the controls
yourself, rather than using the "auto binding" in .NET.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

*************************************************
| Think outside the box!
|
*************************************************
 
Back
Top