How to Access defaultDatabase with dataConfiguration from Code Behind? RSS

• • Reply
  

  luckystar_20...

  0 Points

  14 Posts

  How to Access defaultDatabase with dataConfiguration from Code Behind?

  Jun 29, 2012 03:50 AM|LINK

  1. I have a xml configuration file for my program which shown as below. I want to make my program to run at other machines. But for right now, I cant access defaultDatabase from code behind. Anyone can help???

  <configSections>
  <section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null" />
  <section name="CompositeUI" type="Microsoft.Practices.CompositeUI.Configuration.SettingsSection, Microsoft.Practices.CompositeUI" allowExeDefinition="MachineToLocalUser" />
  </configSections>
  
  <dataConfiguration defaultDatabase="Connection String" />
  <connectionStrings>
  <add name="Connection String" connectionString="Persist Security Info=False;MultipleActiveResultSets=True;database=BPAS_MMY;server=BPIUAT;user id=xxx;password=xxx;" providerName="System.Data.SqlClient" />
  </connectionStrings>
  	
  <CompositeUI>
  <services>
  <add serviceType="Microsoft.Practices.CompositeUI.Services.IStatePersistenceService, Microsoft.Practices.CompositeUI" instanceType="Microsoft.Practices.CompositeUI.Services.IsolatedStorageStatePersistenceService, Microsoft.Practices.CompositeUI" />
  </services>
  </CompositeUI>
  	
  <appSettings>
  <add key="dataGlobalSchema" value="dbo" />
  <add key="ThemeManager" value="Blue" />
  <add key="AppCulture" value="en-US" />
  <add key="IdlePeriod" value="15" />
  <add key="AppKey" value="BPAS" />
  <add key="AppConfigServiceUrl" value="http://BPIUAT/CSCredentialService/CSAppConfigService.asmx" />
  </appSettings>

  2. Code Behind shown as below had error which is "dbSettings" cannot be declared as DatabaseSettings.

  By the way, I had imports System.Data already. 

  Dim dbSettings As DatabaseSettings = CType(ConfigurationManager.GetSection("dataConfiguration"), DatabaseSettings) 
  Dim defaultConnection As String = dbSettings.DefaultDatabase 
   
   SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings(defaultConnection).ToString() 

  Hence, anyone can help me how to access defaultDatabase in XML Config file from code behind??

  
  

• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: How to Access defaultDatabase with dataConfiguration from Code Behind?

  Jun 30, 2012 09:01 AM|LINK

  Hi,

  Since you are using xml，the most advantage of xml is just to do most dynammic changes to the value of your connection string——So please diretly change that value in the xml file by using NotePad to open the xml file and do modifications……

  If you still want to do changes to the web.config，you can just use XDocument（xml form）to analyze the file and do changes……

  XDocument doc = XDocument.Load("xxx.xml");
  XElement node = from item in doc.Descedants("connectionStrings").FirstOrDefault();
  if(node!=null)
  {
     node.Attribute("connectionString").Valu=Your new value here;
      doc.Save("your path & file name");
  }

  • Marked as answer by decker dong - msft on Jul 05, 2012 02:12 AM