Re: Truncation of Results from SqlDataReader
John Wilkinson <[email protected]>
| Newsgroups | gmane.comp.windows.devel.dotnet.cx |
|---|---|
| Message-ID | <[email protected]> |
Just in case anyone else runs into this problem, the issue is this: when returning the result of a for xml query, the string is broken into 2033-character chunks, which are returned as a rowset. Very simple solution, once I knew what to look for. John -----Original Message----- From: Discussion relating to the specifics of the C# and Managed C++ languages [mailto:[email protected]] On Behalf Of John Wilkinson Sent: Tuesday, September 12, 2006 4:23 PM To: [email protected] Subject: [DOTNET-CX] Truncation of Results from SqlDataReader I have a stored procedure that generates an XML stream. The stream is read with a SqlDataReader object, using GetSqlString. However, the string is truncated at 2034 characters. The same thing happens when the result is retrieved with GetString. The stored procedure has been verified to return the correct and complete string. Any ideas on what might be causing this? Or how to get around it? Thanks, John =================================== This list is hosted by DevelopMentor(r) http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com