i am working on a application. i am using sqlserver database file. while giving database path. i have given the absolute path. in case i move my application to other PC i need to change the database path again. to overcome this problem. i have choose relative path for databse like this.
attachDBfile=|DataDirectory|/database.mdf. now problem arise that there is a database in the debug folder. whatever i'm updating is updated in database situated in debug folder. if i run the application. again the updates were gone and i am getting a fresh copy of database. could any one help me out from this situation.??? Sam
