Hi,

I am coming from a forms background and need some help please.

I have a pivotgrid's datasource bound to a sqlcedatasource so that I can set various options at design time.

So that I can create a new table at runtime based on the pivotgrid's original table, I created a dataset.xsd and dragged the original table onto it from the database.   I then created a new table at runtime  and add the rows and data I need to the new table. Once this is done I change the binding of the pivotgrid to the newly created table.

The problem is that the pivotgrid is totally devoid of any rows/data. Looks good but is bloody empty

To check the creation of the new table at runtime, I added a gridview at design time and then at runtime I bound it to the above table that was also created at runtime and voila, the gridview reflects all the datarows I added at runtime.

I am sure I am probably doing a number of things wrong (or at least 'the hard way') and I would appreciate any assistance in not only fixing the immediate problem but also if my above logic is flawed.

Thanks.

Hi Glen,

Looks like you have forgot to call the DataBind method after you set the DataSource property for the PivotGrid. Is it the case?

Yep - I discovered this little gem of information somewhere since my orginal post. probably when I discoved a pivotgrid wasn't appropriate.

Thanks.