String data getting truncated when fetching through sql datareader

Question

I am using a datareader to fetch a table's record values through a stored proc. but while using datareader.getstring(2) to fetch the value of the particular column, the string returned is truncated ( rest of getstrings are returning complete values). Can anyone guide me in analyzing this?

You need to show us the stored proc code, maybe the values is returned as varchar(x) x smaller than the length of the actual column length? — Adriaan Stander
– Adriaan Stander, Commented Dec 16, 2010 at 11:44

golfalot · Accepted Answer · 2016-07-26 11:17:27Z

2

The XML data row is truncated at 2,033 characters when you use the SqlDataReader object. To resolve this problem, use the ExecuteXmlReader method to read FOR XML queries. For additional information about how to use ExecuteXmlReader with SQL Server FOR XML queries https://support.microsoft.com/en-us/kb/310378 https://support.microsoft.com/en-us/kb/316701

answered Jul 26, 2016 at 11:17

golfalot

1,35416 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vishal Kadam · Accepted Answer · 2018-12-28 06:51:04Z

0

Change your Db logic as following,

Declare @xmldata xml
set @xmldata =(<your select query>  
FOR XML AUTO)
select @xmldata as returnXml

And read column returnXml from c# i.e. objReader[0]

answered Dec 28, 2018 at 6:51

Vishal Kadam

1

Collectives™ on Stack Overflow

String data getting truncated when fetching through sql datareader

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related