Re: Is there an XMLDataAdapter?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Gus,

An XML file is just not a database.

There is a difference between a XML file as les say a document (with
attributes etc), (As Bill stated to get with a loadxml) and a XML file wich
is a dataset, what you can get with a readXML.

However both are just files noting more. Because there are tons of methods
to internally access a dataset, you can use that as well to get the data and
to select of whatever way you want to get a subset.

The pain comes with updating. It is just a file and therefore can you only
write a complete XML file back. This means that it is almost (in fact is)
unusable for multiuser purpose.

(And as well of course very slow, the action will be forever)

Reading a complete file
Renaming the file
Writing the complete file
Deleting the old file when every thing was OK

I hope this gives an idea

Cor

"Gus Gustafson" <GusGustafson@xxxxxxxxxxxxxxxxxxxxxxxxx> schreef in bericht
news:4C4555BB-E4CE-426D-92A1-0A84880EAAA8@xxxxxxxxxxxxxxxx
>I have two, dynamic XML files that contain data. My customer insists on
>using
> XML for a number of quite valid reasons. Being new (read naive) to XML, I
> thought there might be some form of SELECT statement that could be used
> with
> XML files. A number of books have referred me to the .NET SDK. However, I
> can't seem to find what I need.
>
> Is there a data adapter for XML? If so, where might it be documented? If
> not, must I program my own queries against the contents of various dataset
> tables (read by <data-set>.ReadXML)? I must stay within the Microsoft
> provided .NET framework and not purchase software from another vender. I
> also
> must assume that the user will have neither SQL nor Access available.
>
> TIA,
>
> Gus
>


.