当前位置:
首页 >
利用DataSet对Xml文件操作
发布时间:2025/4/16
40
豆豆
生活随笔
收集整理的这篇文章主要介绍了
利用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中日历控件的应用