Enable this property to look at the web.config file that manages the site for this web part’s properties. The supported web part property entries are shown below. "XMLAdapter" comes from the Web.Config Element To Use property.
<appSettings>
<add key="CorasWorksXMLAdapterUseWebConfigSettings" value="true" />
<add key="CorasWorksXMLAdapterConnectionIdentifier" value="Conn" />
<add key="CorasWorksXMLAdapterWebPartIDIdentifier" value="WID" />
<add key="CorasWorksXMLAdapterOverrideForcedOutputIdentifier" value="OFO" />
<add key="CorasWorksXMLAdapterCustomXMLIdentifier" value="CustXML" />
<add key="CorasWorksXMLAdapterDataOnlyIdentifier" value="DO" />
<add key="CorasWorksXMLAdapterFilterIdentifier" value="Filt" />
</appSettings>
For example, if you wanted to place a SQL connection string into the web.config file, you may have something that look similar to the following. It has the Provider, Source, and user information included. Note: Please do not copy/paste this information as it has been formatted for reading and is using sample variables.
<appSettings>
<add key="FeedCacheTime" value="300" />
<add key="FeedPageUrl" value="/_layouts/feed.aspx?" />
<add key="TPID_Connection_String" value="Provider=SQLOLEDB;Data Source=abcgfephqdb023;Initial Catalog=TPIDD;User ID=tpiduser;Password=tpiduserpass" />
<add key="CWCentralConfigurationSite" value="http://abcgfethop027" />
<add key="ISNet.WebUI.WebGrid.v6_0_7200.RunTimeLicenseKey" value="5UDBQ-B6A7-8G6A8" />
<add key="ISNet.WebUI.WebGrid.v7_0_7200.EnableMultipleChartCallBack" value="true" />
</appSettings>
Within the External Data Provider, the connection string would similar to this:
<Data>
<Name>WorkPlanSubmit</Name>
<Default>false</Default>
<ConnectionType>ADO</ConnectionType>
<ConnectionString>[%TPID_Connection_String%]</ConnectionString>
<Query>exec TPCR.ACTION_PLAN_SUBMIT_sp %Key%,'%Title%','%Body%','%Status%',%CWUserNameND%</Query>
<Values>
<Key />
<Responses />
<Comments/>
<Result/>
</Values>
</Data>