Storing file location/data in a local DB

cody ripley

I'm developing a Lead/Opportunity tracking system. Currently I store information in a .MDF (LocalDB).

As of now I have things working, storing my project bid dates, statuses etc.

For some of these projects, there will be files associated with them, that I would like to store, and access, such as specifications or plan files. I am lost at this point, and I have come to you!

What would be an efficient way of storing file information in my database, and accessing it when I am querying for normal data?

I am thinking of creating a seperate table called "Files", with the columns "ID", "FileName", "FileLocation", "FileType".

I am not sure how to make this work, what would you do?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

cody ripley9y ago
@Salman

What would be the best way to store the path?

Basically I want to select a row in a gridview (the project) and update a second gridview with the file information with option to open the file.
Salman Beg9y ago
Hi. Please store all the files in a folder and in db just store the path.bcoz if you store a file in db then unnecessarily the size of db increases.thanks.