XtraPivotGrid Data Binding and Customization – In this lesson, I’ll show you how to bind the XtraPivotGrid to data and customize it. Thus, I’m going to create a simple application that has a PivotGrid Control bound to an Access Database. First, let’s drop a Pivot Grid Control onto a new form. And make it fill the entire form area. Now we need to create a data source and bind it to the pivot grid. Just like the XtraGrid, these actions can be done at once by the control’s smart tag. I click the Project Data Source…” link to start the Source Configuration Wizard”. “Add “Data The first step is to choose a data source type and it is in our case. “Database” Hence, I leave the default option and proceed to the next page to choose a data connection. I get to create a new connection here. All I have to do is to locate the desired database file on the disk . . . and I’m done! In the last step, I’ll choose the data table that will supply data to the grid. The will do nicely in this lesson. “Orders” I’ll specify a meaningful name for the DataSet . . . . . . and click Finish. The wizard has been completed . . . AND . . . as you can see, I have not only created the Data Source, but also bound it to the pivot grid. Now I’m going to invoke the pivot grid’s designer to add the required fields from the data source. I’ll switch to the columns page, and add the desired fields by double-clicking on them. I can now modify the selected fields’ properties.
XtraPivotGrid – Data Binding and Customization In this lesson, I’ll show you how to bind the XtraPivotGrid to data and customize it. Thus, I’m going to create a simple application that has a PivotGrid Control bound to an Access Database. First, let’s drop a Pivot Grid Control onto a new form. And make it fill the entire form area. Now we need to create a data source and bind it to the pivot grid. Just like the XtraGrid, these actions can be done at once by the control’s smart tag. I click the “Add Project Data Source…” link to start the “Data Source Configuration Wizard”. The first step is to choose a data source type and it is “Database” in our case. Hence, I leave the default option and proceed to the next page to choose a data connection. I get to create a new connection here. All I have to do is to locate the desired database file on the disk . . . and I’m done! In the last step, I’ll choose the data table that will supply data to the grid. The “Orders” will do nicely in this lesson. I’ll specify a meaningful name for the DataSet . . . . . . and click Finish. The wizard has been completed . . . AND . . . as you can see, I have not only created the Data Source, but also bound it to the pivot grid. Now I’m going to invoke the pivot grid’s designer to add the required fields from the data source. I’ll switch to the columns page, and add the desired fields by double-clicking on them. I can now modify the selected fields’ properties.
XtraPivotGrid01.docx