已解决有人来拿分么?
doc.LoadXml(xml);//加载xml
XmlNodeList movieList = doc.SelectNodes("//filmUs/filmU");
DataTable dt = GetDataTable(xml);
DataView dv = new DataView(dt);
dv.Sort = "@dateIn DESC";
dt = dv.ToTable();
public static DataTable GetDataTable(string xmlStr)
{
XmlDocument doc = new XmlDocument();
doc.LoadXml(xmlStr); XmlNodeList xlist = doc.SelectNodes("//filmUs/filmU");
DataTable Dt = new DataTable();
DataRow Dr; for (int i = 0; i < xlist.Count; i++)
{
Dr = Dt.NewRow();
XmlElement xe = (XmlElement)xlist.Item(i);
for (int j = 0; j < xe.Attributes.Count; j++)
{
if (!Dt.Columns.Contains("@" + xe.Attributes[j].Name))
Dt.Columns.Add("@" + xe.Attributes[j].Name);
Dr["@" + xe.Attributes[j].Name] = xe.Attributes[j].Value;
}
for (int j = 0; j < xe.ChildNodes.Count; j++)
{
if (!Dt.Columns.Contains(xe.ChildNodes.Item(j).Name))
Dt.Columns.Add(xe.ChildNodes.Item(j).Name);
Dr[xe.ChildNodes.Item(j).Name] = xe.ChildNodes.Item(j).InnerText;
}
Dt.Rows.Add(Dr);
}
return Dt;
}
doc.LoadXml(xml);//加载xml
XmlNodeList movieList = doc.SelectNodes("//filmUs/filmU");
DataTable dt = GetDataTable(xml);
DataView dv = new DataView(dt);
dv.Sort = "@dateIn DESC";
dt = dv.ToTable();
public static DataTable GetDataTable(string xmlStr)
{
XmlDocument doc = new XmlDocument();
doc.LoadXml(xmlStr); XmlNodeList xlist = doc.SelectNodes("//filmUs/filmU");
DataTable Dt = new DataTable();
DataRow Dr; for (int i = 0; i < xlist.Count; i++)
{
Dr = Dt.NewRow();
XmlElement xe = (XmlElement)xlist.Item(i);
for (int j = 0; j < xe.Attributes.Count; j++)
{
if (!Dt.Columns.Contains("@" + xe.Attributes[j].Name))
Dt.Columns.Add("@" + xe.Attributes[j].Name);
Dr["@" + xe.Attributes[j].Name] = xe.Attributes[j].Value;
}
for (int j = 0; j < xe.ChildNodes.Count; j++)
{
if (!Dt.Columns.Contains(xe.ChildNodes.Item(j).Name))
Dt.Columns.Add(xe.ChildNodes.Item(j).Name);
Dr[xe.ChildNodes.Item(j).Name] = xe.ChildNodes.Item(j).InnerText;
}
Dt.Rows.Add(Dr);
}
return Dt;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货