any easy way to do this...

[rodchar]

hey all,

i have a database field that i bring into my dataset and it looks like this:

"xx92208"
"xxx1018"

the x's represent spaces. When i bind it to my datagrid it left justifies
everything, so when i go to do my dataset.findbykey i'm not getting a hit.
anyone have any ideas how i can resolve this?

thanks,
rodchar

[Brock Allen]

If you know how the width then you're going to have to dynamically pad the
string with spaces. This sounds icky. Is there any way you can avoid making
the spaces meaningful? IMO, that'd be the ideal situation.

-Brock
DevelopMentor
http://staff.develop.com/ballen

hey all,

i have a database field that i bring into my dataset and it looks like
this:

"xx92208"
"xxx1018"
the x's represent spaces. When i bind it to my datagrid it left
justifies everything, so when i go to do my dataset.findbykey i'm not
getting a hit. anyone have any ideas how i can resolve this?

thanks,
rodchar

[rodchar]

for right now i ended up trimming the spaces in my SQL statements. This works
until they tell me that when i pass it it has to be fixed 10 spaces padded
left then i might be back. you know how that mgmt goes.

thanks,
rodchar

"Brock Allen" wrote:

If you know how the width then you're going to have to dynamically pad the
string with spaces. This sounds icky. Is there any way you can avoid making
the spaces meaningful? IMO, that'd be the ideal situation.

-Brock
DevelopMentor
http://staff.develop.com/ballen

hey all,

i have a database field that i bring into my dataset and it looks like
this:

"xx92208"
"xxx1018"
the x's represent spaces. When i bind it to my datagrid it left
justifies everything, so when i go to do my dataset.findbykey i'm not
getting a hit. anyone have any ideas how i can resolve this?

thanks,
rodchar