filestream write appends even with filemode.create

[Jeremy]

I have a procedure that writes an xml file to disk. When I click my button
and run it once, it replaces the xml file on disk as it should. If I click
the button a 2nd time, it appends. If I leave the app & click the button,
the file is replaced.

I've tried closing and flushing, but no joy. Dispose is not an available
method. Any thoughts?

Here is a snippet (ds is a dataset):

Dim tw As New System.IO.FileStream("filedrive:\path\name.xml",
IO.FileMode.Create)
Dim xw As New XmlTextWriter(tw, System.Text.Encoding.UTF8)
ds.WriteXml(xw, XmlWriteMode.WriteSchema)
xw.close()

Jeremy

[Bernie Yaeger]

Hi Jeremy,

Set xw to nothing after close:
xw = Nothing

HTH,

Bernie Yaeger

"Jeremy" <je****@ninprodata.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

I have a procedure that writes an xml file to disk. When I click my button and run it once, it replaces the xml file on disk as it should. If I click the button a 2nd time, it appends. If I leave the app & click the button,
the file is replaced.

I've tried closing and flushing, but no joy. Dispose is not an available
method. Any thoughts?

Here is a snippet (ds is a dataset):

Dim tw As New System.IO.FileStream("filedrive:\path\name.xml",
IO.FileMode.Create)
Dim xw As New XmlTextWriter(tw, System.Text.Encoding.UTF8)
ds.WriteXml(xw, XmlWriteMode.WriteSchema)
xw.close()

Jeremy

[Cor]

Hi Jeremy,

Do you know that this is enough to write a dataset and schema to disk?

ds.WriteXml("filedrive:\path\name.xml", XmlWriteMode.WriteSchema)

Cor

[Herfried K. Wagner [MVP]]

* "Cor" <no*@non.com> scripsit:

Do you know that this is enough to write a dataset and schema to disk?

ds.WriteXml("filedrive:\path\name.xml", XmlWriteMode.WriteSchema)

Do you always have a dataset?

--
Herfried K. Wagner [MVP]
<http://dotnet.mvps.org/>
Website Address Changed!

[Cor]

Herfried,

Can you explain the question something more?

Do you always have a dataset?

Cor

[Herfried K. Wagner [MVP]]

Cor,

* "Cor" <no*@non.com> scripsit:

Can you explain the question something more?

Oh, I feel sorry, I missed the 'ds' in the OP's post. I'll clean my
glasses now.

--
Herfried K. Wagner [MVP]
<http://dotnet.mvps.org/>

[j g]

Cor, no, I didn't know that. The dox led me to believe that the syntax
you suggest would only write the schema. Sure is simpler.

Jeremy

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Jeremy]

Bernie, turns out that I was not clearing my source dataset, so when I
re-filled it and looped through it again to write my output ds, the
source had duplicate records. The writexml code was working correctly
all along.

Jeremy

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!