SqlConnectionDataProvider Class

In This Topic

This data provider can be used to consume data from a SqlConnection. 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

Syntax

Visual Basic
C#
C++/CLI

'Declaration
 
Public Class SqlConnectionDataProvider 
   Inherits DbConnectionDataProvider
   Implements ICanHandleUsedIdentifiers, IDataProvider, combit.Reporting.ISupportsLogger

public class SqlConnectionDataProvider : DbConnectionDataProvider, ICanHandleUsedIdentifiers, IDataProvider, combit.Reporting.ISupportsLogger

public ref class SqlConnectionDataProvider : public DbConnectionDataProvider, ICanHandleUsedIdentifiers, IDataProvider, combit.Reporting.ISupportsLogger

Remarks

For .NET Framework 4.x, the SqlConnection object comes from the System.Data.SqlClient namespace.

For modern .NET versions the Microsoft.Data.SqlClient namespace is used for the SqlConnection object. It may be necessary to set in the used connection string the parameter Encrypt to false if the SQL Server does not use a valid SSL certificate - e.g. for testing purposes.

Example

SqlConnection conn = new SqlConnection(Properties.Settings.Default.ConnectionString);
SqlConnectionDataProvider provider = new SqlConnectionDataProvider(conn);
LL.DataSource = provider;
LL.Design();

Inheritance Hierarchy

System.Object
   combit.Reporting.DataProviders.DbConnectionDataProvider
      combit.Reporting.DataProviders.SqlConnectionDataProvider
         combit.Reporting.DataProviders.AzureSqlDataProvider

Requirements

Platforms: Windows 10, Windows 11, Windows Server 2016 - 2025
.NET: .NET Framework 4.8, .NET 10, .NET 11

Reference

SqlConnectionDataProvider Members
combit.Reporting.DataProviders Namespace

Send Feedback