Binding a Report to a Database
- 2 minutes to read
DevExpress reports support binding to the following data providers:
SQL Data Source | Supported Versions | Data Provider | .NET Standard Support |
---|---|---|---|
Microsoft SQL Server | 2005, 2008, 2008R2, 2012, 2014, 2016 2005 Express Edition, 2008 R2 Express, 2012 Express, 2014 Express, 2016 Express Azure SQL Database | System.Data.dll (Included in .NET Framework) | |
Microsoft Access | 2000 or higher | System.Data.dll |
|
Microsoft SQL Server CE | 3.5, 4.0 | System.Data.SqlServerCe.dll (Included in .NET Framework) |
|
Oracle Database | 9i or higher |
| |
Amazon Redshift | n/a |
| |
Google BigQuery | n/a |
| |
Teradata | 13.0 or higher |
| |
SAP Sybase Advantage | Advantage Database Server 9.1 or higher |
| |
SAP Sybase ASE | Sybase Adaptive Server 12.0 or higher |
| |
SAP SQL Anywhere | 11 or higher |
| |
IBM DB2 | 9.5 or higher |
| |
Firebird | 1.5 or higher, Dialect 3 | FirebirdSql.Data.Firebird.dll | |
MySQL | 4.1 or higher | ||
Pervasive PSQL | 9.x or higher |
| |
PostgreSQL | 7.x or higher | ||
VistaDB | 4, 5 |
| |
SQLite | 3.x | ||
XML file | n/a | n/a |
Use the Report Wizard to bind a report to any of these data providers at design time. See the following tutorials for detailed instructions:
- Bind a Report to a Database
- Bind a Report to a Data Source Schema
- Bind a Report to a Stored Procedure
Use the SqlDataSource class to bind a report to a database at runtime. See the following tutorials for code examples:
- Bind a Report to an MDB Database (Runtime Sample)
- Bind a Report to a Microsoft SQL Server Database (Runtime Sample)
- Register a Custom Schema Provider for a Synonym Database
Tip
See Binding a Report Using Standard .NET Data Providers to learn how to bind your report to an OLE DB provider or an existing DataSet object.