C# Create XML, has extra slash

[James Rose]

Hello gang,

 

I am creating an xml document from data from a database.  However when I write them as an attribute it gets an extra slash

<Trend Ident=\"1\" Info=\"Test1\" />

The database has only "Test1"

 

The code is as follows:

                while (drGet.Read())
                {
                    XmlElement Trend = xmlTrending.CreateElement("Trend");
                    Trend.SetAttribute("Ident", drGet.GetInt32(0).ToString());
                    Trend.SetAttribute("Info", drGet.GetString(1));
                    Trends.AppendChild(Trend);
                }

Thanks

[scumdogmillionaire]

are you talking about the escape in front of the quote?

[James Rose]

are you talking about the escape in front of the quote?

 

Yes.

[Eric Veteran]

Where are you seeing the escape slashes? They will show up in the data inspector while debugging but should be output as text without them.

[gohpep]

What's the drGet function?

[articuno1au]

I believe drGet is a data row object (or a collection of DataRow).

 

Depending on the DB provider, is it possible you're being provided escape characters in the returned data?

[gohpep]

you're being provided escape characters in the returned data?

That's what I was thinking too.