I have a field in a SQL Server database which holds XML (data type set to ntext).

When trying to display this in a label for example on an ASP.net field instead of getting the field in format:

<ns0:Resource xmlns:ns0=\"http://.EPM.TransferResources.BizTalk.Schemas.ResourcesGE N\"><ns0:EMPLID>816048L</ns0:EMPLID><ns0:START_DATE>2002-07-02T00:00:00.000000-00:00</ns0:START_DATE><ns0:FORENAME>Eric</ns0:FORENAME><ns0:SURNAME>Smith</ns0:SURNAME><ns0:INITIALS></ns0:INITIALS><ns0:TITLE>Mr</ns0:TITLE><ns0:EMAIL>[email protected]</ns0:EMAIL><ns0:PRIMARY_LOCATION>SHB</ns0:PRIMARY_LOCATION><ns0:_STAFF>Y</ns0:_STAFF><ns0:ORG_LEVEL>003</ns0:ORG_LEVEL><ns0:DEPTID>F1817000</ns0:DEPTID><ns0:COST_CENTRE>TEFLSPCS</ns0:COST_CENTRE><ns0:DIVISION>DTTESBSS</ns0:DIVISION><ns0:RBS>NDERA.DTXXXDIV.DTTESBSS.DTTE LBDS.TEFLSPCS.F1817.F1817000</ns0:RBS><ns0:RATE_A>0</ns0:RATE_A><ns0:RATE_B>0</ns0:RATE_B><ns0:RATE_C>13.09</ns0:RATE_C><ns0:Meta_GUID>816048L</ns0:Meta_GUID></ns0:Resource>

I get the values returned as a string:

816048L2002-07-02T00:00:00.000000-00:[email protected] SDTTESBSSNDERA.DTXXXDIV.DTTESBSS.DTTELBDS.TEFLSPCS .F1817.F18170000013.09816048L

How would I go about breaking up the string to get the values?

All I have is:

       string MessageBody = "";

        MessageBody = ds.Tables["ErrMessage"].Rows[0][14].ToString();

       //TODO: Need to workout how to display the xml well

        Label2.Text = MessageBody.ToString();

If I try to display in a textbox the format is correct (i.e. with the tags <>) but, it is one one long line.

Hope this makes sense

TIA

G

You can't use a label to display XML like that, it just thinks it's HTML tags that it doesn't understand and ignores them. You can either use a textarea or textbox set to multiline or use something like Server.HtmlEncode to escape the output.

--

Joe (Microsoft MVP - XML)