Redfine the database location

Nice to meet u all
i'm facing the problem of data table. I want to redfine the database location. It means i want to select database each time from application directory.

How can we re-define the location of database in it while loading specific form.

I'm not 100% sure what you're asking. Maybe this will point you in the right direction:

Use an OpenFileDialog object called in Form_Load()... something like...

Code:

---

string dbPath;

public void Form_Load()
{
    //Prompt the user to select the database to open in this form
    OpenFileDialog ofd = new OpenFileDialog();
    DialogResult dr = ofd.ShowDialog();

    if( dr != DialogResult.OK )
        //Kill the form
        this.Unload();  //I think

    //Otherwise read the path to the database
    dbPath = ofd.FileName;

    //Do some validation here
}

---

If, instead, you're asking how to pass in an argument to a newly created form: I have forgotten the design pattern to do that (I don't do a lot of forms programming), but I'm sure someone else here can tell you. It's simple, at any rate. You can probably google for it.

If, instead, you want to open it based on the application directory path, see my reply to your other recent post.

Hope that helps?

i want to get the directory location of current program. How can i get it.

This might help:

http://www.csharp-examples.net/get-a...ion-directory/

A good way, IMHO, is to store the Database location in your App.Config file, like this :

http://www.ezzylearning.com/tutorial.aspx?tid=8067328

This ensures that when the app starts up, it already knows where the DB is.

thank you dear friend
It's good way...