Reading a Text Field from SQL Server into a string

  • Thread starter Thread starter Sergio Otoya
  • Start date Start date
S

Sergio Otoya

Hi All,

I have a small problem. I have a database with an ntext field, I have
created an ado.net dataset over the table but when I get the value of
the field in the string, it gets truncated somewhere along the line.

Do I have to do something special to get the whole string?.

Any help will be appreciated. Thanks in advance.

Sergio
 
Hi Sergio,

Did you ask this as well in the newsgroup.
microsoft.public.dotnet.framework.adonet

That when you are sure that there is not a Null character in your strings,
because that means that the string has a longer lenght however will only be
showed untill that Null character.

I hope this helps?

Cor
 
No, I didn't post that other article. However, do you mean that there
shouldn't be any chr(0) characters in the text field otherwise they get
truncated?.



Sergio
Winapp
Australia

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
 
No, I didn't post that other article. However, do you mean that there
shouldn't be any chr(0) characters in the text field otherwise they get
truncated?.
Click to expand...

Right
:-)

Cor
 
Hi Cor,
I checked the text field and there were no null chars. Any other
suggestions?. Thanks for your time.

Sergio
Winapp
Australia

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
 
Back
Top