XML import/export for ADO

From: "Eugene V. Goldberg" <egold@xxxxxxxxx>
Date: Mon, 25 Feb 2008 21:47:13 +0300

Hi there folks,

I have a need to export the number of table records into single XML
document,
transfer it over the wireless network and import on the other side.

The XML document will contain a master record and a number of detail
records,
from various detail tables.

What would be the best approach for XML import/export?

The ADO datasource is MS SQL.

Thanx alot,
Eugene.

.

Follow-Ups:
- Re: XML import/export for ADO
  - From: Eugene V. Goldberg

Prev by Date: Re: OLE DB Provider not found for SQL Compact edition even after installing
Next by Date: Used a reserved word in a field name.....
Previous by thread: How to test for empty Excel cell in SELECT ... WHERE
Next by thread: Re: XML import/export for ADO
Index(es):
- Date
- Thread

Relevant Pages

Re: Index xml in variable
... documentation, I saw you could index XML. ... great if you had a big single XML value that you were working on. ... have a 2.4mb XML value now, and yeah, it's running slow, several ...
(microsoft.public.sqlserver.xml)
Re: Return different row sets using for xml?
... queries return the data to BizTalk as a single XML document. ... customers for xml explicit; ...
(microsoft.public.sqlserver.xml)
RE: Multiple DataSets in one XML file
... Unless you're taking some special care of XML structure, ... it's up to you to find the right data set start and invoke ReadXml ... Multiple DataSets in one XML file ... > It's very easy to DataSet.WriteXmlmultiple dataset to a single xml ...
(microsoft.public.dotnet.framework.compactframework)
Index xml in variable
... When I first read over the SQLServer XML ... you had a big single XML value that you were working on. ... value now, and yeah, it's running slow, several minutes to do a cross apply ... Basically I'm shredding the XML into tables, joining the top level elements ...
(microsoft.public.sqlserver.xml)