数据是在属性当中的xml,并且属性值不是固定的,怎么样把它取出来赋给DataSet啊,急求!例下:
<?xml version="1.0" encoding="gb2312"?>
<?xml-stylesheet type="text/xsl" href="report.xsl"?>
<report>
<table>
<columns>
<column name="campaign" />
<column name="adgroup" />
<column name="keyword" />
<column name="kwType" />
<column name="kwStatus" />
</columns>
<rows>
<row campaign="广告系列编号 1" adgroup="71cnc" keyword="域名注册" kwType="Broad" kwStatus="Active" />
<row campaign="广告系列编号 1" adgroup="71cnc" keyword="网站建设" kwType="Broad" kwStatus="Active" />
</rows>
</table>
<totals>
<grandtotal imps="63590" clicks="421" ctr="0.0066205378204120145" cpc="768741" cost="323640000" pos="4.235021229753106" />
</totals>
</report>
<?xml version="1.0" encoding="gb2312"?>
<?xml-stylesheet type="text/xsl" href="report.xsl"?>
<report>
<table>
<columns>
<column name="campaign" />
<column name="adgroup" />
<column name="keyword" />
<column name="kwType" />
<column name="kwStatus" />
</columns>
<rows>
<row campaign="广告系列编号 1" adgroup="71cnc" keyword="域名注册" kwType="Broad" kwStatus="Active" />
<row campaign="广告系列编号 1" adgroup="71cnc" keyword="网站建设" kwType="Broad" kwStatus="Active" />
</rows>
</table>
<totals>
<grandtotal imps="63590" clicks="421" ctr="0.0066205378204120145" cpc="768741" cost="323640000" pos="4.235021229753106" />
</totals>
</report>
DataSet ds = new DataSet();
ds.ReaderXml(xmlPath);
这样就将xml读入到了DataSet
losingrose
http://seawind.isme.net
[email protected]
[email protected]
ds.ReadXml(Server.MapPath("WebForm1.xml")); for(int i=0;i<ds.Tables.Count;i++)
{
Response.Write(String.Format("表 {0}:{1}", i, ds.Tables[i].TableName));
Response.Write("<br>");
} DataGrid1.DataSource = ds.Tables["row"];
DataGrid1.DataBind();