asp.net

Question

 

        I  have complete design windows application front end is  asp.net and back end code C# and MS access database

 

but when i store database file in D directive application work but when Built exe file the not built with database.

 

so for that database store in application Bin folder but  application database connection not work. 

 

 

please give me solution

 

Answer 1

Do not put assume that you will always have D drive. So you need to put MS access file in your current directory where exe file is going to install. Make access file as Embedded resource when you build exe file.

 

Next you to get path using following code:

 

string filePath = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location),

"TempDB.mdb");

 

or

 

string filePath = Path.GetFullPath("Licence.txt");