利用DataSet对Xml文件操作
生活随笔
收集整理的這篇文章主要介紹了
利用DataSet对Xml文件操作
小編覺得挺不錯的,現在分享給大家,幫大家做個參考.
-----------------------------------------------
Dim conn As Data.SqlClient.SqlConnection = New Data.SqlClient.SqlConnection(connstr)
Dim sqlstr As String = "SQL語句"
Dim MyDataAdapter As Data.SqlClient.SqlDataAdapter = New Data.SqlClient.SqlDataAdapter(sqlstr, conn)
Dim MyDataSet As Data.DataSet = New Data.DataSet
MyDataAdapter.Fill(MyDataSet, "數據庫表名")
MyDataSet.WriteXml(Server.MapPath("Xml文件相對路徑")) -------------------------------------------------------------
myDataSet.ReadXml(Server.MapPath("test.xml"))
GridView1.DataSource = myDataSet
GridView1.DataBind()
將DataSet內容寫入Xml文件
----------------------------------------------- Dim connstr As String = "數據庫連接字符串"Dim conn As Data.SqlClient.SqlConnection = New Data.SqlClient.SqlConnection(connstr)
Dim sqlstr As String = "SQL語句"
Dim MyDataAdapter As Data.SqlClient.SqlDataAdapter = New Data.SqlClient.SqlDataAdapter(sqlstr, conn)
Dim MyDataSet As Data.DataSet = New Data.DataSet
MyDataAdapter.Fill(MyDataSet, "數據庫表名")
MyDataSet.WriteXml(Server.MapPath("Xml文件相對路徑")) -------------------------------------------------------------
DataSet讀取Xml文件內容并綁定控件
--------------------------------------------------------------
Dim myDataSet As Data.DataSet = New Data.DataSet()myDataSet.ReadXml(Server.MapPath("test.xml"))
GridView1.DataSource = myDataSet
GridView1.DataBind()
轉載于:https://www.cnblogs.com/ZC_Mo-Blog/archive/2009/03/04/1402997.html
總結
以上是生活随笔為你收集整理的利用DataSet对Xml文件操作的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: 仿qq拖动分页
- 下一篇: AJAX中日历控件的应用