Database filepath got overrided by OpenFiledialog???

[Guest]

Hi,

I am scratching all my hair out and really have no idea what is happening
with my program...

I have a dataset, and i used dataAdapter to fill the data. Everything works
fine until I run the OpenFileDialog, and select a txt file ( the file i
select has nothing do with the database).

When i try to update my dataset, It gives out
"System.Data.OleDb.OleDbException" because it is trying to find
MyDataBase.mdb where the path is the one i selected in the openFileDialoge!?!?

but the weird thing is my path for the oledb is constant, and more
importantly i dont see any connection between the two..

What should I do so that the openFiledialog won't affect the path of my
Database??

but still anyway, i can't see anything wrong in my code that my DB path will
get affected by the change of a openfiledialog...?

please if anyone can help.
Thank you very much in advance!

' Here is how i create the oledb connection
' Create OLEDB connection

Const m_OLEDB_PATH As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source= Data\MyDataBase.mdb"

Dim OleDbConn As New OleDbConnection(m_OLEDB_PATH)
m_da = New OleDbDataAdapter
m_da.SelectCommand = New OleDbCommand(m_str, OleDbConn)
Dim cmd As New OleDbCommandBuilder(m_da)

OleDbConn.Open()

' Fill DataTable in DataSet via DataAdapter
m_da.Fill(m_ds, m_tbName)
m_ds.CaseSensitive = True

OleDbConn.Close()

 

[Ken Tucker [MVP]]

Hi,

You are not using a hard coded path. The connection is looking for
a database at the current directory\data\mydatabase.mdb. When you run the
open file dialog you change the current directory.

Ken
--------------------
Hi,

I am scratching all my hair out and really have no idea what is happening
with my program...

I have a dataset, and i used dataAdapter to fill the data. Everything works
fine until I run the OpenFileDialog, and select a txt file ( the file i
select has nothing do with the database).

When i try to update my dataset, It gives out
"System.Data.OleDb.OleDbException" because it is trying to find
MyDataBase.mdb where the path is the one i selected in the
openFileDialoge!?!?

but the weird thing is my path for the oledb is constant, and more
importantly i dont see any connection between the two..

What should I do so that the openFiledialog won't affect the path of my
Database??

but still anyway, i can't see anything wrong in my code that my DB path will
get affected by the change of a openfiledialog...?

please if anyone can help.
Thank you very much in advance!

' Here is how i create the oledb connection
' Create OLEDB connection

Const m_OLEDB_PATH As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source= Data\MyDataBase.mdb"

Dim OleDbConn As New OleDbConnection(m_OLEDB_PATH)
m_da = New OleDbDataAdapter
m_da.SelectCommand = New OleDbCommand(m_str, OleDbConn)
Dim cmd As New OleDbCommandBuilder(m_da)

OleDbConn.Open()

' Fill DataTable in DataSet via DataAdapter
m_da.Fill(m_ds, m_tbName)
m_ds.CaseSensitive = True

OleDbConn.Close()

 

[Stephany Young]

Who's got eagle eyes today then?

 

[Michael C#]

myFileDialog.RestoreDirectory = True

Will keep OpenFileDialog from changing the Current Directory for your app.