Data Source Wizard

The Data Source Wizard enables you to configure a data source and retrieve the required data. It supports the following data source types:

  • Database

    Obtains data from all major data providers (Microsoft SQL Server, XML data, Microsoft Access, Oracle, etc.).

  • Entity Framework

    Supports binding to a Microsoft ADO.NET Entity Framework data source.

  • Object Binding

    Connects to any data object implementing the IList, IList<T> and IEnumerable<T> interfaces.

  • Excel File

    Obtains data from Microsoft Excel workbooks (XLS, XLSX or XLSM files) or CSV files.

data-source-wizard-vs

The Data Source Wizard allows you to do the following:

  • Add a new data-bound report to your application using the Report Wizard, which contains the Data Source Wizard pages.

    xtrareport-wizard-databaound-report-01

  • Bind an existing report or its Detail Report band to data. To invoke this Wizard, click the report's smart tag, expand the XtraReportBase.DataSource property's drop-down menu and click Add Report Data Source.

    how-to-ef-datasource01

  • Connect the Chart, Pivot Grid and Sparkline report controls to individual data sources. You can invoke the Data Source Wizard using the DataSource property in the control’s smart tag. .

    HowTo - AddChartDataSource