Professionally help needed bout Deployment

[talentedbro]

I finished my program and tried to make a setup application for it. I deployed the program and installed without any problem but it didnt work because of the database problem!

I used OleDbDataAdapter wizard to setup the connection and again generated the dataset from oledbdataadapter. I only wrote a simple code to fill the datagrid of my program with the table in my microsoft access database file. I think, I need to write some proper codes to setup a connection instead of using VB sh..t wizard. because when I try to run the program, it still tries to get the table from my C:\VisualBasic Projects\mypro\bin\db2.mdb and I want the program to be run on another computers directly. which codes do I need for this database connection and make my program a self executable file so my lovely supervisor can be able to run and test my program on his computer??

Professionally help needed!!

[The_Duck]

What you need to do is put your connection string into an App.Config file!

To do this simply load the properties panel for one of your connection objects. Click on Dynamic Properties then dynamically set your connection string!

When deploying your project you need only edit your conenction string with the correct database location!

[mfghazi]

That's correct, but how one can do so?

What is the exact procedure to add a connection string to a web.config/app.config file during the installation?