Question

在c# 中如何将查询得的XmlNodeList数据读取到dataGridView，例如

XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load("reader.xml");
XmlNodeList xList = xmlDoc.SelectNodes(sqlStatement);
DataSet myds = new DataSet();
myds.ReadXml(new StringReader(“如果是node就可以用xList.OuterXml)”);
dataGridView1.DataSource = myds.Tables["tb_Reader"];
dataGridView1.DataBind();
但是是 XmlNodeList，不知道怎么把数据读取到dataGridView中。大神帮忙。

Answer 1

你把 xml 的格式 拿出来 看下啊。XmlNodeList xList = xmlDoc.SelectNodes(sqlStatement);
结束 后 用 foreach 取值 。然后 add 到list集合中。

追问

1012
亮亮
计算机科学与技术学院
女
软件2
18750930835

就是一般的XML，可以把list转化为其他可以直接读取数据吗

追答

string dd = ""; dd += "";
dd += "1012";
dd += "亮亮";
dd += "计算机科学与技术学院";
dd += "女";
dd += "软件2";
dd += "18750930835";
dd += "";
dd += "";

TextReader txtReader = new StringReader(dd);
XElement doc = XElement.Load(txtReader);
var ddd= (from el in doc.Elements()
select new xmls
{
ReaderClass = el.Element("readerClass").Value,
ReaderCollege = el.Element("readerCollege").Value,
ReaderID = el.Element("readerID").Value,
ReaderPhone = el.Element("readerID").Value,
ReaderSex = el.Element("readerSex").Value

}
).ToList();
dataGridView1.DataSource = ddd;
public class xmls
{
private string readerID;

public string ReaderID
{
get { return readerID; }
set { readerID = value; }
}
private string readerName;
private string readerCollege;
public string ReaderCollege
{
get { return readerCollege; }
set { readerCollege = value; }
}
private string readerSex;
public string ReaderSex
{
get { return readerSex; }
set { readerSex = value; }
}
private string readerClass;
public string ReaderClass
{
get { return readerClass; }
set { readerClass = value; }
}
private string readerPhone;
public string ReaderPhone
{
get { return readerPhone; }
set { readerPhone = value; }
}
}