Home All Groups Group Topic Archive Search About
Author
2 Jul 2006 6:55 AM
Pure Heart
hi guys

im developing a desktop application that conect to a database, and that
database file is in the application development folder, and i made a
dataset
that conect to it but after packaging and installing on client pc the
database path will change so haw can i handle this problem ? i use VS 2005
and the lamguage is VB.NET


Ammar S. Mitoori
IT Head QIMCO Co.
Tel : +9744831199
Mobile : +9745378400
Fax : +9744831643

Author
2 Jul 2006 7:53 AM
Cor Ligthert [MVP]
Pure Heart,

Is it a dontknow database or another, this makes the difference you know?

As you describe it it is Jet but before we are creating a long thread with
misunderstanding.

:-)

Cor

Show quote
"Pure Heart" <PureHe***@discussions.microsoft.com> schreef in bericht
news:22FCD323-F056-4D78-A9D7-7F3DF61BD341@microsoft.com...
> hi guys
>
> im developing a desktop application that conect to a database, and that
> database file is in the application development folder, and i made a
> dataset
> that conect to it but after packaging and installing on client pc the
> database path will change so haw can i handle this problem ? i use VS 2005
> and the lamguage is VB.NET
>
>
> Ammar S. Mitoori
> IT Head QIMCO Co.
> Tel : +9744831199
> Mobile : +9745378400
> Fax : +9744831643
Author
2 Jul 2006 9:55 AM
Pure Heart
hi Core

I use Access 2003 will that be enough or what ?
thanx

--
Ammar S. Mitoori
IT Head QIMCO Co.
Tel : +9744831199
Mobile : +9745378400
Fax : +9744831643


Show quote
"Cor Ligthert [MVP]" wrote:

> Pure Heart,
>
> Is it a dontknow database or another, this makes the difference you know?
>
> As you describe it it is Jet but before we are creating a long thread with
> misunderstanding.
>
> :-)
>
> Cor
>
> "Pure Heart" <PureHe***@discussions.microsoft.com> schreef in bericht
> news:22FCD323-F056-4D78-A9D7-7F3DF61BD341@microsoft.com...
> > hi guys
> >
> > im developing a desktop application that conect to a database, and that
> > database file is in the application development folder, and i made a
> > dataset
> > that conect to it but after packaging and installing on client pc the
> > database path will change so haw can i handle this problem ? i use VS 2005
> > and the lamguage is VB.NET
> >
> >
> > Ammar S. Mitoori
> > IT Head QIMCO Co.
> > Tel : +9744831199
> > Mobile : +9745378400
> > Fax : +9744831643
>
>
>
Author
2 Jul 2006 10:02 AM
Cor Ligthert [MVP]
Ammar,

Than you can probably use

application.StartupPath

http://msdn2.microsoft.com/en-us/library/system.windows.forms.application.startuppath.aspx

(By the way, that is not Access 2003, the database engine of that office
module has the name Jet)

I hope this helps,

Cor

Show quote
"Pure Heart" <PureHe***@discussions.microsoft.com> schreef in bericht
news:81ADCF4D-A012-47DA-ABBA-5B24D1974155@microsoft.com...
> hi Core
>
> I use Access 2003 will that be enough or what ?
> thanx
>
> --
> Ammar S. Mitoori
> IT Head QIMCO Co.
> Tel : +9744831199
> Mobile : +9745378400
> Fax : +9744831643
>
>
> "Cor Ligthert [MVP]" wrote:
>
>> Pure Heart,
>>
>> Is it a dontknow database or another, this makes the difference you know?
>>
>> As you describe it it is Jet but before we are creating a long thread
>> with
>> misunderstanding.
>>
>> :-)
>>
>> Cor
>>
>> "Pure Heart" <PureHe***@discussions.microsoft.com> schreef in bericht
>> news:22FCD323-F056-4D78-A9D7-7F3DF61BD341@microsoft.com...
>> > hi guys
>> >
>> > im developing a desktop application that conect to a database, and that
>> > database file is in the application development folder, and i made a
>> > dataset
>> > that conect to it but after packaging and installing on client pc the
>> > database path will change so haw can i handle this problem ? i use VS
>> > 2005
>> > and the lamguage is VB.NET
>> >
>> >
>> > Ammar S. Mitoori
>> > IT Head QIMCO Co.
>> > Tel : +9744831199
>> > Mobile : +9745378400
>> > Fax : +9744831643
>>
>>
>>
Author
2 Jul 2006 11:00 AM
Pure Heart
hi cor

