Reading XMLString into Typed Dataset

[DazlerD]

Hi

My program needs to insert records into a strongly typed dataset. The records are passed as a String.

So far I have:

    Private Sub InsertIntoCustomersTable(ByVal XMLString As String)
 
         Dim sr As New System.IO.StringReader(XMLString) 
 
        '  Read in the XMLString to populate the table
        Mssqlds.Customer.ReadXml(sr)
 
        '  Update db
        Me.CustomerTableAdapter.Update(Mssqlds.Customer)
 
    End Sub

This doesnt error but no rows are added to my Customer datatable. The columns are added but no data.

If I use an untyped dataset:

    Private Sub InsertIntoCustomersTable(ByVal XMLString As String)
 
        Dim ds As New DataSet              
        Dim da As New MySqlDataAdapter
        Dim sr As New System.IO.StringReader(XMLString)
 
        ' Set the data adapter statements
        getCustomerDataset(ds, da)
 
        ds.ReadXml(sr, XmlReadMode.IgnoreSchema)
 
    End Sub

This loads the records into new rows of the Customer datatable.

How do I load XML stored as a string into a typed dataset datatable so I can call .update?

Thanks

Darren

[DazlerD]

My XML that is contained in the XMLString variable looks like:

<?xml version="1.0" encoding="UTF-8"?>
<Customers>
    <Customer>
        <customer_id>2931</customer_id>
        <email>[e-mail]</email>        <password>ab8a754d78af898c0816282a0c34d53c</password>
        <title>Mr</title>
        <firstName>Darren</firstName>
        <lastName>Rhymer</lastName>
        <add_1>35 High Street</add_1>
        <add_2/>
        <town>Trowbridge</town>
        <county>Wiltshire</county>
        <zoneId>367</zoneId>
        <postcode>BA14 5RTpostcode>
        <country>225</country>
        <phone>01234 555666</phone>
        <mobile/>
        <regTime>1175250521</regTime>
        <ipAddress>88.23.23.121</ipAddress>
        <noOrders>1</noOrders>
        <optIn1st>0</optIn1st>
        <htmlEmail>1</htmlEmail>
        <type>1</type>
    </Customer>
</Customers>