Web Part tab

The Web Part tab is the first tab on the Data Viewer Web Part dialog and allows you to choose data source and display providers, and page loading options, as described below:

Data Source Provider

There are seven data source providers:

• MSSql Data Source Provider
  
  
• Oracle Data Source Provider
  
  
• ODBC Data Source Provider
  
  
• SharePoint List Data Source Provider
  
  
• OData Service Data Source Provider
  
  
• SharePoint External Data Source Provider
  
  
• XML Data Source Provider
  

Display Provider

There is one display provider for displaying your content.

• SPGridView Display Provider. This display provider is often referred to as the no-code or grid like display provider. Use this provider to select columns to display, configure filters, sorting, pagination, column width and formatting without the need to write any code.
  

*In a future release of the Data Viewer Web Part, XSLT or JSon display providers will be available.

Data Refreshing Interval

Type in the text box the interval of time in seconds that the Lightning Conductor Web Part will fetch the items from the data source and refresh the page. A value of 0 or if you leave the text box empty, then the Web Part will only query the data source if the page is manually refreshed. When caching is enabled the value typed into this text box has no affect, that is, if caching is enabled at the refreshing interval the data is obtained from the cache and not from the data source.

Initial Loading

Select this check box to load the Web Part with item information independently of the page load. This is the default setting. When the check box is unselected the page loads once item information has been queried.

Configure Statistical Information

Select this check box to display details at the top of the Web Part on how many items are being aggregated. This is useful when trying to identify performance issues.