Tuesday, 13 August 2013

Dynamic Connection Strings

Connection is one of the core properties of DataGrid and DetailsView controls. From release 4.1.2311.5146, users can specify dynamic connection strings in the DataGrid control. The connection string can be derived from these 3 sources :

1.  Connection
  • Contains a list of available connections as specified in ConfigSettings --> Connections
2. Custom Setting
  • Contains a list of available Custom Settings as specified in ConfigSettings --> CustomSettings
  • Example of a connection string definition in CustomSettings :
3. SQL Query
  • Store the connection strings in a database table.
  • Write a SQL Query to return the value from database
  • Example :


Tips :
**Query must return only 1 connection string
**You can also use this feature in Dropdown columns in DataGrid