XmlDataDocument与DataSet相互转化

1.

using System.Text;
 using System.IO;
 
XmlNode xmlNode1;
XmlDataDocument xd=new XmlDataDocument();
StringBuilder xmlString1;
 
xmlNode1=DataSet1;//DataSet1为返回的数据集
 if(xmlNode1==null) //--存储过程执行失败
return;
xmlString1=new StringBuilder(xmlNode1.OuterXml);
if(xmlString1.ToString().Equals("<NewDataSet xmlns=\"\"></NewDataSet>"))    return ;
xd.LoadXml(xmlString1.ToString());
DataSet ds=new DataSet();
ds.ReadXml(new XmlNodeReader(xd));
DataGrid1.DataSource=ds.Tables[0].DefaultView;
DataGrid1.DataBind();
 

2

XmlDataDocument xd=new XmlDataDocument();

 if((int)ds.Tables[0].DefaultView.Count<1)
 {
 string xml="<NewDataSet></NewDataSet>";
 xd.LoadXml(xml);
 return xd;
 }
 xd=new XmlDataDocument(ds);
 XmlNode root1=xd.DocumentElement;
 XmlNodeList roots=root1.SelectNodes("list");  
foreach(XmlNode roota in  roots)  //为所有元素加上站点名称标记
 {
 XmlElement Link=xd.CreateElement("SiteName");
 Link.InnerText=ConfigurationSettings.AppSettings["SiteName"].ToString();
 roota.AppendChild(Link);
 }
 return xd;