Grid NeedDataSource Problem

[Saranya]

Hi,

I am using radgrid. I have three dropdownlists - dd1,dd2,dd3 and a button. I need to choose a data from dd1. Upon the choice my dd2 will get loaded and after choosing a data from dd2, my dd3 will be loaded. After selecting value from dd3, i will click on the button to generate data in the grid.

Sorting, paging, filtering everything works fine without any problem.

I have generated records on the grid. I click on the header for sorting. It gets sorted. When it is in the sorted state, if I select another data from dd1 and then dd2, then dd3 and click on the button, I am getting error stating "customer name not found in data set...". The new data in dataset doesnt have customer name. My previous dataset has column customer name and it is searching for the same columns. I think that is the problem. Retaining old dataset values after sorting or filtering or paging. The moment I reset the sort condition (by clicking on small arrow near column name header) and do these operations, i dont get any error.

How to resolve this?

Thanks
Saranya

[Veli]

Hello Saranya,

RadGrid's sort, group and filter expressions, as well as the current page index are all preserved on rebind. You need to clear them all before rebinding to data with a different set of columns.

Kind regards,
Veli
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Saranya]

Hi, Please tell me how to clear the sort, page index etc? Thanks. Saranya

[Shinu]

Hi Saranya,

Give a try with following code snippet and see whether it meets your requirement.

CS:

        RadGrid1.MasterTableView.SortExpressions.Clear();
        RadGrid1.MasterTableView.CurrentPageIndex = 0;
        RadGrid1.MasterTableView.Rebind();

Thanks
Shinu

[Saranya]

Hi,

Thanks. It solved my problem.

Regards,
Saranya