关于xml排序的问题

Question

datatable dt=new datatable();
dt.rows.add("columnsname");
for(int i=0;i<5;i++){
   datarow dr=dt.newrow();
   dr[0]=dv[0].Row[i][0].Tostring();
} 
objPds.DataSource = dt.defaultview;
objPds.DataBind();

Answer 1

更正：）
DataTable dt=new DataTable();
dt.Rows.Add("columnsname");
for(int i=0;i<5;i++){
   DataRow dr=dt.NewRow();
   dr[0]=dv[i].Row[0].Tostring();
   dt.Rows.Add(dr);
} 
objPds.DataSource = dt.defaultview;
objPds.DataBind();

Answer 2

这是我的原码
DataSet ds=new DataSet();
System.IO.StreamReader sr=new System.IO.StreamReader(Server.MapPath("XML/X_page/resourceinfo.xml"));
ds.ReadXml(sr);
sr.Close();
DataView dv=ds.Tables[0].DefaultView;
dv.Sort=" XmlCode desc";
   DataTable dt=new DataTable();
   dt.Columns.Add("XmlCode");
for(int i=0;i<5;i++)
{
DataRow dr=dt.NewRow();
dr[0]=dv[i].Row[0].ToString();
} 
objPds.DataSource =dt.DefaultView;
objPds.DataBind(); 
这是xml
<?xml version="1.0" encoding="utf-8"?>
<resourceinfo>
  <XmlData id="20040611092144">
    <topicid>14</topicid>
    <topicnav>14,15</topicnav>
    <Titlename>无数据库开发</Titlename>
    <keyword>无数据库开发</keyword>
    <comtent>无数据库开发</comtent>
    <auditsign>1</auditsign>
    <assessor>无数据库开发</assessor>
    <topicclass>0</topicclass>
    <promulgator>admin</promulgator>
    <announcetime>2004-6-11</announcetime>
    <clicked>14</clicked>
    <searcherlevel>1</searcherlevel>
    <fileurl>0</fileurl>
    <XmlCode>20040611092144</XmlCode>
  </XmlData>
  <XmlData id="20040611023918">
    <topicid>3</topicid>
    <topicnav>3,19</topicnav>
    <Titlename>信息发布测试</Titlename>
    <keyword>信息发布测试</keyword>
    <comtent>信息发 布测试</comtent>
    <auditsign>1</auditsign>
    <assessor>信息发布测试</assessor>
    <topicclass>0</topicclass>
    <promulgator>admin</promulgator>
    <announcetime>2004-6-15</announcetime>
    <clicked>13</clicked>
    <searcherlevel>1</searcherlevel>
    <fileurl>0</fileurl>
    <XmlCode>20040611023918</XmlCode>
  </XmlData>
  <XmlData id="20040615024051">
    <topicid>3</topicid>
    <topicnav>3,19</topicnav>
    <Titlename>测试信息发布</Titlename>
    <keyword>测试信息发布</keyword>
    <comtent>测试信息发布&amp;lt;br&amp;gt;[a id=ImgSpan href=Upload/images/200406150240491.JPG target=_blank&amp;gt;[img src=Upload/images/200406150240491.JPG width=450  border=0 alt=按此在新窗口浏览图片  onmousewheel=#return bbimg(this)#  onload=#images(this)# ][/a]</comtent>
    <auditsign>1</auditsign>
    <assessor>测试信息发布</assessor>
    <topicclass>0</topicclass>
    <promulgator>admin</promulgator>
    <announcetime>2004-6-15</announcetime>
    <clicked>2</clicked>
    <searcherlevel>1</searcherlevel>
    <fileurl>1.JPG</fileurl>
    <XmlCode>20040615024051</XmlCode>
  </XmlData>
    <XmlData id="20040616023918">
    <topicid>3</topicid>
    <topicnav>3,19</topicnav>
    <Titlename>信</Titlename>
    <keyword>信息发布测试</keyword>
    <comtent>信息发 布测试</comtent>
    <auditsign>1</auditsign>
    <assessor>信息发布测试</assessor>
    <topicclass>0</topicclass>
    <promulgator>admin</promulgator>
    <announcetime>2004-6-15</announcetime>
    <clicked>3</clicked>
    <searcherlevel>1</searcherlevel>
    <fileurl>0</fileurl>
    <XmlCode>20040611023918</XmlCode>
  </XmlData>
    <XmlData id="20040617023918">
    <topicid>3</topicid>
    <topicnav>3,19</topicnav>
    <Titlename>信息</Titlename>
    <keyword>信息发布测试</keyword>
    <comtent>信息发 布测试</comtent>
    <auditsign>1</auditsign>
    <assessor>信息发布测试</assessor>
    <topicclass>0</topicclass>
    <promulgator>admin</promulgator>
    <announcetime>2004-6-15</announcetime>
    <clicked>130</clicked>
    <searcherlevel>1</searcherlevel>
    <fileurl>0</fileurl>
    <XmlCode>20040611023918</XmlCode>
  </XmlData>
    <XmlData id="20040617023920">
    <topicid>3</topicid>
    <topicnav>3,19</topicnav>
    <Titlename>信息发</Titlename>
    <keyword>信息发布测试</keyword>
    <comtent>信息发 布测试</comtent>
    <auditsign>1</auditsign>
    <assessor>信息发布测试</assessor>
    <topicclass>0</topicclass>
    <promulgator>admin</promulgator>
    <announcetime>2004-6-15</announcetime>
    <clicked>113</clicked>
    <searcherlevel>1</searcherlevel>
    <fileurl>0</fileurl>
    <XmlCode>20040611023918</XmlCode>
  </XmlData>
    <XmlData id="20040616023928">
    <topicid>3</topicid>
    <topicnav>3,19</topicnav>
    <Titlename>信息发布</Titlename>
    <keyword>信息发布测试</keyword>
    <comtent>信息发 布测试</comtent>
    <auditsign>1</auditsign>
    <assessor>信息发布测试</assessor>
    <topicclass>0</topicclass>
    <promulgator>admin</promulgator>
    <announcetime>2004-6-15</announcetime>
    <clicked>23</clicked>
    <searcherlevel>1</searcherlevel>
    <fileurl>0</fileurl>
    <XmlCode>20040611023918</XmlCode>
  </XmlData>
    <XmlData id="20040617033918">
    <topicid>3</topicid>
    <topicnav>3,19</topicnav>
    <Titlename>信息发布测</Titlename>
    <keyword>信息发布测试</keyword>
    <comtent>信息发 布测试</comtent>
    <auditsign>1</auditsign>
    <assessor>信息发布测试</assessor>
    <topicclass>0</topicclass>
    <promulgator>admin</promulgator>
    <announcetime>2004-6-15</announcetime>
    <clicked>13</clicked>
    <searcherlevel>1</searcherlevel>
    <fileurl>0</fileurl>
    <XmlCode>20040611023918</XmlCode>
  </XmlData>
</resourceinfo>
怎么什么都显示不出来呀

Answer 3

DataSet ds=new DataSet();
ds.ReadXmlSchema(Server.MapPath("1.xsd"));
ds.ReadXml(Server.MapPath("1.xml"));    
DataView dv=ds.Tables[0].DefaultView;
dv.Sort="clicked desc";
DataTable dt=new DataTable();
dt=ds.Tables[0].Copy();
dt.Clear();
for(int i=0;i<5;i++)
{
DataRow dr=dt.NewRow();
for(int j=0;j<dt.Columns.Count;j++)
{
dr[j]=dv[1].Row[j].ToString();     
}
dt.Rows.Add(dr);
}
dg1.DataSource=dt.DefaultView;
dg1.DataBind();
vs2003,win2003 下测试通过