3 tier architecture, could not find file
Hi i'm developing windows desktop app using 3 tier architecture with VB, when i run the application i get "Could not find file 'C:\Users\PHU-T\Documents\Visual Studio 2013\Visual_Basic_2013_SBS\Chapter 09\Orange Student\bin\Debug\Students.accdb" error. The Student.accdb file is the Data Access Layer project, the file is copied to bin\Debug folders of the Data Access Layer and Business Logic Layer projects but not in the Presentation Layer. I don't want to create fixed data source like 'C:\Users\PHU-T\Documents\Visual Studio 2013\Students.accdb' as the project will be submitted for marking. How can i solve this? i'm using the data source below.
Data Source=|DataDirectory|\Students.accdb
You need to add a reference to the DAL project from your PL project in order for the .accdb file to end up in the output directory of your main application.
Update
I could not reproduce this myself in Visual Studio 2013 with a similar project setup. Referencing the BLL project from the main app was all I needed to copy the DB. You might want to check the properties of the .accdb file in your project and make sure it's set to "Copy Always".
- SQL server view return different results in Entity Framework
- .NET equivalent of the old vb left(string, length) function
- AppManifest File not found in project
- Find and replace function contents in all pages?
- Inserting a tab character into text using C#
- Storing Connection Strings in Registry?
- Printing on users default printer from .net application on server
- How do I redirect a response to an ASP.NET page in a different folder?
- NumericUpDown with UpdateEditText()
- Dynamically populate ASP.NET Gridview from jQuery AJAX call
- Dynamically adding to a VB.net Object
- Trouble with Filtering a .NET DataTable
- printing png file with file system watcher vb.net
- How to modify a feature tag attribute depending on a value of a different attribute with LINQ
- How to add an optional parameters/default value parameters in VB function?
- Remove a particular XML element depending on a particular attribute value with LINQ
- How to fix the 'Resources' is not a member of 'My'
- Need jsonNode.parse to do a case insensitive match in VB.Net
- Disable mouse scroll wheel in combobox VB.NET
- How to screen a rectangle with a keyup event?
- In VB.Net, navigate to Treeview node based on filepath
- VB: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)
- How to set timeouts for FluentFTP
- Run batch file in vb.net
- Add javascript onclick to radio button INPUT tag
- how to get the current year and the next year in asp?
- VB.net Hex to byte array translated to C#
- why the row size results are not the same in datagridview2 using the DataGridViewTheme class compared to datagridview1 in VB.NET
- .NET regex: add space before all & characters
- Sort a table in ClosedXML while keeping header row