比如这样的 XML :
<Customers>
<s_name>市1</s_name>
<qx_name>区1</qx_name>
<jd_name>XX路</jd_name>
<s_id>1</s_id>
<qx_id>1</qx_id>
<jd_id>89</jd_id>
</Customers>
<Customers>
<s_name>市1</s_name>
<qx_name>区1</qx_name>
<jd_name>YYY路</jd_name>
<s_id>1</s_id>
<qx_id>1</qx_id>
<jd_id>86</jd_id>
</Customers>
<Customers>
<s_name>市3</s_name>
<qx_name>区1<qx_name>
<jd_name>街道1</jd_name>
<s_id>3</s_id>
<qx_id>15</qx_id>
<jd_id>87</jd_id>
</Customers>解释:s_id 市ID s_name 市名称
qx_id 区县ID qx_name 区县名称
jd_id 街道ID jd_name 街道名称
我可以用
DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath("myXml2.xml"));
DropDownList1.DataSource = ds;把XML的数据全部读取出来
但,我不知道怎么从 XML 里面读取部分数据,比如是提取下面的数据select s_id,s_name from table group by s_id //提取城市ID、城市名称望赐教!
<Customers>
<s_name>市1</s_name>
<qx_name>区1</qx_name>
<jd_name>XX路</jd_name>
<s_id>1</s_id>
<qx_id>1</qx_id>
<jd_id>89</jd_id>
</Customers>
<Customers>
<s_name>市1</s_name>
<qx_name>区1</qx_name>
<jd_name>YYY路</jd_name>
<s_id>1</s_id>
<qx_id>1</qx_id>
<jd_id>86</jd_id>
</Customers>
<Customers>
<s_name>市3</s_name>
<qx_name>区1<qx_name>
<jd_name>街道1</jd_name>
<s_id>3</s_id>
<qx_id>15</qx_id>
<jd_id>87</jd_id>
</Customers>解释:s_id 市ID s_name 市名称
qx_id 区县ID qx_name 区县名称
jd_id 街道ID jd_name 街道名称
我可以用
DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath("myXml2.xml"));
DropDownList1.DataSource = ds;把XML的数据全部读取出来
但,我不知道怎么从 XML 里面读取部分数据,比如是提取下面的数据select s_id,s_name from table group by s_id //提取城市ID、城市名称望赐教!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货