By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,234 Members | 1,908 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,234 IT Pros & Developers. It's quick & easy.

SQL on XML

P: n/a
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."
Nov 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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."

Nov 21 '05 #2

P: n/a
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."
Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.