Directly Accessing a SQL Server Database

Valid from List & Label 15
The. NET component of List & Label gives you direct access to SQL Server databases. The easiest way to do this is to use the SqlConnectionDataProvider class:
SqlConnection connection = new SqlConnection(connectionString); 
DataProviders.SqlConnectionDataProvider provider = new DataProviders.SqlConnectionDataProvider(connection);
LL.DataSource = provider;

The constructor of the provider also provides a selection of schemas that should be supplied.

Corresponding providers are also available for DB2, Firebird, NuoDB, MySQL, PostgreSQL and Oracle. The source code for these providers can also be downloaded directly from GitHub under the following link.

IDKBTE000756 KBTE000756