I know that statment but the point is if i have a dataset already bounded to
a database through a connection, whats the right code or way to rebind it
using the last statment and will that effect the bounded controls or not ?

thank you
--
Ammar S. Mitoori
IT Head QIMCO Co.
Tel : +9744831199
Mobile : +9745378400
Fax : +9744831643


Show quote
"Cor Ligthert [MVP]" wrote:

> Ammar,
>
> Than you can probably use
>
> application.StartupPath
>
> http://msdn2.microsoft.com/en-us/library/system.windows.forms.application.startuppath.aspx
>
> (By the way, that is not Access 2003, the database engine of that office
> module has the name Jet)
>
> I hope this helps,
>
> Cor
>
> "Pure Heart" <PureHe***@discussions.microsoft.com> schreef in bericht
> news:81ADCF4D-A012-47DA-ABBA-5B24D1974155@microsoft.com...
> > hi Core
> >
> > I use Access 2003 will that be enough or what ?
> > thanx
> >
> > --
> > Ammar S. Mitoori
> > IT Head QIMCO Co.
> > Tel : +9744831199
> > Mobile : +9745378400
> > Fax : +9744831643
> >
> >
> > "Cor Ligthert [MVP]" wrote:
> >
> >> Pure Heart,
> >>
> >> Is it a dontknow database or another, this makes the difference you know?
> >>
> >> As you describe it it is Jet but before we are creating a long thread
> >> with
> >> misunderstanding.
> >>
> >> :-)
> >>
> >> Cor
> >>
> >> "Pure Heart" <PureHe***@discussions.microsoft.com> schreef in bericht
> >> news:22FCD323-F056-4D78-A9D7-7F3DF61BD341@microsoft.com...
> >> > hi guys
> >> >
> >> > im developing a desktop application that conect to a database, and that
> >> > database file is in the application development folder, and i made a
> >> > dataset
> >> > that conect to it but after packaging and installing on client pc the
> >> > database path will change so haw can i handle this problem ? i use VS
> >> > 2005
> >> > and the lamguage is VB.NET
> >> >
> >> >
> >> > Ammar S. Mitoori
> >> > IT Head QIMCO Co.
> >> > Tel : +9744831199
> >> > Mobile : +9745378400
> >> > Fax : +9744831643
> >>
> >>
> >>
>
>
>
Author
2 Jul 2006 3:00 PM
Cor Ligthert [MVP]
Pure Heart,

You can set the connection string at any moment in your OleDB
command.connection or in the property from that in the OleDB dataadapter.

I hope this is clear, otherwise reply

Cor

Show quote
"Pure Heart" <PureHe***@discussions.microsoft.com> schreef in bericht
news:5732CE23-2229-4FB0-AD1E-B143DC9D8033@microsoft.com...
> hi cor
>
> I know that statment but the point is if i have a dataset already bounded
> to
> a database through a connection, whats the right code or way to rebind it
> using the last statment and will that effect the bounded controls or not ?
>
> thank you
> --
> Ammar S. Mitoori
> IT Head QIMCO Co.
> Tel : +9744831199
> Mobile : +9745378400
> Fax : +9744831643
>
>
> "Cor Ligthert [MVP]" wrote:
>
>> Ammar,
>>
>> Than you can probably use
>>
>> application.StartupPath
>>
>> http://msdn2.microsoft.com/en-us/library/system.windows.forms.application.startuppath.aspx
>>
>> (By the way, that is not Access 2003, the database engine of that office
>> module has the name Jet)
>>
>> I hope this helps,
>>
>> Cor
>>
>> "Pure Heart" <PureHe***@discussions.microsoft.com> schreef in bericht
>> news:81ADCF4D-A012-47DA-ABBA-5B24D1974155@microsoft.com...
>> > hi Core
>> >
>> > I use Access 2003 will that be enough or what ?
>> > thanx
>> >
>> > --
>> > Ammar S. Mitoori
>> > IT Head QIMCO Co.
>> > Tel : +9744831199
>> > Mobile : +9745378400
>> > Fax : +9744831643
>> >
>> >
>> > "Cor Ligthert [MVP]" wrote:
>> >
>> >> Pure Heart,
>> >>
>> >> Is it a dontknow database or another, this makes the difference you
>> >> know?
>> >>
>> >> As you describe it it is Jet but before we are creating a long thread
>> >> with
>> >> misunderstanding.
>> >>
>> >> :-)
>> >>
>> >> Cor
>> >>
>> >> "Pure Heart" <PureHe***@discussions.microsoft.com> schreef in bericht
>> >> news:22FCD323-F056-4D78-A9D7-7F3DF61BD341@microsoft.com...
>> >> > hi guys
>> >> >
>> >> > im developing a desktop application that conect to a database, and
>> >> > that
>> >> > database file is in the application development folder, and i made a
>> >> > dataset
>> >> > that conect to it but after packaging and installing on client pc
>> >> > the
>> >> > database path will change so haw can i handle this problem ? i use
>> >> > VS
>> >> > 2005
>> >> > and the lamguage is VB.NET
>> >> >
>> >> >
>> >> > Ammar S. Mitoori
>> >> > IT Head QIMCO Co.
>> >> > Tel : +9744831199
>> >> > Mobile : +9745378400
>> >> > Fax : +9744831643
>> >>
>> >>
>> >>
>>
>>
>>
Author
2 Jul 2006 5:10 PM
Pure Heart
hi cor

