forum

Home / DeveloperSection / Forums / use openfiledialog to get path of open database C#

Ask Question

use openfiledialog to get path of open database C#

Anonymous User 2387 28-Sep-2013

I'm using Visual Studio Expess 2010. I am trying to figure out how to use the openfiledialog to getthe path of my database.

Currently I close the connection to my database and then try to select the database in the open file dialog but Windows tells me: "This file is in use, close the file..."

If I've closed my db connection what else do I need to do to completely close the file so I can select it in the openfiledialog?

It can depend a lot on where the db file is, e.g. is it in your project? is it in your sql server data folder?

c# c# 
Updated on 28-Sep-2013
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

Anonymous User

Anonymous User

28-Sep-2013
Hello Babe!
Try the following sql to give you the path if it's in the data folder... 
select physical_name

from sys.database_files

where type = 0
if it's in the app_data folder of your project try a simple 
Server.mappath

Liked By