Posted on: 12/15/2013 6:39:45 PM | Views : 785

Hi,

I have a training and live environment for one Application where I have created a AppSetting.Config file with List of values. (For example)
<add key="InfinityDatabase" value="[Infinity]"/> <add key="IsLive" value="True"/> My training environment and Live environment's App.Setting file has same keys but different values in it.
<asp:SqlDataSource ID="sdsBusinessType" runat="server" ConnectionString="<%$ ConnectionStrings:SqlClustConnectionString %>" SelectCommand="Select Distinct LTRIM(RTRIM([Type of Business])) as 'Type of Business' FROM <%$AppSettings: CompanyDatabase%>.dbo.<%$AppSettings: JobTable%> WHERE [Global Dimension 2 Code] = @ProjectCode AND [Type of Business] &lt;&gt; ''"> & ...

Go to the complete details ...