下面XML绑定到Dataset里有两个表，如何将两个不同表合并

Question

<?xml version="1.0" encoding="utf-8" ?>
<trades_sold_increment_get_response>
  <trades list="true">
    <trade>
      <adjust_fee>0.00</adjust_fee>
      <buyer_nick>露1992319</buyer_nick>
      <buyer_obtain_point_fee>0</buyer_obtain_point_fee>
      <buyer_rate>false</buyer_rate>
      <cod_fee>0.00</cod_fee>
      <created>2010-09-01 23:24:19</created>
      <discount_fee>0.00</discount_fee>
      <iid>a4c034de840468adcddfd735a0abcbad</iid>
      <modified>2010-09-01 23:24:20</modified>
      <num>1</num>
      <orders list="true">
        <order>
          <adjust_fee>0.00</adjust_fee>
          <buyer_rate>false</buyer_rate>
          <discount_fee>0.00</discount_fee>
          <iid>a4c034de840468adcddfd735a0abcbad</iid>
          <num>1</num>
          <num_iid>6200236969</num_iid>
          <oid>46256094315938</oid>
          <payment>288.00</payment>
          <pic_path>http://img04.taobaocdn.com/bao/uploaded/i4/T1PMBIXcNNXXaOahk8_100622.jpg</pic_path>
          <price>288.00</price>
          <refund_status>NO_REFUND</refund_status>
          <seller_rate>false</seller_rate>
          <seller_type>B</seller_type>
          <sku_id>4292559675</sku_id>
          <sku_properties_name>颜色分类:绿色;尺码:35</sku_properties_name>
          <status>WAIT_BUYER_PAY</status>
          <title>正品10年新款星期六 防水台 鱼嘴 高跟 时尚女鞋 SSA1SF2219,2219</title>
          <total_fee>288.00</total_fee>
        </order>
      </orders>
      <payment>288.00</payment>
      <pic_path>http://img04.taobaocdn.com/bao/uploaded/i4/T1PMBIXcNNXXaOahk8_100622.jpg</pic_path>
      <point_fee>0</point_fee>
      <post_fee>0.00</post_fee>
      <price>288.00</price>
      <real_point_fee>0</real_point_fee>
      <received_payment>0.00</received_payment>
      <receiver_address>安徽省六安市裕安区独山镇</receiver_address>
      <receiver_city>六安市</receiver_city>
      <receiver_district>裕安区</receiver_district>
      <receiver_mobile>13470847462</receiver_mobile>
      <receiver_name>汪露露</receiver_name>
      <receiver_state>安徽省</receiver_state>
      <receiver_zip>237131</receiver_zip>
      <seller_nick>星期六官方旗舰店</seller_nick>
      <seller_rate>false</seller_rate>
      <shipping_type>express</shipping_type>
      <sid>46256094315938</sid>
      <status>WAIT_BUYER_PAY</status>
      <tid>46256094315938</tid>
      <title>星期六官方旗舰店</title>
      <total_fee>288.00</total_fee>
      <type>fixed</type>
    </trade> DataRelation relation = new DataRelation("",
ds.Tables["trade"].Columns["tid"],
ds.Tables["order"].Columns["oid"],false );
        ds.Relations.Add(relation);          GridView2.DataSource = ds;
        GridView2.DataBind();我用了此方法，但是绑定到GriDview只显示出来如下结果，请问到底我应该怎么合并Dataset里两个不同的表   trades_sold_increment_get_response_Id total_results 
0                                         73 

Answer 1

楼主是说XML里有两个表？
那就直接把XML当成数据表直接当成表就行了

Answer 2

GriDview具体要显示哪些信息（哪几列）？

Answer 3

两个DataSet合并到一起:
DataSet ds1;
DataSet ds2;
ds1.Merge(ds2);

Answer 4

