Progress® Telerik® Reporting R3 2021

New to Telerik Reporting? Download free 30-day trial


The SqlDataSource component enables data items to display data located in a relational database, including Microsoft SQL Server and Oracle databases, as well as OLE DB and ODBC data sources, using little or no code. Using SqlDataSource allows you to access and display data in a report without using ADO.NET classes directly. You provide a connection string to connect to the database and define the SQL statement or the stored procedure to retrieve the data. At run time, SqlDataSource automatically opens the database connection, executes the SQL statement or stored procedure, returns the selected data, and then closes the connection. The SqlDataSource component would list and work with any ADO.NET provider that is correctly registered on the device. The list with ADO.NET providers is taken as described in Obtaining the DbProviderFactory MSDN article and lists all of the provider factories registered in the machine.config.

Supported providers

The SqlDataSource component uses ADO.NET classes to interact with any database supported by ADO.NET. This includes, but is not limited to:

Provider Name

Invariant Name


SqlClient Data Provider


.Net Framework Data Provider for SqlServer

OracleClient Data Provider


.Net Framework Data Provider for Oracle

OleDb Data Provider


.Net Framework Data Provider for OleDb

Odbc Data Provider


.Net Framework Data Provider for Odbc

MySQL Data Provider


.Net Framework Data Provider for MySQL

Oracle Data Provider for .NET


Oracle Data Provider for .NET

Supported developer platforms

  • .NET Framework 4.0 and above

  • .NET Core 2.0 and above

  • .NET Standard 2.0 and above

In this article
Not finding the help you need?