SQL on XML

  • Thread starter Thread starter copyco
  • Start date Start date
C

copyco

I have an application where it's data comes from an XML database, so it
reads it into a dataset with the .ReadXML method. The dataset is
displayed in a couple of datagrids which are connected to the dataset
via dataviews. Changes to the data are saved with the .WriteXML method
on the dataset. I would like to be able to perform sql statements on
the data such as "DELETE FROM ... WHERE ...", etc. is it even possible
and if so, how? All examples i can find of SQL commands are for when
you are connecting to a SQL server or some stuff like that.

Thanks.
 
Copyco,

The XML dataset on disk is not a database and therefore not accessable with
SQL commands. A XML dataset is just a file, that can be saved and
transported for which is very much usable, however no database.

And therefore you can not access it using SQL statements. (The first thing
you would need for that is a connectionstring, and I never saw that).

I hope this helps anyway?

Cor
 
Thanks, I'll see about using a filter on the data instead. Sorry about
the other message Cor. I didn't intend to send it to you directly.


Cor said:
Copyco,

The XML dataset on disk is not a database and therefore not accessable with
SQL commands. A XML dataset is just a file, that can be saved and
transported for which is very much usable, however no database.

And therefore you can not access it using SQL statements. (The first thing
you would need for that is a connectionstring, and I never saw that).

I hope this helps anyway?

Cor
Click to expand...
 
Back
Top