Intersoft Community - WebGrid Enterprise - how to kept FilterBar state

how to kept FilterBar state

Hans — Mon, 30 Apr 2012 00:05:30 GMT

Hello,

Thank you for your code.
My apologies for the inconvenience. I can replicate your issue on my end as well.
However, to set the filter text and filter type, you could use this following code below (in Page_Load server side event):

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        if (Session["ses_filter_columns"] != null)
        {
            WebGridFilterCollection wgfc = (WebGridFilterCollection)Session["ses_filter_columns"];

            int iFilterCount = wgfc.Count;
            for (int i = 0; i < iFilterCount; i++)
            {
                var myFilter = new WebGridFilter();
                myFilter.ColumnMember = wgfc[i].ColumnMember;
                myFilter.FilterText = wgfc[i].FilterText;
                myFilter.FilterType = wgfc[i].FilterType;
                WebGrid1.RootTable.FilteredColumns.Add(myFilter);
            }   
        }
    }
}

Hope this helps. Thank you.
Regards,
Hans.

how to kept FilterBar state

rogerchen.tangshuo@gmail.com — Fri, 27 Apr 2012 21:26:27 GMT

Hans, thanks for you reply, i set AutomaticFilter="false" in page "A", then add follow code

        protected void wegbrid1_CustomFilter(object sender, FilterEventArgs e)
        {
            // save filter state
            Session["ses_filter_columns"] = wegbrid1.RootTable.FilteredColumns;
        }

in Page_Load event add follow code

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
            if (Session["ses_filter_columns"] != null)
            {
                WebGridFilterCollection wgfc = (WebGridFilterCollection)Session["ses_filter_columns"];

                int iFilterCount = wgfc.Count;
                for (int i = 0; i < iFilterCount ; i++)
                {
                    webgrid1.RootTable.FilteredColumns.Add(wgfc[i]);
                }
            }
    }
}

the data of page "A" display ok when return page "B", but the filter text of FilterBar disappear.

so i want to show filter text and filter type i selected.

Regards,
Roger

how to kept FilterBar state

Hans — Fri, 27 Apr 2012 05:32:56 GMT

Hello,

To implement this scenario, first, you should get the filter value in filter column.
Here’s the example snippet code how to get the filter value (in client side event):

var WebGrid1 = ISGetObject("WebGrid1");
var filter = WebGrid1.RootTable.GetFilterRow();
var filterRow = WebGrid1.RootTable.ToRowObject(filter);
// You could choose the column by the column's name
var filterCell = filterRow.GetCells().GetNamedItem("ContactName");
var filterText = filterCell.Text;

I suggest you to save the filter value to session variable.

Then, to set back the filter value (or filter bar state), please use this following snippet code (in client side event):

var WebGrid1 = ISGetObject("WebGrid1");
var newFilter = new WebGridFilter();
newFilter.ColumnMember = "ContactName";
newFilter.FilterType = "Like";
newFilter.FilterText = filterText; // Your filter value
WebGrid1.RootTable.FilteredColumns.Add(newFilter);         
WebGrid1.RootTable.UpdateUI();
WebGrid1.Refresh();

For further information about add filter value programmatically, please see in our WebGrid’s documentation, on “How-to: Add and remove Filtered Column programmatically” section.

Hope this helps. Thank you.
Regards,
Hans.

how to kept FilterBar state

rogerchen.tangshuo@gmail.com — Thu, 26 Apr 2012 22:27:48 GMT

I have two page("A" and "B"), one webgrid in "A" page, when user input filter key words into FilterBar then apply Filter, click one row from "A" page to "B" page, when return back to "A" page from "B" page after click "return" button or "save" button, how to kept the FilterBar state in "A" page?

thanks