WCF Data Services

• Mar 13, 2021
• 2 minutes to read

The Data Source Configuration Wizard allows you to bind the PivotGridControl to data using WCF Data Services. This topic guides you through the steps needed to do this.

1. Click the Data Source Wizard button placed on the PivotGridControl or use a corresponding command in a control’s smart tag.

   

2. In the invoked Data Source Configuration Wizard, select WCF Data Services…

   

   … and click the New Data Source button placed within the Data Sources area.

   

3. The following message will appear.

   

   Click OK.

4. Specify the address of a data service.

   

   To learn how to create a WCF data service, see the following topics: Creating the Data Service.

   Important

   After you creat a service reference, rebuild the solution.

5. After creating a service reference, click the Data Source Wizard again.

   

6. In the invoked Data Source Configuration Wizard, select the created service.

   

   Click Next.

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

   

   • Direct Binding to Data Source - allows you to bind the PivotGridControl to a data source directly.
   • Binding via the BindingSource Component - allows you to bind the PivotGridControl to a data source using the BindingSource component, which simplifies design-time data binding. To learn more, see BindingSource Component Specifics.
   • Server Side Data Processing - allows you to bind the PivotGridControl to large data sources. To learn more, see Database Server Mode.

   Select Direct Binding to Data Source and click Next.

8. On the final page, specify the service URI (Service Root) and click the Test Connection button.

   

   Then, select the required Table and click Finish.

9. The following code will be generated by the Data Source Configuration Wizard.

   C#

   
   public Form1()
           {
               InitializeComponent();
               // This line of code is generated by the Data Source Configuration Wizard
               pivotGridControl1.DataSource = new WinFormsPivot.ServiceReference1.NorthwindEntities(new System.Uri("http://localhost:65455/Northwind.svc/")).SalesPersons.ToList();
           }
   

   VB.NET

   
   Public Class Form1
       Sub New()
           InitializeComponent()
           ' This line of code is generated by the Data Source Configuration Wizard 
           PivotGridControl1.DataSource = New WinFormsPivot.ServiceReference1.NorthwindEntities(New System.Uri("http://localhost:65455/Northwind.svc/")).SalesPersons.ToList()
       End Sub 
   End Class 
   

   You can now work with the created data source at runtime. For instance, to retrieve fields from the connected data source, call the PivotGridControl.RetrieveFields method.