[RESOLVED] OpenFileDialog messes up Database

[Shadow45o]

First off, I'm fairly new to databases. I have a basic one that adds simple text...

The problem I am running into is the OpenFileDialog box. I am allowing the user to pick an image and I want to save the image location into a column in the database(this isn't the problem), I know how to get the image location and save it...The main problem is this. Each time I open up the "OpenFileDialog box" and choose an image, it remembers the last location used, but after the image is chosen, the program looks at the images location as the spot the database is...

To sum this up: Each time I use the "OpenFileDialog" and choose an image, the program looks at the images location for the database instead of in the "Debug folder" (which is were I put the database) So i end up getting an error that it can't find the database. Everything usually worked fine until I used the "OpenFileDialog"...

thanks for any help

[mickey_pt]

How do you define the connection string?

[jmcilhinney]

Set the RestoreDirectory property of the OpenFileDialog to True or else specify the location for your database in such a way that doesn't rely on the current directory. That said, even if you do take the first option you should be taking the second anyway. How are you specifying the location of the database at the moment?

[Shadow45o]

here is the connection string...

variables:

Dim ds As New DataSet()
Dim intCurrentIndex As Integer = 0
Dim da As New OleDbDataAdapter()
Dim conn As New OleDbConnection()
Dim intNum As Integer

connection:

conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = UserData.mdb;User Id=admin;Password=;"

[jmcilhinney]

The fact that you're specifying only the database file name and not the path means that the path is assumed to be the application's current directory. When you app starts up its current directory will be the folder containing the EXE by default. When you display an OpenFileDialog, the current directory of the app follows wherever the user navigates. When they close the dialogue, the current directory is restored to its original location IF RestoreDirectory is True. In your case it's not so the current directory remains the folder containing the file that was opened.

As I said before, you might want to set RestoreDirectory to True but, even if you do, you should still change your connection string. You should NEVER rely on the current directory unless you specifically want to follow the current directory even if it changes. If you want the folder containing the EXE then you should specify that folder. Your connection string should be:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source = |DataDirectory|\UserData.mdb;User Id=admin;Password=;

The |DataDirectory| will resolve to the correct location whether you're debugging or you've deployed.