OpenFileDialog & DataSets

[ng_pearce]

I have a problem with using the OpenFileDialog object and datasets. Whenever I use the OpenFileDialog when the application is in run mode, it will change the current working directory of all datasets in use. So if I use a relative path when reading an XML file into the dataset, that path will change to the last folder browsed using the OpenFileDialog. This will cause an error when I go to use dataset.WriteXml() because the path has changed. Can someone please tell me a work around for this problem?

[mendhak]

First off, I find it very strange that the CommonDialog would have an effect on a dataset. Can you post some code so that I can try it out here?

Second, the .WriteXML() method can take a filename argument which can contain the path, so that you can specify where to write it.

[pax]

Hi.

This is probably because the dialog changes the current directory in windows, thus all relative paths are changed.

There's a property on the dialog called "RestoreDirectory".
If I understand correctly, setting this property to TRUE would cause the dialog to change the directory back when closing.

I hope this is what you need.

[ng_pearce]

Hi, thanks for the help but it is still causing the same error even when using RestoreDirectory = True

[pax]

Hmmm, strange...

Well instead of using relative paths maybe you should use absolute.

Like this

MyAbsolutePath=IO.Path.Combine(Application.StartupPath,MyRelativePath)

[ng_pearce]

Yes that method works, thanks for your help. I still cannot understand why the error occurs in the first place though!