Exclusively open/modify an XML file?

Question

I need to open an XML file exclusively, make a modification, and save it. I can open it and make the modification pretty easily like so: ``` DataSet ds = new DataSet(); ds.ReadXml(filename); DataTable table = ds.Tables[0]; DataRow[] rows = table.Select("Inventory== 1"); DataRow row = rows[0]; row["Inventory"] = "2"; ds.WriteXml(filename); ``` That all works great, but it doesn't lock the file. I absolutely need the file locked. So I tried it with a stream: ``` FileStream stream = File.Open(filename, FileMode.Open, FileAccess.ReadWrite, FileShare.None); DataSet ds = new DataSet(); ds.ReadXml(stream); DataTable table = ds.Tables[0]; DataRow[] rows = table.Select("Inventory== 1"); DataRow row = rows[0]; row["Inventory"] = "2"; ds.WriteXml(stream); stream.Close(); ``` That opens the file exclusively, but when it saves, it appends the XML to the end of the time, it doesn't overwrite it, so I end up with something like: ```

Accepted Answer

In your stream, you need to reset the stream's head to the beginning of the file AND erase existing content to overwrite existing data in case your replacement text is shorter than the original content. Try placing this before ds.writeXml:

```
stream.Seek(0, SeekOrigin.Begin);
stream.SetLength(0);
```

The first line moves the head, the second truncates the file so if what you are replacing the text with is shorter than the original text, you will not have extraneous characters at the end.

Note that, as Reed Copsey points out, it might be better to do the write first, then set the length to the stream's Position member, as this will have no effect in the event that the replacing text is the same length or longer than the text replaced, which might be marginally more efficient.

Exclusively open/modify an XML file?

Solution

Problem