Get Column length of string in column

[Matt]

Have below code
AcctNbr give me result of 30.
That is the database column length, Column stores 10 why is giving me
30 ?

while(objRead.R ead())
{
AcctNbr = (string)objRead[0].ToString().Len gth;
Console.WriteLi ne("Length is {0}",AcctNbr.Le ngth);
}

[Chris]

Matt wrote:

Have below code
AcctNbr give me result of 30.
That is the database column length, Column stores 10 why is giving me
30 ?

while(objRead.R ead())
{
AcctNbr = (string)objRead[0].ToString().Len gth;
Console.WriteLi ne("Length is {0}",AcctNbr.Le ngth);
}

I don't know that I have an answer to your question but it seems what
you are doing here isn't quite right.

This line returns the length of objRead after converting it to a string.
This value is an integer. You then convert that integer into a
string. So AcctNbr now hold something like 10 in string form.
AcctNbr = (string)objRead[0].ToString().Len gth;

Here you take your string value of 10 and get the length of that string
value. so the answer to AcctNbr.Length would be 2. I don't think this
is what you ment to do.
Console.WriteLi ne("Length is {0}",AcctNbr.Le ngth);

Chris

[Matt]

I just like to get the string lenght of the stored value ?
so i can compare that length..

[Chris]

Matt wrote:

I just like to get the string lenght of the stored value ?
so i can compare that length..

What is the object type in the datareader? String?

int intLen

intLen = objRead[0].ToString().Len gth
or
intLen = objRead.GetStri ng(0).Length

Console.WriteLi ne("Length is {0}",intLen.ToS tring())

That should give you the length.
Chris

[Matt]

Chris am still getting 30. I have tried those before thats where i
dont get it.
data column is char and stored 10 char value '5559878789'

int intlen;
while(objRead.R ead())
{

intLen = objRead.GetStri ng(0).Length;
Console.WriteLi ne("Length is {0}",intLen.ToS tring()) ;
}
Length is 30

[Matt]

If anyone interested, I just used trim to get rid of the space for
string.
It sucks. but what can u do Thats MS for you.
intLen = objRead.GetStri ng(0).Length;
Console.WriteLi ne("Length is {0}",intLen.ToS tring());
Console.WriteLi ne(objRead[0].GetType());
string x = objRead[0].ToString();
Console.WriteLi ne("String x is {0}",x);
Console.WriteLi ne(x.Length);
string y = x.Trim();
Console.WriteLi ne(y.Length);

[Chris]

Matt wrote:

If anyone interested, I just used trim to get rid of the space for
string.
It sucks. but what can u do Thats MS for you.
intLen = objRead.GetStri ng(0).Length;
Console.WriteLi ne("Length is {0}",intLen.ToS tring());
Console.WriteLi ne(objRead[0].GetType());
string x = objRead[0].ToString();
Console.WriteLi ne("String x is {0}",x);
Console.WriteLi ne(x.Length);
string y = x.Trim();
Console.WriteLi ne(y.Length);

You have the variable in the database declared as Char(30) I bet.
Change it to varchar(30) and it will work the way you were expecting.

Chris

[Matt]

Not Allowed to change database
Thanks though