SQL on XML

[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.

--

Confucious say: "He who stands on toilet is high on pot."

[Cor Ligthert]

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

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.

--

Confucious say: "He who stands on toilet is high on pot."

[copyco]

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 Ligthert wrote:

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

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.

--

Confucious say: "He who stands on toilet is high on pot."

--

Confucious say: "He who stands on toilet is high on pot."