URGENT...............

Question

i am using dataset and retreving the data from MS ACCESS file. It works fine. From that dataset i am putting the value into a string variable as:

string name = dataset.Tables["tablename"].Rows[0]["NAME"];

Now i have to display each character in the name so i am doing it:

for(int i=0; i<name.Length; i++)
{..........}

But i<name.Length is returning the field size instead of returning the length of the string.

eg

name = "ABC"

now the length should be 3 but it is returning 255.

Looking for prompt reply.

Waqas · Answer

Sorry buddy Actually it was my mistake. I was calling the indexOf() function on the wrong string variable. Any how its working fine now. Thank you very much

Alan · Answer

The IndexOf () method shouldn't give -1 if there's an 'e' in the string Are you sure that it's a lower case 'e' and not a capital 'E'? Also as you're using a loop are you sure that you're considering the correct string?

Waqas · Answer

Thanks buddy it works fine. Another problem now: I am again putting the name from the dataset in the string variable and then trying to find the occurance of certain character in that string but its always give -1 (which means that character is not present in the string) although that character is present in the string. Have a look at the code: for ( int i = 0; i { sindex = 0; key_select = ( string )dataset.Tables[ AllRecords ].Rows[i][ NAME ]; key_select = key_select.TrimEnd( ' '  '\0' ); //key_select = 34 Street sindex = key_select.IndexOf( e ); Console .WriteLine(key_select+   +sindex); //34 Street -1 } //end of loop Please help me out.

Alan · Answer

It sounds like the string is being filled out with spaces or null characters up to the field length. I'd try inserting the following line before you go into the 'for' loop: name = name.TrimEnd(' ' '\0');