yes it help but 1 last thing, i chosed not to save the connection inside the
project explorer so the connection is only available in server explorer, i
didnt save it cuz it makes a local copy of the database and this will make a
copy of databse each application run and all updates will be made to that
copy in memory so can i modify connection properties even if i didnt save it ?

--
Ammar S. Mitoori
IT Head QIMCO Co.
Tel : +9744831199
Mobile : +9745378400
Fax : +9744831643


Show quote
"Cor Ligthert [MVP]" wrote:

> Pure Heart,
>
> You can set the connection string at any moment in your OleDB
> command.connection or in the property from that in the OleDB dataadapter.
>
> I hope this is clear, otherwise reply
>
> Cor
>
> "Pure Heart" <PureHe***@discussions.microsoft.com> schreef in bericht
> news:5732CE23-2229-4FB0-AD1E-B143DC9D8033@microsoft.com...
> > hi cor
> >
> > I know that statment but the point is if i have a dataset already bounded
> > to
> > a database through a connection, whats the right code or way to rebind it
> > using the last statment and will that effect the bounded controls or not ?
> >
> > thank you
> > --
> > Ammar S. Mitoori
> > IT Head QIMCO Co.
> > Tel : +9744831199
> > Mobile : +9745378400
> > Fax : +9744831643
> >
> >
> > "Cor Ligthert [MVP]" wrote:
> >
> >> Ammar,
> >>
> >> Than you can probably use
> >>
> >> application.StartupPath
> >>
> >> http://msdn2.microsoft.com/en-us/library/system.windows.forms.application.startuppath.aspx
> >>
> >> (By the way, that is not Access 2003, the database engine of that office
> >> module has the name Jet)
> >>
> >> I hope this helps,
> >>
> >> Cor
> >>
> >> "Pure Heart" <PureHe***@discussions.microsoft.com> schreef in bericht
> >> news:81ADCF4D-A012-47DA-ABBA-5B24D1974155@microsoft.com...
> >> > hi Core
> >> >
> >> > I use Access 2003 will that be enough or what ?
> >> > thanx
> >> >
> >> > --
> >> > Ammar S. Mitoori
> >> > IT Head QIMCO Co.
> >> > Tel : +9744831199
> >> > Mobile : +9745378400
> >> > Fax : +9744831643
> >> >
> >> >
> >> > "Cor Ligthert [MVP]" wrote:
> >> >
> >> >> Pure Heart,
> >> >>
> >> >> Is it a dontknow database or another, this makes the difference you
> >> >> know?
> >> >>
> >> >> As you describe it it is Jet but before we are creating a long thread
> >> >> with
> >> >> misunderstanding.
> >> >>
> >> >> :-)
> >> >>
> >> >> Cor
> >> >>
> >> >> "Pure Heart" <PureHe***@discussions.microsoft.com> schreef in bericht
> >> >> news:22FCD323-F056-4D78-A9D7-7F3DF61BD341@microsoft.com...
> >> >> > hi guys
> >> >> >
> >> >> > im developing a desktop application that conect to a database, and
> >> >> > that
> >> >> > database file is in the application development folder, and i made a
> >> >> > dataset
> >> >> > that conect to it but after packaging and installing on client pc
> >> >> > the
> >> >> > database path will change so haw can i handle this problem ? i use
> >> >> > VS
> >> >> > 2005
> >> >> > and the lamguage is VB.NET
> >> >> >
> >> >> >
> >> >> > Ammar S. Mitoori
> >> >> > IT Head QIMCO Co.
> >> >> > Tel : +9744831199
> >> >> > Mobile : +9745378400
> >> >> > Fax : +9744831643
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>
Author
2 Jul 2006 6:40 PM
Cor Ligthert [MVP]
Ammar,

