ContextQMD
Back to Devexpress

LINQ to SQL

wpf-115632-controls-and-libraries-pivot-grid-binding-to-data-items-source-configuration-wizard-linq-to-sql.md

latest1.2 KB
Original Source

LINQ to SQL

  • Mar 14, 2021
  • 2 minutes to read

The Items Source Configuration Wizard allows you to bind the PivotGridControl to an SQL database using LINQ to SQL at design time. This topic shows how to do this.

  1. Click the PivotGridControl’s smart tag and select the Items Source Wizard command.

  2. In the invoked Items Source Configuration Wizard, select LINQ to SQL …

  3. The following message will appear.

  4. Make sure that the LINQ to SQL Classes item is selected in the invoked dialog. Then, specify the required name and click Add.

  5. After creating a data source, click Items Source Wizard again.

  6. In the invoked Items Source Configuration Wizard, select the created data model.

  7. On the next page, select the required binding method.

  8. On the final page, you can specify the table.

  9. The PivotGridControl will be bound to the created data source.

See Also

Binding to a Data Source Using 'LINQ to SQL Classes'