把数据转换到有嵌套的XML格式

Question

请教怎么把查到到的数据转换为这样的 XML格式，如果没有嵌套是能搞定，但是嵌套这里就搞不明白，
<DATASETS>
         <DATASET>
               <PLAN_YEAR>2010</PLAN_YEAR>
               <PLAN_MONTH>06</PLAN_MONTH>
               <PROTOCAL_NO>10938374</PROTOCAL_NO>
               <STATUS>1</STATUS>
               <ADJUST_STATUS>0</ADJUST_STATUS>
         <BRANDS>
            <BRAND>
         <BRAND_CODE>123456</BRAND_CODE>
         <BRAND_NAME>一品</BRAND_NAME>
         <DEMAND_AMOUNT>200</DEMAND_AMOUNT>
         <SUPPLY_AMOUNT>200</SUPPLY_AMOUNT>
         <JOIN_AMOUNT>200</JOIN_AMOUNT>
         <ADJUST_AMOUNT>200</ADJUST_AMOUNT>
           </BRAND>
                    <BRAND>
         <BRAND_CODE>123456</BRAND_CODE>
         <BRAND_NAME>一品</BRAND_NAME>
         <DEMAND_AMOUNT>200</DEMAND_AMOUNT>
         <SUPPLY_AMOUNT>200</SUPPLY_AMOUNT>
         <JOIN_AMOUNT>200</JOIN_AMOUNT>
         <ADJUST_AMOUNT>200</ADJUST_AMOUNT>
         </BRAND>
         </BRANDS>
         </DATASET>
        </DATASETS>

Answer 1

只要结构确定你找些linq to xml的资料， 
很好实现。