我写的程序如下:
.....
cmd = new SqlCommand("select * from tableA for xml auto", conn);
XmlReader sr = cmd.ExecuteXmlReader();
DataTable t = new DataTable();
t.ReadXml(sr);但是运行到最后一句出错:DataTable does not support schema inference from Xml.
请问怎么做?多谢
.....
cmd = new SqlCommand("select * from tableA for xml auto", conn);
XmlReader sr = cmd.ExecuteXmlReader();
DataTable t = new DataTable();
t.ReadXml(sr);但是运行到最后一句出错:DataTable does not support schema inference from Xml.
请问怎么做?多谢
XmlReader sr = cmd.ExecuteXmlReader();
DataSet t = new DataSet ();
t.ReadXml(sr);
+++++++++++++++++ReadXml返回是DataSet,不是DataTable。
要转成dataTable,那又为什么要从数据库中返回xml呢?为什么不直接用sqlDataAdapter.fill(ds,tablename)呢?