要学会 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>
用dataset连接数据库生成XML
最新推荐文章于 2013-03-22 00:05:00 发布