+1 800 256 3608 (toll-free in North America) or +49 7531 90 60 10| service@combit.com

Directly Accessing a SQL Server Database

net
(combit Team) #1
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;
LL.Design(); 


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.

Links:

https://github.com/combit/NETDataProviders
IDKBTE000756 KBTE000756