XML and utf-8

[jonathan]

Hi

I have a small and easy program that write a RSS.

Althought the generation works perfect, IE tells me it's not valid.

I get crazy because :
-removing a space at the end of the generated XML seems to help
-It refuses to read more than 5 items in the RSS

there is something i miss there in the XML. It drives me crazy.

Thanks for any help or any link giving help to XML problems

Jonathan

MemoryStream ms = new MemoryStream();
XmlTextWriter writer = new XmlTextWriter(ms,
System.Text.Encoding.UTF8);
writer.Formatting = Formatting.Indented;
WriteRSSPrologue(writer);

SqlConnection Sqlconnection=new SqlConnection ("Data
Source=;Initial Catalog=L;User=;Password=");

SqlCommand cmd=new SqlCommand("select Top 5
articlenum,ArticleTitle,folderpath,teasertext from tblArticleList
where published='t'",Sqlconnection);
Sqlconnection.Open();
SqlDataReader dr=cmd.ExecuteReader();

while(dr.Read())
{
AddRSSItem(writer,dr.GetString (1),dr.GetString (2),dr.GetString
(3));

}

Sqlconnection.Close();
WriteRSSClosing(writer);

writer.Flush();
writer.Close();

Response.ContentEncoding = System.Text.Encoding.Unicode;
Response.ContentType = "text/xml";
Response.Cache.SetCacheability(HttpCacheability.Pu blic);

String FILENAME = Server.MapPath("La.xml");
StreamWriter objStreamWriter = File.AppendText(FILENAME);
//Response.Write (System.Text.Encoding.UTF8.GetString(ms.GetBuffer( )).TrimEnd());
objStreamWriter.Write(System.Text.Encoding.UTF8.Ge tString(ms.GetBuffer()).TrimEnd());

objStreamWriter.Close();


ms.Close();
}

[jonathan]

Oleg

I have been able to identify the problem althought i did not find a
solution.

The generated XML is simply perfectly formed BUT the XMLTextWriter
class adds some garbage caracters at the begining and then end(what i
believed to be spaces where strange characters i could not see in
notedpad)

Jonathan

Oleg Tkachenko <oleg@NO_SPAM_PLEASEtkachenko.com> wrote in message news:<uZ**************@TK2MSFTNGP12.phx.gbl>...

jonathan wrote:

I have a small and easy program that write a RSS.

Althought the generation works perfect, IE tells me it's not valid.

I get crazy because :
-removing a space at the end of the generated XML seems to help
-It refuses to read more than 5 items in the RSS

there is something i miss there in the XML. It drives me crazy.

Show us resulting XML (or better make it available on the Net).

[SQL Server Development Team [MSFT]]

"Oleg Tkachenko" <oleg@NO_SPAM_PLEASEtkachenko.com> wrote in message
news:uY**************@tk2msftngp13.phx.gbl...

jonathan wrote:

The generated XML is simply perfectly formed BUT the XMLTextWriter
class adds some garbage caracters at the begining and then end(what i
believed to be spaces where strange characters i could not see in
notedpad)
The charcters at the beginning are probably unicode BOM - byte order mark.
Can you save your document and place it on the net for us to eb able to

see it? I hardly can say something without seeing those "garbage chars".

The problem may be this code:
StreamWriter objStreamWriter = File.AppendText(FILENAME);

objStreamWriter.Write(System.Text.Encoding.UTF8.Ge tString(ms.GetBuffer()).Tr
imEnd());
objStreamWriter.Close();
A) Why not just hand objStreamWriter to XmlTextWriter (objStreamWriter is an
instance of System.IO.StreamWriter which subclasses System.IO.TextWriter,
and XmlTextWriter has a constructor which takes a TextWriter)

B) Rewrite it like this:
Stream outStream = File.Open( FILENAME, FileMode.Append );
ms.WriteTo( outStream );
outStream.Close();
ms.Close();

-derek

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.