CODEWITHSUNDEEP
c#asp.net.netencoding
Shato-Umar Daltsaev
Shato-Umar Daltsaev

Reputation: 141

Encoding problems when reading XML from a Russian website

I`m get values in xml, from a Russian bank's web service (source: http://www.cbr.ru/scripts/XML_daily.asp)

My ASP.NET code:

<%@ Page   Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="WebApplication4.WebForm1" CodePage="65001"  %>

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
    <title></title>
</head>
<body>
<form id="form1" runat="server">
<asp:GridView ID="volutes" runat="server" >
<HeaderStyle BackColor="#df5015" Font-Bold="true" ForeColor="White" />
</asp:GridView>
</form>
</body>
</html>

My C# code:

            DataTable dt = new DataTable();
            WebClient client = new WebClient();
            Stream stream = client.OpenRead("http://www.cbr.ru/scripts/XML_daily.asp");
            StreamReader reader = new StreamReader(stream);
            String content = reader.ReadToEnd();
            XmlDocument xml = new XmlDocument();
            xml.LoadXml(content);


            dt.Columns.Add("Name", typeof(string));
            dt.Columns.Add("Value", typeof(string));
            XmlNodeList nodeList = xml.SelectNodes("/ValCurs/Valute");
            foreach (XmlNode node in nodeList)
            {
                DataRow dtrow = dt.NewRow();
                dtrow["Name"] = node["Name"].InnerText;
                dtrow["Value"] = node["Value"].InnerText;
                dt.Rows.Add(dtrow);
            }
            volutes.DataSource = dt;
            volutes.DataBind();

Оn the results page I`m see:

 Name                                 Value
������������� ������    46,0642

Why?

Upvotes: 1

Views: 1094

Answers (1)

Patrick Hofman
Patrick Hofman

Reputation: 156978

You should use the correct encoding for your StreamReader and pass that in the constructor, else the reader will use UTF-16 LE by default:

using (StreamReader reader = new StreamReader( stream
                                             , Encoding.GetEncoding("windows-1251")
                                             )
      )
{
}

Upvotes: 5

Related Questions