Controlling-access-to-tables-and-views

To control access to the data sources you can use AdHocSettings.ViewsOnly setting or AdHocSettings.VisibleDataSources property.

If the ViewsOnly is set to true: only Views will be visible at the Data Sources tab.

The VisibleDataSources property is an array of table names. Only tables in this array will be visible at the Data Sources tab.

Note: DO NOT use ViewsOnly and VisibleDataSources at the same time!

Using ViewsOnly:

C#

Izenda.AdHoc.AdHocSettings.ViewsOnly = true;

VB.NET

Izenda.AdHoc.AdHocSettings.ViewsOnly = True

Using VisibleDataSources:

C#

  Izenda.AdHoc.AdHocSettings.VisibleDataSources = new string[] { "Products", "Categories" };

VB.NET

  Izenda.AdHoc.AdHocSettings.VisibleDataSources = New String() { "Products", "Categories" }