OpenFileDialog & DataSets

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?

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.

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.

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

Hmmm, strange...:ehh:

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

Like this

VB Code:

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

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