Please don't cross-post to multiple groups.
You would likely need to issue multiple Update commands against each
DataTable, specifying the correct InsertCommand, UpdateCommand, and
DeleteCommand for each DataTable. Issue an update for the Items table
separately from the Update for the other table(s).
--
Kirk Allen Evans
www.xmlandasp.net
Read my web log at
http://weblogs.asp.net/kaevans
"PA" <pr*******@jvc.co.uk> wrote in message
news:f7**************************@posting.google.c om...
I am using .NET web aplication and MSDE 2000. I receive new record in
XML format which I want to add into MSDE 2000. I am doing it as below.
Private Sub InsertNew(ByVal sData1 As String)
Dim SR1 As System.IO.StringReader = New
System.IO.StringReader(sData1)
DS1.ReadXml(SR1)
SqlDataAdapter1.Update(DS1)
End Sub
This works fine with one table.
But say, I receive following XML data:
<ORDER>
<COMPANY>DIXON</COMPANY>
.
.
.
<ITEMS>
<ITEM>
<NAME>SONY - 32 inch</NAME>
<QTY>2</QTY>
</ITEM>
<ITEM>
<NAME>PHILIPS - 32 inch</NAME>
<QTY>1</QTY>
</ITEM>
</ITEMS>
.
.
.
</ORDER>
I want to add a new record(s) in Items table for above items and
remaining data as a new record in some other table. How can I do this?
Thanks.