When i try to retrieve swedish characters like Ö Å é
from the database into the dataset, it is displayed as Ã– Ã… Ã©
when I view the dataset values by debugging.
How do I correctly retrieve the data?
I have tried the following which didn't work:
1. In code behind:
Dim currentCultureInfo As New CultureInfo("sv-SE")
dataSet.Locale = currentCultureInfo
2. In web.config :
<globalizatio<n fileEncoding="utf-8" requestEncoding="utf-8" responseEncoding="utf-8" culture="sv-SE" uiCulture="en-US" />
Kindly help me sort this issue.
Thanks in Advance !!!