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();
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.