Open File Dialog and Database Location Problem
I have come across a problem which I'm unable to solve.
I'm creating a VB.Net application using Visual Studio 2005. On one of my forms, I've save a new record/row to my database. On this form, it also has a Open File Dialog component, which opens a picture, so that I can save the picture to the database. The problem occurs whenever I use the Open File Dialog, and open a picture, it comes up with the error saying it can't find my database. It shows me the path is it looking for it, and its the wrong path.
But when I don't use the Open File Dialog, it works perfectly fine. It saves the new record/row to the database. Its whenever I open a file using the Open File Dialog that it doesn't work.
If I hit the cancel button on the Open File Dialog it will still work, its whenever I open a file that it comes up with the error of not finding my database, as it is looking in the wrong directory.
I tried this in a new project and the same thing happens. It seems that whenever I open a file using the Open File Dialog, it is changing the path of where my database is, to the path of where the file I've just opened.
I have no idea why this is happening, please help me.
Here is my code for my database connection:
'Connection to the Access database
Public Const strConnection As String = _
Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=./myDatabase.mdb;Persist Security Info=False"
and here is my code for my Open File Dialog:
OpenFileDialog.Filter = "Image files (.jpg, .jpeg, .bmp, .gif)|*.jpg;*.jpeg;*.bmp;*.gif"
If (OpenFileDialog.ShowDialog() = Windows.Forms.DialogResult.OK) Then
imageFileName = OpenFileDialog.FileName
txtImage.Text = imageFileName
Thanks very much, any help much appreciated.
You might try setting the OpenFileDialog's .RestoreDirectory property to True. A better solution, in my opinion, is to specify the full path to your database in your connection string. That is, instead of "Data Source = .\myDatabase.mdb", use "Data Source = d:\path\myDatabase.mdb".
Please post questions to the forums, where others may benefit.
I do not offer free assistance by e-mail. Thank you!
Thanks very much for your help and quick reponse.
Yeh, I have now solved the problem. It seems that the OpenFileDialog was overridding my current path. So I have changed my path to the database as:
But I'm sure you way would work as well.
Again thanks very much,
By zali in forum VB Classic
Last Post: 03-06-2006, 04:15 AM
By Chicho in forum VB Classic
Last Post: 10-01-2003, 12:00 AM
By Kevin in forum ASP.NET
Last Post: 12-20-2002, 10:54 AM
By Brian Higgins in forum VB Classic
Last Post: 11-26-2001, 11:19 PM
By Jorge Biquez in forum VB Classic
Last Post: 04-27-2001, 09:33 PM
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center