Our application generates DataSet and feeds that to WinGrid. Now I need to use this DataSet to use it in PivotGrid. I know that I must use FlatDataSource for PivotGrid, but it not possible since we get the DataSet from the server and we want to do this in the client. Is there a way to convert our existing DataSets to FlatDataSource so we can use it in Pivot Grid?
Thank you for contacting Infragistics!
You can achieve this if you are using a DataTable by using a DataAdapter of the FlatDataSource. Here is the docs for using the data adapter:
Using the FlatDataSource DataAdapter