Do you use a dataadapter, tableadapter or a straight command?

(Than I can show you tomorrow an example, I don't think there is time
anymore)

Cor


Show quote
"Pure Heart" <PureHe***@discussions.microsoft.com> schreef in bericht
news:C6E71C0C-EAD3-4DCB-8ABE-CAD0491B2718@microsoft.com...
> hi cor
>
> yes it help but 1 last thing, i chosed not to save the connection inside
> the
> project explorer so the connection is only available in server explorer, i
> didnt save it cuz it makes a local copy of the database and this will make
> a
> copy of databse each application run and all updates will be made to that
> copy in memory so can i modify connection properties even if i didnt save
> it ?
>
> --
> Ammar S. Mitoori
> IT Head QIMCO Co.
> Tel : +9744831199
> Mobile : +9745378400
> Fax : +9744831643
>
>
> "Cor Ligthert [MVP]" wrote:
>
>> Pure Heart,
>>
>> You can set the connection string at any moment in your OleDB
>> command.connection or in the property from that in the OleDB dataadapter.
>>
>> I hope this is clear, otherwise reply
>>
>> Cor
>>
>> "Pure Heart" <PureHe***@discussions.microsoft.com> schreef in bericht
>> news:5732CE23-2229-4FB0-AD1E-B143DC9D8033@microsoft.com...
>> > hi cor
>> >
>> > I know that statment but the point is if i have a dataset already
>> > bounded
>> > to
>> > a database through a connection, whats the right code or way to rebind
>> > it
>> > using the last statment and will that effect the bounded controls or
>> > not ?
>> >
>> > thank you
>> > --
>> > Ammar S. Mitoori
>> > IT Head QIMCO Co.
>> > Tel : +9744831199
>> > Mobile : +9745378400
>> > Fax : +9744831643
>> >
>> >
>> > "Cor Ligthert [MVP]" wrote:
>> >
>> >> Ammar,
>> >>
>> >> Than you can probably use
>> >>
>> >> application.StartupPath
>> >>
>> >> http://msdn2.microsoft.com/en-us/library/system.windows.forms.application.startuppath.aspx
>> >>
>> >> (By the way, that is not Access 2003, the database engine of that
>> >> office
>> >> module has the name Jet)
>> >>
>> >> I hope this helps,
>> >>
>> >> Cor
>> >>
>> >> "Pure Heart" <PureHe***@discussions.microsoft.com> schreef in bericht
>> >> news:81ADCF4D-A012-47DA-ABBA-5B24D1974155@microsoft.com...
>> >> > hi Core
>> >> >
>> >> > I use Access 2003 will that be enough or what ?
>> >> > thanx
>> >> >
>> >> > --
>> >> > Ammar S. Mitoori
>> >> > IT Head QIMCO Co.
>> >> > Tel : +9744831199
>> >> > Mobile : +9745378400
>> >> > Fax : +9744831643
>> >> >
>> >> >
>> >> > "Cor Ligthert [MVP]" wrote:
>> >> >
>> >> >> Pure Heart,
>> >> >>
>> >> >> Is it a dontknow database or another, this makes the difference you
>> >> >> know?
>> >> >>
>> >> >> As you describe it it is Jet but before we are creating a long
>> >> >> thread
>> >> >> with
>> >> >> misunderstanding.
>> >> >>
>> >> >> :-)
>> >> >>
>> >> >> Cor
>> >> >>
>> >> >> "Pure Heart" <PureHe***@discussions.microsoft.com> schreef in
>> >> >> bericht
>> >> >> news:22FCD323-F056-4D78-A9D7-7F3DF61BD341@microsoft.com...
>> >> >> > hi guys
>> >> >> >
>> >> >> > im developing a desktop application that conect to a database,
>> >> >> > and
>> >> >> > that
>> >> >> > database file is in the application development folder, and i
>> >> >> > made a
>> >> >> > dataset
>> >> >> > that conect to it but after packaging and installing on client pc
>> >> >> > the
>> >> >> > database path will change so haw can i handle this problem ? i
>> >> >> > use
>> >> >> > VS
>> >> >> > 2005
>> >> >> > and the lamguage is VB.NET
>> >> >> >
>> >> >> >
>> >> >> > Ammar S. Mitoori
>> >> >> > IT Head QIMCO Co.
>> >> >> > Tel : +9744831199
>> >> >> > Mobile : +9745378400
>> >> >> > Fax : +9744831643
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>
Author
2 Jul 2006 8:39 PM
Pure Heart
hi cor

