Intersoft Community - WebGrid Enterprise - Strange WebGrid error using filtered columns

Strange WebGrid error using filtered columns

John.Bonin@dot.gov — Fri, 04 Oct 2013 07:21:31 GMT

Hans,

Thank you this helped. I was using a multiview control with a different grid in each view and the structures were different. Even though only one view was dispayed at a time, both were being populated. Since one grid was different, it was trying to apply the filter to both grids, thus the error. Just forgot to load only one grid at a time!

Again Thanks for your help.

Strange WebGrid error using filtered columns

Hans — Fri, 04 Oct 2013 04:05:20 GMT

Hello,

Thank you for the question.

After I investigate this filter issue, it seems the issue occurs due to we want to filter the column when the column hasn’t rendered yet.

I attached 2 WebGrid samples which show that we should / can filter a column after the column is already rendered (ready to be filtered)

In this sample, I bind the WebGrid programmatically (with OleDbConnection).
I add filtering code in PrepareDataBinding server side event. In that event I also add RetrieveStructure() method (to retrieve Column's structure).

In the first WebGrid sample, I put the RetrieveStructure() method “before” filtering code. The result is the filtering works fine.
Here’s the snippet code:

protected void WebGrid1_PrepareDataBinding(object sender, ISNet.WebUI.WebGrid.DataSourceEventArgs e){
    if (!IsPostBack)
    {
        WebGrid1.RetrieveStructure();
        WebGridFilter fltr = new WebGridFilter("ShipName", ColumnFilterType.Contain, "Vins");
        WebGrid1.RootTable.FilteredColumns.Add(fltr);            
    }
}

In the second sample, I put the RetrieveStructure() method “after” filtering code. The result is I got the same error message as yours.
Here’s the snippet code:

protected void WebGrid1_PrepareDataBinding(object sender, ISNet.WebUI.WebGrid.DataSourceEventArgs e)
{
    if (!IsPostBack)
    {
        WebGridFilter fltr = new WebGridFilter("ShipName", ColumnFilterType.Contain, "Vins");
        WebGrid1.RootTable.FilteredColumns.Add(fltr);
        WebGrid1.RetrieveStructure();
    }
}

Therefore, please kindly re-check / review your application’s code, whether the column is already rendered or not, when you try to filter it.

Hope this helps.

Regards,
Hans.

Strange WebGrid error using filtered columns

John.Bonin@dot.gov — Thu, 03 Oct 2013 14:07:10 GMT

I'm getting a strange error that I can't determine what the problem is and hoping that you may see something fom the stack trace that could help me in finding the problem.

I have a standard grid (v8), where when a user sets a filter that filter is saved off for use when the user returns back to this page. The saving and restoring of the filters is working and looks correct. With most of the columns there is no problem but there are 3 columns (no different from the other columns) that when teh filter is restored the error in the attached file occurs. I know I won't be able to create a simple page that shows the error, so hoping the stack trace gives some clue!

thanks