try something like DataSet dataSet = new DataSet();string xmlData = "<XmlDS><table1><col1>Value1</col1></table1><table1><col1>Value2</col1></table1></XmlDS>";System.IO.StringReader reader = new System.IO.StringReader(xmlData);orSystem.IO.StringReader reader = new System.IO.StringReader(xmlDoc.DocumentElement.OuterXml);thendataSet.ReadXml(reader);
DataSet dataSet = new DataSet();string xmlData = "<XmlDS><table1><col1>Value1</col1></table1><table1><col1>Value2</col1></table1></XmlDS>";System.IO.StringReader reader = new System.IO.StringReader(xmlData);orSystem.IO.StringReader reader = new System.IO.StringReader(xmlDoc.DocumentElement.OuterXml);thendataSet.ReadXml(reader);
thisDataSet.WriteXml(filename,XmlWriteMode.DiffGram );
//读xml
thisDataSet.ReadXml(filename,XmlReadMode.DiffGram );
string xmlpath =string(文件路径);
//取得目录下所有文件
string[] fileNames = Directory.GetFiles(xmlpath);
//循环读取
foreach(string sfile in fileNames)
{
System.Data.DataSet xmllog = new DataSet();
xmllog.ReadXml(sfile);
if (ds.Tables .Count ==0)
ds.Tables.Add(xmllog.Tables[0].Copy());
else
ds.Merge(xmllog.Tables[0]);
}
_sqlTest.ReadXml(new MemoryStream(Encoding.Unicode.GetBytes(_dbDataset.GetXml())));
_dbDataset.GetXml()就是动态生成的XML,不过好像是解析有点问题,我还没有解决,你试验一下吧。