i make a dataset from a connection i made it through database server explorer
then i bond the datanavigator to that dataset, conecting to one of its
tables, when i do that it will create for me table1bindingsource and
table1tableadapter which i use them to push updates to database thats all )

thank you cor

--
Ammar S. Mitoori
IT Head QIMCO Co.
Tel : +9744831199
Mobile : +9745378400
Fax : +9744831643


Show quote
"Cor Ligthert [MVP]" wrote:

> Ammar,
>
> Do you use a dataadapter, tableadapter or a straight command?
>
> (Than I can show you tomorrow an example, I don't think there is time
> anymore)
>
> Cor
>
>
> "Pure Heart" <PureHe***@discussions.microsoft.com> schreef in bericht
> news:C6E71C0C-EAD3-4DCB-8ABE-CAD0491B2718@microsoft.com...
> > hi cor
> >
> > yes it help but 1 last thing, i chosed not to save the connection inside
> > the
> > project explorer so the connection is only available in server explorer, i
> > didnt save it cuz it makes a local copy of the database and this will make
> > a
> > copy of databse each application run and all updates will be made to that
> > copy in memory so can i modify connection properties even if i didnt save
> > it ?
> >
> > --
> > Ammar S. Mitoori
> > IT Head QIMCO Co.
> > Tel : +9744831199
> > Mobile : +9745378400
> > Fax : +9744831643
> >
> >
> > "Cor Ligthert [MVP]" wrote:
> >
> >> Pure Heart,
> >>
> >> You can set the connection string at any moment in your OleDB
> >> command.connection or in the property from that in the OleDB dataadapter.
> >>
> >> I hope this is clear, otherwise reply
> >>
> >> Cor
> >>
> >> "Pure Heart" <PureHe***@discussions.microsoft.com> schreef in bericht
> >> news:5732CE23-2229-4FB0-AD1E-B143DC9D8033@microsoft.com...
> >> > hi cor
> >> >
> >> > I know that statment but the point is if i have a dataset already
> >> > bounded
> >> > to
> >> > a database through a connection, whats the right code or way to rebind
> >> > it
> >> > using the last statment and will that effect the bounded controls or
> >> > not ?
> >> >
> >> > thank you
> >> > --
> >> > Ammar S. Mitoori
> >> > IT Head QIMCO Co.
> >> > Tel : +9744831199
> >> > Mobile : +9745378400
> >> > Fax : +9744831643
> >> >
> >> >
> >> > "Cor Ligthert [MVP]" wrote:
> >> >
> >> >> Ammar,
> >> >>
> >> >> Than you can probably use
> >> >>
> >> >> application.StartupPath
> >> >>
> >> >> http://msdn2.microsoft.com/en-us/library/system.windows.forms.application.startuppath.aspx
> >> >>
> >> >> (By the way, that is not Access 2003, the database engine of that
> >> >> office
> >> >> module has the name Jet)
> >> >>
> >> >> I hope this helps,
> >> >>
> >> >> Cor
> >> >>
> >> >> "Pure Heart" <PureHe***@discussions.microsoft.com> schreef in bericht
> >> >> news:81ADCF4D-A012-47DA-ABBA-5B24D1974155@microsoft.com...
> >> >> > hi Core
> >> >> >
> >> >> > I use Access 2003 will that be enough or what ?
> >> >> > thanx
> >> >> >
> >> >> > --
> >> >> > Ammar S. Mitoori
> >> >> > IT Head QIMCO Co.
> >> >> > Tel : +9744831199
> >> >> > Mobile : +9745378400
> >> >> > Fax : +9744831643
> >> >> >
> >> >> >
> >> >> > "Cor Ligthert [MVP]" wrote:
> >> >> >
> >> >> >> Pure Heart,
> >> >> >>
> >> >> >> Is it a dontknow database or another, this makes the difference you
> >> >> >> know?
> >> >> >>
> >> >> >> As you describe it it is Jet but before we are creating a long
> >> >> >> thread
> >> >> >> with
> >> >> >> misunderstanding.
> >> >> >>
> >> >> >> :-)
> >> >> >>
> >> >> >> Cor
> >> >> >>
> >> >> >> "Pure Heart" <PureHe***@discussions.microsoft.com> schreef in
> >> >> >> bericht
> >> >> >> news:22FCD323-F056-4D78-A9D7-7F3DF61BD341@microsoft.com...
> >> >> >> > hi guys
> >> >> >> >
> >> >> >> > im developing a desktop application that conect to a database,
> >> >> >> > and
> >> >> >> > that
> >> >> >> > database file is in the application development folder, and i
> >> >> >> > made a
> >> >> >> > dataset
> >> >> >> > that conect to it but after packaging and installing on client pc
> >> >> >> > the
> >> >> >> > database path will change so haw can i handle this problem ? i
> >> >> >> > use
> >> >> >> > VS
> >> >> >> > 2005
> >> >> >> > and the lamguage is VB.NET
> >> >> >> >
> >> >> >> >
> >> >> >> > Ammar S. Mitoori
> >> >> >> > IT Head QIMCO Co.
> >> >> >> > Tel : +9744831199
> >> >> >> > Mobile : +9745378400
> >> >> >> > Fax : +9744831643
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>
Author
2 Jul 2006 8:51 PM
Cor Ligthert [MVP]
Ammar,

