Autoincrement in XML files

[John]

Hi All, I have an xml file which is constrained to a schema

Part of the schema shown below:

<xs:element name="ID" type="xs:int" msdata:AutoIncrement="true"
msdata:AutoIncrementSeed="1" />
<xs:element name="PersonName" type="xs:string" />

What I do is create a new datarow in the DataSet (The dataset is contains a
single datatable read from the XML file) and then using the DataSet.WriteXML
method I write the data back to the original XML file.
Everything works fine except that the ID element is not written to the XML
file and is certainly not incremented.
I have googled and come across various methods that involve creating a new
Datatable but this seems a bit extreme as there is already a datatable in
the dataset. The dataset contains information retrieved from an XML table
which in turn is based on an XML schema (See above).

I am probably just missing something somewhere in the process but cannot
figure out what

Any help appreciated
Regards
John

[Cor Ligthert]

John,

Did you make from ID a primairy key.

http://msdn.microsoft.com/library/de...ryKeyTopic.asp

By the way, you cannot write your databack doing writeXML you just overwrite
it. Therefore it is better to make a tempory file before you do that from
the old one and delete that when the operation is for sure correct
completed.

I hope this helps?

Cor

"John" <do**@spam.me>

Hi All, I have an xml file which is constrained to a schema

Part of the schema shown below:

<xs:element name="ID" type="xs:int" msdata:AutoIncrement="true"
msdata:AutoIncrementSeed="1" />
<xs:element name="PersonName" type="xs:string" />

What I do is create a new datarow in the DataSet (The dataset is contains
a
single datatable read from the XML file) and then using the
DataSet.WriteXML
method I write the data back to the original XML file.
Everything works fine except that the ID element is not written to the XML
file and is certainly not incremented.
I have googled and come across various methods that involve creating a new
Datatable but this seems a bit extreme as there is already a datatable in
the dataset. The dataset contains information retrieved from an XML table
which in turn is based on an XML schema (See above).

I am probably just missing something somewhere in the process but cannot
figure out what

Any help appreciated
Regards
John

[John]

Thanks Cor, I will take a look
Regards
John
"Cor Ligthert" <no************@planet.nl> wrote in message
news:uu**************@TK2MSFTNGP09.phx.gbl...

John,

Did you make from ID a primairy key.

http://msdn.microsoft.com/library/de...ryKeyTopic.asp
By the way, you cannot write your databack doing writeXML you just overwrite it. Therefore it is better to make a tempory file before you do that from
the old one and delete that when the operation is for sure correct
completed.

I hope this helps?

Cor

"John" <do**@spam.me>

Hi All, I have an xml file which is constrained to a schema

Part of the schema shown below:

<xs:element name="ID" type="xs:int" msdata:AutoIncrement="true"
msdata:AutoIncrementSeed="1" />
<xs:element name="PersonName" type="xs:string" />

What I do is create a new datarow in the DataSet (The dataset is contains a
single datatable read from the XML file) and then using the
DataSet.WriteXML
method I write the data back to the original XML file.
Everything works fine except that the ID element is not written to the XML file and is certainly not incremented.
I have googled and come across various methods that involve creating a new Datatable but this seems a bit extreme as there is already a datatable in the dataset. The dataset contains information retrieved from an XML table which in turn is based on an XML schema (See above).

I am probably just missing something somewhere in the process but cannot
figure out what

Any help appreciated
Regards
John