可是这两个表里trade父表只会有一个，但可能order表可能会有多个，而且order表里的title与父表title字段一样，
<?xml version="1.0" encoding="utf-8" ?>
<trades_sold_increment_get_response>
  <trades list="true">
    <trade>
      <adjust_fee>0.00</adjust_fee>
      <buyer_nick>露1992319</buyer_nick>
      <buyer_obtain_point_fee>0</buyer_obtain_point_fee>
      <buyer_rate>false</buyer_rate>
      <cod_fee>0.00</cod_fee>
      <created>2010-09-01 23:24:19</created>
      <discount_fee>0.00</discount_fee>
      <iid>a4c034de840468adcddfd735a0abcbad</iid>
      <modified>2010-09-01 23:24:20</modified>
      <num>1</num>
      <orders list="true">
        <order>
          <adjust_fee>0.00</adjust_fee>
          <buyer_rate>false</buyer_rate>
          <discount_fee>0.00</discount_fee>
          <iid>a4c034de840468adcddfd735a0abcbad</iid>
          <num>1</num>
          <num_iid>6200236969</num_iid>
          <oid>46256094315938</oid>
          <payment>288.00</payment>
          <pic_path>http://img04.taobaocdn.com/bao/uploaded/i4/T1PMBIXcNNXXaOahk8_100622.jpg</pic_path>
          <price>288.00</price>
          <refund_status>NO_REFUND</refund_status>
          <seller_rate>false</seller_rate>
          <seller_type>B</seller_type>
          <sku_id>4292559675</sku_id>
          <sku_properties_name>颜色分类:绿色;尺码:35</sku_properties_name>
          <status>WAIT_BUYER_PAY</status>
          <title>正品10年新款星期六 防水台 鱼嘴 高跟 时尚女鞋 SSA1SF2219,2219</title>
          <total_fee>288.00</total_fee>
        </order>
      </orders>      <orders list="true">
        <order>
          <adjust_fee>0.00</adjust_fee>
          <buyer_rate>false</buyer_rate>
          <discount_fee>0.00</discount_fee>
          <iid>a4c034de840468adcddfd735a0abcbad</iid>
          <num>1</num>
          <num_iid>6200236969</num_iid>
          <oid>46256094315938</oid>
          <payment>288.00</payment>
          <pic_path>http://img04.taobaocdn.com/bao/uploaded/i4/T1PMBIXcNNXXaOahk8_100622.jpg</pic_path>
          <price>288.00</price>
          <refund_status>NO_REFUND</refund_status>
          <seller_rate>false</seller_rate>
          <seller_type>B</seller_type>
          <sku_id>4292559675</sku_id>
          <sku_properties_name>颜色分类:绿色;尺码:35</sku_properties_name>
          <status>WAIT_BUYER_PAY</status>
          <title>正品10年新款星期六 防水台 鱼嘴 高跟 时尚女鞋 SSA1SF2219,2219</title>
          <total_fee>288.00</total_fee>
        </order>
      </orders>
      <payment>288.00</payment>
      <pic_path>http://img04.taobaocdn.com/bao/uploaded/i4/T1PMBIXcNNXXaOahk8_100622.jpg</pic_path>
      <point_fee>0</point_fee>
      <post_fee>0.00</post_fee>
      <price>288.00</price>
      <real_point_fee>0</real_point_fee>
      <received_payment>0.00</received_payment>
      <receiver_address>安徽省六安市裕安区独山镇</receiver_address>
      <receiver_city>六安市</receiver_city>
      <receiver_district>裕安区</receiver_district>
      <receiver_mobile>13470847462</receiver_mobile>
      <receiver_name>汪露露</receiver_name>
      <receiver_state>安徽省</receiver_state>
      <receiver_zip>237131</receiver_zip>
      <seller_nick>星期六官方旗舰店</seller_nick>
      <seller_rate>false</seller_rate>
      <shipping_type>express</shipping_type>
      <sid>46256094315938</sid>
      <status>WAIT_BUYER_PAY</status>
      <tid>46256094315938</tid>
      <title>星期六官方旗舰店</title>
      <total_fee>288.00</total_fee>
      <type>fixed</type>
    </trade>