You can get your connection with as sample the Northwind Orders table.

Dim conn As OleDb.SqlConnection = Me.OrdersTableAdapter.Connection
conn.ConnectionString = "blablabla"
That you can than change.

I hope this helps,

Cor



Show quote
"Pure Heart" <PureHe***@discussions.microsoft.com> schreef in bericht
news:08E0A3D1-7B9E-42D4-B41E-48999A612B6B@microsoft.com...
> hi cor
>
> i make a dataset from a connection i made it through database server
> explorer
> then i bond the datanavigator to that dataset, conecting to one of its
> tables, when i do that it will create for me table1bindingsource and
> table1tableadapter which i use them to push updates to database thats
> all )
>
> thank you cor
>
> --
> Ammar S. Mitoori
> IT Head QIMCO Co.
> Tel : +9744831199
> Mobile : +9745378400
> Fax : +9744831643
>
>
> "Cor Ligthert [MVP]" wrote:
>
>> Ammar,
>>
>> Do you use a dataadapter, tableadapter or a straight command?
>>
>> (Than I can show you tomorrow an example, I don't think there is time
>> anymore)
>>
>> Cor
>>
>>
>> "Pure Heart" <PureHe***@discussions.microsoft.com> schreef in bericht
>> news:C6E71C0C-EAD3-4DCB-8ABE-CAD0491B2718@microsoft.com...
>> > hi cor
>> >
>> > yes it help but 1 last thing, i chosed not to save the connection
>> > inside
>> > the
>> > project explorer so the connection is only available in server
>> > explorer, i
>> > didnt save it cuz it makes a local copy of the database and this will
>> > make
>> > a
>> > copy of databse each application run and all updates will be made to
>> > that
>> > copy in memory so can i modify connection properties even if i didnt
>> > save
>> > it ?
>> >
>> > --
>> > Ammar S. Mitoori
>> > IT Head QIMCO Co.
>> > Tel : +9744831199
>> > Mobile : +9745378400
>> > Fax : +9744831643
>> >
>> >
>> > "Cor Ligthert [MVP]" wrote:
>> >
>> >> Pure Heart,
>> >>
>> >> You can set the connection string at any moment in your OleDB
>> >> command.connection or in the property from that in the OleDB
>> >> dataadapter.
>> >>
>> >> I hope this is clear, otherwise reply
>> >>
>> >> Cor
>> >>
>> >> "Pure Heart" <PureHe***@discussions.microsoft.com> schreef in bericht
>> >> news:5732CE23-2229-4FB0-AD1E-B143DC9D8033@microsoft.com...
>> >> > hi cor
>> >> >
>> >> > I know that statment but the point is if i have a dataset already
>> >> > bounded
>> >> > to
>> >> > a database through a connection, whats the right code or way to
>> >> > rebind
>> >> > it
>> >> > using the last statment and will that effect the bounded controls or
>> >> > not ?
>> >> >
>> >> > thank you
>> >> > --
>> >> > Ammar S. Mitoori
>> >> > IT Head QIMCO Co.
>> >> > Tel : +9744831199
>> >> > Mobile : +9745378400
>> >> > Fax : +9744831643
>> >> >
>> >> >
>> >> > "Cor Ligthert [MVP]" wrote:
>> >> >
>> >> >> Ammar,
>> >> >>
>> >> >> Than you can probably use
>> >> >>
>> >> >> application.StartupPath
>> >> >>
>> >> >> http://msdn2.microsoft.com/en-us/library/system.windows.forms.application.startuppath.aspx
>> >> >>
>> >> >> (By the way, that is not Access 2003, the database engine of that
>> >> >> office
>> >> >> module has the name Jet)
>> >> >>
>> >> >> I hope this helps,
>> >> >>
>> >> >> Cor
>> >> >>
>> >> >> "Pure Heart" <PureHe***@discussions.microsoft.com> schreef in
>> >> >> bericht
>> >> >> news:81ADCF4D-A012-47DA-ABBA-5B24D1974155@microsoft.com...
>> >> >> > hi Core
>> >> >> >
>> >> >> > I use Access 2003 will that be enough or what ?
>> >> >> > thanx
>> >> >> >
>> >> >> > --
>> >> >> > Ammar S. Mitoori
>> >> >> > IT Head QIMCO Co.
>> >> >> > Tel : +9744831199
>> >> >> > Mobile : +9745378400
>> >> >> > Fax : +9744831643
>> >> >> >
>> >> >> >
>> >> >> > "Cor Ligthert [MVP]" wrote:
>> >> >> >
>> >> >> >> Pure Heart,
>> >> >> >>
>> >> >> >> Is it a dontknow database or another, this makes the difference
>> >> >> >> you
>> >> >> >> know?
>> >> >> >>
>> >> >> >> As you describe it it is Jet but before we are creating a long
>> >> >> >> thread
>> >> >> >> with
>> >> >> >> misunderstanding.
>> >> >> >>
>> >> >> >> :-)
>> >> >> >>
>> >> >> >> Cor
>> >> >> >>
>> >> >> >> "Pure Heart" <PureHe***@discussions.microsoft.com> schreef in
>> >> >> >> bericht
>> >> >> >> news:22FCD323-F056-4D78-A9D7-7F3DF61BD341@microsoft.com...
>> >> >> >> > hi guys
>> >> >> >> >
>> >> >> >> > im developing a desktop application that conect to a database,
>> >> >> >> > and
>> >> >> >> > that
>> >> >> >> > database file is in the application development folder, and i
>> >> >> >> > made a
>> >> >> >> > dataset
>> >> >> >> > that conect to it but after packaging and installing on client
>> >> >> >> > pc
>> >> >> >> > the
>> >> >> >> > database path will change so haw can i handle this problem ? i
>> >> >> >> > use
>> >> >> >> > VS
>> >> >> >> > 2005
>> >> >> >> > and the lamguage is VB.NET
>> >> >> >> >
>> >> >> >> >
>> >> >> >> > Ammar S. Mitoori
>> >> >> >> > IT Head QIMCO Co.
>> >> >> >> > Tel : +9744831199
>> >> >> >> > Mobile : +9745378400
>> >> >> >> > Fax : +9744831643
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>
Author
5 Jul 2006 4:44 PM
Paul Clement
On Sat, 1 Jul 2006 23:55:01 -0700, Pure Heart <PureHe***@discussions.microsoft.com> wrote:

¤  hi guys
¤
¤  im developing a desktop application that conect to a database, and that
¤  database file is in the application development folder, and i made a
¤  dataset
¤  that conect to it but after packaging and installing on client pc the
¤  database path will change so haw can i handle this problem ? i use VS 2005
¤  and the lamguage is VB.NET
¤

See if the following helps:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=439156&SiteID=1


Paul
~~~~
Microsoft MVP (Visual Basic)

AddThis Social Bookmark Button