Howdy,

What is the best way to take a populated TypedView class and serialize it to XML?

The following works fine if you've got a typed DataSet which matches the view:

        Dim objDS As New Inventory_TieredPricing
        For Each objRow As DataRow In objV.Rows
            objDS.Inventory_TieredPrice.ImportRow(objRow)
        Next
        objDoc.InnerXml = objDS.GetXml()
        Return objDoc

However, I'd much rather have code like this:

  objDoc.InnerXML = objV.ToXml()

That ToXml() method would simply take what was in the typed view and turn it into an XML structure like:

<ViewName> <Column1>value</Column1> <Column2>value</Column2> etc </ViewName>

I can do this with programming pretty easily, but I waiting to see if it already existing before I did it.

Thanks for any help,

Matt

A typed view is a datatable, so the easy way out is to add it to a dataset and then use the dataset's WriteXml() routine to get the xml

Otis wrote:

A typed view is a datatable, so the easy way out is to add it to a dataset and then use the dataset's WriteXml() routine to get the xml

I did not notice this until you mentioned it. Sure enough this works well. Thanks!

    Dim oNotes As New VwCallsTypedView()
    Dim adapter As New DataAccessAdapter()

    Dim sNotesXML As String = String.Empty
    Try

        adapter.FetchTypedView(oNotes.GetFieldsInfo(), oNotes)
        oNotes.WriteXml(System.AppDomain.CurrentDomain.BaseDirectory() & "xml.xml")

.....

Why does the output include crlf characters...this causes issues with readxml.

Writexml on an entity does not produce this issue..hope someone can help.

Anthony

Do you get the same issue serializing a simple DataTable?