Filtering in Rad Grid using ASP Dropdown

[Vikram Vyas]

Hello ,

I am trying to achive filter feature using asp.net dropdown, following code works fine with filter

====================================

 

SPSite oSPSite = new SPSite(strSiteUrl);

 

 

SPWeb oSPWeb = oSPSite.OpenWeb();

 

 

SPList oSPList = oSPWeb.Lists[strPERListName];

 

 

SPView oSPView = oSPList.Views["All Issues"];

 

 

SPListItemCollection oSPListItemCollection = oSPList.GetItems(oSPView);

 

RadGrid1.DataSource = oSPListItemCollection.GetDataTable();

RadGrid1.DataBind();

==================================================
Now i have a dependent dropdown where i.e User
Selects = Country
and it shows States in another dropwdown. So when use chages the value in Contry dropdown it revert back to original values, becuase the above code is in page load.
i also tried using NeerDataSource evene to get this achived but no success.
===============================================

[Yavor]

Hello Vikram,

Setting the filter like this will not work in all cases. One possible approach in this case would be to use standard AdvancedDataBinding(or a datasource control), and then manually set the filter expression for the control. I hope this suggestion helps.

Sincerely yours,
Yavor
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.