DatabaseKey - Specifies the database key to be used in the picker business object to retrieve data. If you only use a single database key with your application (even if you use multiple database sets) you do not need to specify this setting.So, in order to get this to work properly, set the DatabaseKey property of the picker control on the Customer Orders form to Northwind.
> <!-- User application and configured property settings go here.--> > <!-- Example: <add key="settingName" value="settingValue"/> --> > <add key="SecurityDatabaseSetKey" value="CustA"/> > <add key="SecurityDatabaseKey" value="SecurityDB"/> > <add key="DatabaseSetDefault" value="CustA"/> >Actually, there is no SecurityDatabaseSetKey...just SecurityDatabaseKey and DatabaseSetDefault.
> <databases> > <add key="CustA\Northwind\Connection" value="server=AppDBServer;database=Northwind;Integrated Security=SSPI;Persist Security Info=False;" /> > <add key="CustA\Northwind\DataAccessClass" value="DataAccessSql" /> > <add key="CustB\Northwind\Connection" value="Provider=vfpoledb.1;Data Source=C:\Program Files\Mere Mortals .NET Framework 2005\Samples\VFPData\northwind.dbc" /> > <add key="CustB\Northwind\DataAccessClass" value="DataAccessOleDb" /> > <add key="CustA\SecurityDB\Connection" value="server=AppDBServer;database=SecurityDB;Integrated Security=SSPI;Persist Security Info=False;" /> > <add key="CustA\SecurityDB\DataAccessClass" value="DataAccessSql" /> > </databases> >>and also where and who reads the "SecurityDatabaseSetKey", "SecurityDatabaseKey", "DatabaseSetDefault" settings.