combit List & Label 24 - .NET Online Web Help
SqlConnectionDataProvider Class
Members  Example 


combit.ListLabel24.DataProviders Namespace : SqlConnectionDataProvider Class
This data provider can be used to consume data from a SqlConnection (from the System.Data.SqlClient namespace). As the connection object will be cloned multiple times, the connection string needs to set Persist Security Info to True if user/password authentication is used. This class is serializable.
Object Model
SqlConnectionDataProvider Class
Syntax
'Declaration
 
Public NotInheritable Class SqlConnectionDataProvider 
   Inherits DbConnectionDataProvider
   Implements ICanHandleUsedIdentifiers, IDataProvider, combit.ListLabel24.ISupportsLogger 
public ref class SqlConnectionDataProvider sealed : public DbConnectionDataProvider, ICanHandleUsedIdentifiers, IDataProvider, combit.ListLabel24.ISupportsLogger  
Example
SqlConnection conn = new SqlConnection(Properties.Settings.Default.ConnectionString);
SqlConnectionDataProvider provider = new SqlConnectionDataProvider(conn);
LL.DataSource = provider;
LL.Design();
Dim conn As New SqlConnection(Properties.Settings.[Default].ConnectionString)
Dim provider As New SqlConnectionDataProvider(conn)
LL.DataSource = provider
LL.Design()
Inheritance Hierarchy

System.Object
   combit.ListLabel24.DataProviders.DbConnectionDataProvider
      combit.ListLabel24.DataProviders.SqlConnectionDataProvider

Requirements

Platforms: Windows Vista - Windows 10 Version 1809, Windows Server 2008 - 2016

See Also

Reference

SqlConnectionDataProvider Members
combit.ListLabel24.DataProviders Namespace