How can I clean this string ?

[Guest]

I'm using Microsoft.Project.OLEDB.9.0 provider with a datareader to read data from a .mpp file (Microsoft Project plan) from ASP.NET
The problem is All the STRING values, the datareader returns, do not end properly.
I mean, suppose the value its suposed to return is "surya".. But instead it returns "sury
The length of this string is around 256 characters... meaning the string is not ending properly and has some characters appended to it
strTemp = drRecords("TaskName").tostrin
I've tried strTemp = String.copy (drRecords("TaskName").tostring).... still it gives the same problem

How can I clean this string
Please help
Thanks
Sury

 

[Morozov Max]

If it returns trailing spaces, you can use string.Trim()

--
----------
WBR, Morozov Max

I'm using Microsoft.Project.OLEDB.9.0 provider with a datareader to read

data from a .mpp file (Microsoft Project plan) from ASP.NET.

The problem is All the STRING values, the datareader returns, do not end properly.
I mean, suppose the value its suposed to return is "surya".. But instead it returns "surya
The length of this string is around 256 characters... meaning the string

is not ending properly and has some characters appended to it.

strTemp = drRecords("TaskName").tostring
I've tried strTemp = String.copy (drRecords("TaskName").tostring)....

still it gives the same problem.