AaZocco
New member
- Joined
- Jul 21, 2006
- Messages
- 1
- Programming Experience
- Beginner
Hi all,
I have a field in database mySQL with decimal datatyope format. say it has value ie. 25.75 when I try to retrieve this field, it returns as 2,575 (not decimal) i have tried to convert it by using CDec function but it still returns as above. than i try to use .GetDecimal within datareader it still the same result. than i try to change regional setting via control panel and change the decimal separator with comma (",") and thousand separator with dot (".") but it still the same result.
i also try to change cultureinfo and change the date time format as "dd MMMM yyyy" and making change to numberformat as decimal separator use comma (",") and thousand separator uses dot (".") but the result still the same.
and i also confuse, after i have changed the date format with "dd MMMM yyyy" in cultureinfo why does the datetime picker still use date format from regional seting in registry (that changed via control panel), i think it must follow the current thread culture info?
please help me
I have a field in database mySQL with decimal datatyope format. say it has value ie. 25.75 when I try to retrieve this field, it returns as 2,575 (not decimal) i have tried to convert it by using CDec function but it still returns as above. than i try to use .GetDecimal within datareader it still the same result. than i try to change regional setting via control panel and change the decimal separator with comma (",") and thousand separator with dot (".") but it still the same result.
i also try to change cultureinfo and change the date time format as "dd MMMM yyyy" and making change to numberformat as decimal separator use comma (",") and thousand separator uses dot (".") but the result still the same.
and i also confuse, after i have changed the date format with "dd MMMM yyyy" in cultureinfo why does the datetime picker still use date format from regional seting in registry (that changed via control panel), i think it must follow the current thread culture info?
please help me
