用dataset连接数据库生成XML

要学会 TREEVIEW控件绑定数据库，所以先对XML有个了解
这里的是用DATASET的WRITEXML方法来生成一个XML文件   ！
而对应的就有个GETXML方法！这里就不再写出，，，
 Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim con As SqlConnection
        Dim da As SqlDataAdapter
        Dim ds As DataSet
        Dim strXML As String
        con = New SqlConnection("server=(local);uid=sa;pwd=;database=lab")
        da = New SqlDataAdapter("select * from Student_Table", con)
        ds = New DataSet
        da.Fill(ds, "Student_Table")
        'DataGrid1.DataSource = ds
        'DataGrid1.DataBind()
        ds.WriteXml("e:/myXML.xml")
        Label1.Text = "Saved!"
 End Sub
End Class
。。。。。。。。。。。。。。。。。。。。。。。。
结果：（有点多，哈哈~不过很标准哦，，）
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
  <Student_Table>
    <xno>100005</xno>
    <xname>挖哈哈    </xname>
    <college>外语学院</college>
    <department>大吟系</department>
    <specialty>国际外貌</specialty>
    <grade>02</grade>
    <class>6</class>
    <password>234567</password>
  </Student_Table>
  <Student_Table>
    <xno>111111</xno>
    <xname>xiao      </xname>
    <college>wahaha</college>
    <department>dsdf</department>
    <specialty>sdsdfsf</specialty>
    <grade>22</grade>
    <class>3</class>
    <password>123456</password>
  </Student_Table>
  <Student_Table>
    <xno>222432</xno>
    <xname>大字      </xname>
    <college>冻豆腐</college>
    <department>工人各个上</department>
    <specialty>热儿歌外</specialty>
    <grade>23</grade>
    <class>2</class>
    <password>123456</password>
  </Student_Table>
  <Student_Table>
    <xno>234233</xno>
    <xname>挖哈哈    </xname>
    <college>数学学院</college>
    <department>赌东道达到</department>
    <specialty>不知道 </specialty>
    <grade>23</grade>
    <class>4</class>
    <password>4545443</password>
  </Student_Table>
  <Student_Table>
    <xno>322232</xno>
    <xname>大幅度法  </xname>
    <college>人文学院</college>
    <department>大幅度法地方</department>
    <specialty>踏歌台</specialty>
    <grade>34</grade>
    <class>2</class>
    <password>343533</password>
  </Student_Table>
  <Student_Table>
    <xno>445442</xno>
    <xname>3仍然     </xname>
    <college>挖哈哈</college>
    <department>回归热个</department>
    <specialty>大幅度法</specialty>
    <grade>34</grade>
    <class>3</class>
    <password>3435</password>
  </Student_Table>
</NewDataSet>