How to create multiple table with same RadGrid using different DataSet

[Mc]

I have a RadGrid like this:

<telerik:RadGrid ID="ProductGrid" runat="server"
    OnItemDataBound="ProductGrid_ItemDataBound"
    OnNeedDataSource="ProductGrid_NeedDataSource">
    <MasterTableView AutoGenerateColumns="False" DataKeyNames="Change" TableLayout="Fixed">
        <Columns>
            <telerik:GridBoundColumn DataField="Name" HeaderText="Name" UniqueName="Name">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="Price" HeaderText="Price" UniqueName="Price">
            </telerik:GridBoundColumn>
        </Columns>
    </MasterTableView>
</telerik:RadGrid>

I want to have tables for each category. And I want to display several categories at same time with ability to show/hide each of them (I can figure out show/hide part). How could I achieve it?

Thanks in advance!

[Pavlina]

Hello,

You can modify the columns collection of a RadGrid dynamically on postback using the approach presented in the article below:
http://www.telerik.com/help/aspnet-ajax/grid-changing-structure-dynamically.html

Regards,
Pavlina
Telerik

 

 

[Mc]

Hi Pavlina,

Thanks for the reply. That's the way to change *one* Grid dynamically, I want to use the RadGrid as template to create multiple grid with different dataset. Is that possible? 

[Mc]

Realized that I could use C# library to achieve this:

RadGrid1 = new RadGrid();