Exception at the time of Writing xml File

hi

I am writing following program means i want to write an xml file but value com from database but it is giving me an exception can any one help me.....?

Token StartAttribute in state Element Content would result in an invalid XML document. /// This is Exception which is thrown

XmlWriter DocWrite = XmlWriter.Create(Server.MapPath("~/MyProfile.xml"));

string source = @"server=KBBALOCH-PC\SQLEXPRESS; integrated security=true; database=test";

con = new SqlConnection(source);

con.Open();

string query = "select * from Table_1";

cmd = new SqlCommand(query, con);

reader = cmd.ExecuteReader();

DocWrite.WriteStartDocument();

DocWrite.WriteStartElement("BioDATA");

while (reader.Read())

{

DocWrite.WriteStartElement("Name");

DocWrite.WriteElementString("FName", reader["name"].ToString());

DocWrite .WriteAttributeString("Gender",reader["gender"].ToString());

DocWrite.WriteEndElement();

}

DocWrite.WriteEndElement();

DocWrite.WriteEndDocument();

DocWrite.Close();

con.Close();

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
thread got resolved?
Suthish Nair15y ago
using System.Xml;

XmlTextWriter DocWrite = new XmlTextWriter(Server.MapPath("~/MyProfile.xml"), null);
   DocWrite.Formatting = Formatting.Indented;
   DocWrite.WriteStartElement("BioDATA");

   for (int i = 0; i < 5; i++)
   {
   DocWrite.WriteStartElement("Name");
   DocWrite.WriteAttributeString("FName", i.ToString());
   DocWrite.WriteAttributeString("Gender", i.ToString());
   DocWrite.WriteEndElement();
   }

   DocWrite.WriteEndElement();
   DocWrite.Close();

o/p: