Using a hierarchical grid with 2 levels bound to SQL datasources. I have a drop-down that provides a filter on the year, the level 1 data has the year as a parameter in the SQL datasource. When I change the year in the drop-down everything looks good and the level 1 data changes to the new selected year. After changing the year and then expanding the row to see the child data I get Async request failed. It doesn't matter what year I have displayed, after expanding the first time you can no longer expand without getting the error. I am using 15.1 CLR 4.5.
I'm still playing around with this but I continue having the same null reference and it's actually HasDataFilteringHandled. So I tried adding the handler for this, but still error. I thought maybe there was an issue adding multiple filters on the same key so I updated as shown below. Here I've tried skipping the ApplyFilter completely and just did a databind on the grid, but this does nothing.
Also, I added the initial filter in the aspx which works fine except the filter applies correctly to the data, but the check boxes in the filter drop-down are all still checked.
Dim strFY As String
strFY = ddFY.SelectedValue
Dim columnFilter As ColumnFilter
If gridIAA.Behaviors.Filtering.ColumnFilters("FiscalYearStart") Is Nothing Then
ColumnFilter = New ColumnFilter()
ColumnFilter.ColumnKey = "FiscalYearStart"
ColumnFilter.Condition = New RuleTextNode(TextFilterRules.Equals, strFY)
gridIAA.Behaviors.Filtering.ColumnFilters.Add(columnFilter)
Else
ColumnFilter = gridIAA.Behaviors.Filtering.ColumnFilters("FiscalYearStart")
End If
gridIAA.DataBind()
I just took another approach and included the element to filter in the grid to use the grid filtering. So I still wanted to use the drop-down to let the user select a year from the drop-down outside of the grid to filter the grid. When the page loads, I set the drop-down and the filter to the current year and do this:
Dim filtering As Filtering
filtering = gridIAA.Behaviors.Filtering
columnFilter = New ColumnFilter()
columnFilter.ColumnKey = "FiscalYearStart"
columnFilter.Condition = New RuleTextNode(TextFilterRules.Equals, strFY)
filtering.ColumnFilters.Add(columnFilter)
filtering.ApplyFilter()
This is getting null reference exception on HasDataFilteredHandled, which is read only.
at Infragistics.Web.UI.GridControls.Filtering.get_HasDataFilteringHandled() at Infragistics.Web.UI.GridControls.Filtering.OnDataFiltering() at Infragistics.Web.UI.GridControls.Filtering.ApplyFilter() at NEXTIAA.NEXTComponents.Web.SelectIAA7600.ApplyFYFilter() in C:\MyProjects\Visual Studio 2012\Projects\NEXTIAA7600\NEXTIAA7600New\SelectIAA7600.aspx.vb:line 59 at NEXTIAA.NEXTComponents.Web.SelectIAA7600.gridIAA_DataBound(Object sender, EventArgs e) in C:\MyProjects\Visual Studio 2012\Projects\NEXTIAA7600\NEXTIAA7600New\SelectIAA7600.aspx.vb:line 64 at System.Web.UI.WebControls.BaseDataBoundControl.OnDataBound(EventArgs e) at Infragistics.Web.UI.GridControls.WebHierarchicalDataGrid.DataBind()
Hi,
Thank you for posting in the Infragistics community!
It is hard to assume what may be causing this issue, reasons may vary but I would need more context information. It would be best if you could provide a working sample reproducing the described behavior. If not, please try provide the following:
1) The WHDG markup and related code behind
2) Steps to reproduce ( I was not able to understand if issue happenson first expand try or second one ? )
3) Exact version of the Infragistics product that you are using.
Looking forward to hearing from you.