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

Manas Mohapatra · Answer

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);