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()

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" <(E-Mail Removed)> wrote in message
news:345F31B1-12A7-4B60-999E-(E-Mail Removed)...
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()

Who's got eagle eyes today then?


"Ken Tucker [MVP]" <(E-Mail Removed)> wrote in message
news:e$Zpjn%(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:345F31B1-12A7-4B60-999E-(E-Mail Removed)...
> 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()
>
>

myFileDialog.RestoreDirectory = True

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

"Jon" <(E-Mail Removed)> wrote in message
news:345F31B1-12A7-4B60-999E-(E-Mail Removed)...
> 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()