[vb.net] DataTable 내용을 XML로 저장 및 불러오기

Example 1:)

 

    Write:

        dt1.TableName = "MyDataTable"

        dt1.WriteXmlSchema(Application.StartupPath + "\test_sh.xml", True)

        dt1.WriteXml(Application.StartupPath + "\test_dt.xml", True)

 

    Read:

        dt2 = New DataTable

        dt2.ReadXmlSchema(Application.StartupPath + "\test_sh.xml")

        dt2.ReadXml(Application.StartupPath + "\test_dt.xml")

 

 

Example 2:)

 

    Write:

        Dim writer As System.IO.StringWriter = New System.IO.StringWriter()

        customerTable.WriteXml(writer, XmlWriteMode.WriteSchema, False)

 

    Write:

        writer = New System.IO.StringWriter()

        customerTable.WriteXml(writer, XmlWriteMode.WriteSchema, True)

 

 

Example 3:)

 

    Write:

        Dim xmlStream As System.IO.MemoryStream = New System.IO.MemoryStream()

        table.WriteXml(xmlStream, XmlWriteMode.WriteSchema)

        xmlStream.Position = 0

 

    Read:

        Dim newTable As DataTable = New DataTable()

        newTable.ReadXml(xmlStream)

 

 

Example 4:)

 

    Write:

        Dim fileName As String = "C:\TestData.xml"

        table.WriteXml(fileName, XmlWriteMode.WriteSchema)

 

    Read:

        Dim newTable As DataTable = New DataTable()

        newTable.ReadXml(fileName)

 

Visual Basic 프로그래밍 기초:프로그래밍 경험이 전혀 없는 초보자를 위한 가이드 북, 교학사 19,800원 (포스팅일기준)

Professional Visual Basic 6 XML 정보문화사 24,300원 (포스팅일기준)

Visual Basic이 보이는 그림책, 성안당 14,400원 (포스팅일기준)