By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,890 Members | 1,115 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,890 IT Pros & Developers. It's quick & easy.

Database filepath got overrided by OpenFiledialog???

P: n/a
Jon
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()
Nov 21 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
--------------------
"Jon" <Jo*@discussions.microsoft.com> wrote in message
news:34**********************************@microsof t.com...
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()
Nov 21 '05 #2

P: n/a
Who's got eagle eyes today then? :)
"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:e$****************@TK2MSFTNGP10.phx.gbl...
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
--------------------
"Jon" <Jo*@discussions.microsoft.com> wrote in message
news:34**********************************@microsof t.com...
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()

Nov 21 '05 #3

P: n/a
myFileDialog.RestoreDirectory = True

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

"Jon" <Jo*@discussions.microsoft.com> wrote in message
news:34**********************************@microsof t.com...
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()

Nov 21 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.