将DataSet转换为xml时,若DataSet某一列全部为dbnull时,方法1不会丢失该列,方法2会丢失该列。
方法1:
using (StringWriter sw = new StringWriter())
{
ds.WriteXml(sw, XmlWriteMode.WriteSchema);
ReturnXml = sw.ToString();
return ReturnXml;
}
方法2:
ReturnXml = ds.GetXml();
//读取xml到dataset中
using(System.IO.StringReader sr = new System.IO.StringReader(returnXML))
{
ds.ReadXml(sr);
return ds.Tables[0];
}