<div>
I use the form load event like this for a TableAdapter (C#):<br />
<br />
conString = &quot;&quot;;<br />
myDataTableAdapter.Connect<wbr />ion.Connec<wbr />tionString<wbr /> = conString;<br />
<br />
You could probably do the same for a DAL.<br />
<br />
/gustav
</div>


<div>
Thanks gustav,<br />
but I have many (more than 50) &nbsp;tableadapters in the datasets and they all get the connectionstring from the same variable (in the DAL: my.settings.MyConnectionSt<wbr />ring). &nbsp;That property is only visible to the DAL, but Ideally, i would like to change that property to the desired string, so all the tableadapters would be be reading the new value, without overriding on each invocation of a tableadapter. &nbsp;From the DAL, can I reference an application property setting in the startup project? <br />

</div>


<div>
That's a nice solution, magic.<br />
<br />
/gustav
</div>


<div>
thank you magic!<br />
Indeed, that is the path i was heading down, &nbsp;so your solution makes good sense to me. &nbsp;<br />

</div>


<div>
i thought i had already accepted your answer and awarded points, but just in case, i'll try this again...thank you magic
</div>


<div>
<div class="content wysiwyg-content">
I have several projects in one solution. &nbsp;In one project lives all my datasets (DAL). They were developed using the dataset wizard and the connectionstring &nbsp;is coming from Settings file for that project.<br />
<br />
The Startup project contains the User Interface (UI). &nbsp;I want to be able to control the database location (presumably from the application's App.config) file so that we can migrate easily from a test location to a live location and even (from the user.config file) a local data location for off-line use.<br />
<br />
What is the best practice for, at run time, overriding the ConnectionString for the datasets in the DAL, since they currently come from their private settings (&quot;My.settings&quot;) &nbsp;namespace?<br />
&nbsp;
</div>
</div>


I have several projects in one solution.  In one project lives all my datasets (DAL). They were developed using the dataset wizard and the connectionstring  is coming from Settings file for that project.

The Startup project contains the User Interface (UI).  I want to be able to control the database location (presumably from the application's App.config) file so that we can migrate easily from a test location to a live location and even (from the user.config file) a local data location for off-line use.

What is the best practice for, at run time, overriding the ConnectionString for the datasets in the DAL, since they currently come from their private settings ("My.settings")  namespace?
 

From App.config in Startup Project, How do i propagate the ConnectionString to the data access layer?

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.