private XmlDocument DataTableToXmlDocument(ref DataTable dt)
<pre>{
XmlDocument xml= new XmlDocument();
StringBuilder sb = new StringBuilder();
sb.Append("='1.0'='utf-8'");
sb.Append("<DocumentElement>");
foreach (DataRow dr in dt.Rows)
{
sb.Append("<" + dt.TableName + ">");
foreach (DataColumn dc in dt.Columns)
sb.Append("<" + dc.ColumnName + ">" +
dr[dc].ToString() +
"</" + dc.ColumnName + ">");
sb.Append("</" + dt.TableName + ">");
}
sb.Append("</DocumentElement>");
xml.LoadXml(sb.ToString());
return xml;
}