如何使用vb.net从数据库创建XML文件 [英] how to create an XML file from database using vb.net

问题描述

我想用vb.net

当我试着创建数据库表中的XML文件，我的代码是：



<前浪=xml> <％ @Import Namespace = 系统 ％>
<％ @Import Namespace = < span class =code-string> System.Data ％>
<％ @Import Namespace = System .xml ％>
<％ @Intort Namespace = < span class =code-string> System.Data.SqlClient ％>
<％ @Import Namespace = System.xml.xmlNode ％>
< 脚本 runat = server >
sub page_load
Dim connectionString As String
Dim connection As SqlConnection
Dim adapter As SqlDataAdapter
Dim ds As New DataSet
Dim sql As String

connectionString = ///我的连接字符串////
connection =新的SqlConnection（connectionString）

sql =select * from jb_jobs其中city ='洛杉矶'
connection.Open（）
adapter =新SqlDataAdapter（sql，connection）
adapter.Fill（ds）
connection.Close（）
如果IO.File.Exists（product.xml）= False然后
Dim settings As New XmlWriterSettings（）
settings.Indent = True
Dim XmlWrt As XmlWriter = XmlWriter.Create（c ：/xmlfiles/product.xml，settings）
XmlWrt .WriteStartDocument（）
XmlWrt .WriteComment（XML Database。）
XmlWrt .WriteStartElement（source）
XmlWrt .WriteStartElement（jobs）



XmlWrt .WriteEndElement（）
XmlWrt .WriteEndDocument（）
XmlWrt .Close（）
Response.write（XML File Created）
End if
End Sub

< / script >

和我的输出只是一个用根元素创建的XML文件，但不是用数据库创建的数据

如何解决这个????

解决方案

见..

http://www.c-sharpcorner.com/uploadfile/shivani/generating-xml-from-sql-database-in-vb-net/ [ ^ ]

http://vb.net-informations.com/xml/vb .net-xml-from-sql.htm [ ^ ]

http：// stackoverflow.com/questions/17687364/sqlxml-import-export [ ^ ]

我得到的输出经过长期的奋斗

与代码是：

< br / >

 <％ @Import NameSpace =  < span class =code-string> System.Data ％>  
 < ％ @Import NameSpace =   System.Data.SqlClient ％>  
 <  脚本    runat   = 服务器 >  
 Sub Page_Load 
 Dim connetionString As String 
 Dim connection As SqlConnection 
 Dim adapter As SqlDataAdapter 
 Dim ds As New DataSet 
 Dim sql As String 
 
 connetionString = ///我的连接字符串/// 
 connection =新的SqlConnection（con netionString）
 sql =select * from det where city ='洛杉矶'
尝试
 connection.Open（）
 adapter = New SqlDataAdapter（sql，connection）
 adapter.Fill（ds）
 connection.Close（）
 ds.WriteXml（C：\ xmlfiles\xmldata.xml）
 Console.WriteLine（Done） 
 Catch ex As Exception 
 Console.WriteLine（ex.ToString）
 End Try 
 End Sub 
 <   / script  >  

I want to create XML file from database table using vb.net
As i tried my code is:

<% @Import Namespace="System" %>
<% @Import Namespace="System.Data" %>
<% @Import Namespace="System.xml" %>
<% @Import Namespace="System.Data.SqlClient" %>
<% @Import Namespace="System.xml.xmlNode" %>
<Script runat="server">
sub page_load
        Dim connectionString As String
        Dim connection As SqlConnection
        Dim adapter As SqlDataAdapter
        Dim ds  As New DataSet
        Dim sql As String

        connectionString = ///my connection string////
        connection = New SqlConnection(connectionString)

        sql = "select * from jb_jobs where city='Los Angeles' "
        connection.Open()
            adapter = New SqlDataAdapter(sql, connection)
            adapter.Fill(ds)
            connection.Close()
        If IO.File.Exists("product.xml") = False Then
            Dim settings As New XmlWriterSettings()
            settings.Indent = True
        Dim XmlWrt As XmlWriter = XmlWriter.Create("c:/xmlfiles/product.xml", settings)
        XmlWrt  .WriteStartDocument()
        XmlWrt  .WriteComment("XML Database.")
        XmlWrt  .WriteStartElement("source")
        XmlWrt  .WriteStartElement("jobs")



        XmlWrt  .WriteEndElement()
        XmlWrt  .WriteEndDocument()
        XmlWrt  .Close()
        Response.write("XML File Created")
        End If
        End Sub

</script>

and my output is just a XML file is created with the root elements but not with the data's from database
How to resolve this????

解决方案

See..
http://www.c-sharpcorner.com/uploadfile/shivani/generating-xml-from-sql-database-in-vb-net/[^]
http://vb.net-informations.com/xml/vb.net-xml-from-sql.htm[^]
http://stackoverflow.com/questions/17687364/sqlxml-import-export[^]

I got the output after a long struggle
and the code is:

<% @Import NameSpace="System.Data" %>
<% @Import NameSpace="System.Data.SqlClient" %>
<Script runat="Server">
Sub Page_Load
    Dim connetionString As String
    Dim connection As SqlConnection
    Dim adapter As SqlDataAdapter
    Dim ds As New DataSet
    Dim sql As String

    connetionString = ///my connection string///
    connection = New SqlConnection(connetionString)
    sql = "select * from det where city='Los Angeles' "
    Try
        connection.Open()
        adapter = New SqlDataAdapter(sql, connection)
        adapter.Fill(ds)
        connection.Close()
        ds.WriteXml("C:\xmlfiles\xmldata.xml")
        Console.WriteLine("Done")
    Catch ex As Exception
        Console.WriteLine(ex.ToString)
    End Try
    End Sub
</script>

这篇关于如何使用vb.net从数据库创建XML文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！