PC Review


Reply
Thread Tools Rate Thread

adding records to multiple tables in MSDE 2000 from XML using ADO.NET

 
 
PA
Guest
Posts: n/a
 
      18th Jul 2003
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>
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding records to multiple tables hazel4832 Microsoft Access VBA Modules 3 28th Jul 2009 07:30 PM
Adding New records in multiple tables Leo Microsoft Access Queries 2 27th Jun 2009 04:36 AM
Adding new records to multiple tables. Nad Microsoft Access 4 24th May 2009 12:15 AM
Adding Records to multiple tables Scott Microsoft Access Database Table Design 5 20th May 2008 04:35 PM
Adding records to multiple tables =?Utf-8?B?TGVzbGll?= Microsoft Access VBA Modules 1 13th Feb 2007 04:46 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:15 AM.