XML truncated on client when using FOR XML...

[Charlie]

Hi:

I have a stored proc that returns an XML doc. Testing it in Query Analyzer,
it looks fine. However consuming it in C# application truncates xml string
when result is converted to string from an ExecuteScalar data command. May
have something with string conversion because looking at result in a
datatable column looks OK, but when converting (tbl.Rows[0][0].String()) it
gets truncated. Why?

Thanks,
Charlie

[Samuel R. Neff]

FOR XML returns XML data as a single-field text result with as many
rows required to contain all the data. It may be more than one row
and thus Rows[0][0] and ExecuteScalar will both truncate the data.

SqlCommand has a SQL-Server specific method ExecuteXmlReader designed
to handle FOR XML results.

HTH,

Sam
------------------------------------------------------------
We're hiring! B-Line Medical is seeking Mid/Sr. .NET
Developers for exciting positions in medical product
development in MD/DC. Work with a variety of technologies
in a relaxed team environment. See ads on Dice.com.
On Tue, 12 Dec 2006 14:34:26 -0500, "Charlie@CBFC"
<ch*****@cbfconsulting.comwrote:

>Hi:

I have a stored proc that returns an XML doc. Testing it in Query Analyzer,
it looks fine. However consuming it in C# application truncates xml string
when result is converted to string from an ExecuteScalar data command. May
have something with string conversion because looking at result in a
datatable column looks OK, but when converting (tbl.Rows[0][0].String()) it
gets truncated. Why?

Thanks,
Charlie

[AmosC1]

You may look at this article here:
http://support.microsoft.com/kb/310378
Even though it relates to ExcuteReader, the answer is similar (only
that ExcuteScalar returns only the first row, and ExecuteReader you can
loop through the rows with " While ( dr.Read() ) "

On Dec 12, 9:34 pm, "Charlie@CBFC" <[e-mail]:

Hi:

I have a stored proc that returns anXMLdoc. Testing it in Query Analyzer,
it looks fine. However consuming it in C# applicationtruncatesxmlstring
when result is converted to string from anExecuteScalardata command. May
have something with string conversion because looking at result in a
datatable column looks OK, but when converting (tbl.Rows[0][0].String()) it
gets truncated. Why?

Thanks,
Charlie