Hi zxdluck,

Actually, there are some error in in our walkthrough. In your sample, the issue happen because it search for CategoryName column that doesn't exists in your RootTable. Since you set table property for the filter as WebGrid1's root table, WebGrid will return error which said that WebGrid couldn't find the object. I've made you a simple sample regarding Custom Filter in WebGrid. You can look for the code in there. For references, please visit: http://www.intersoftpt.com/Support/WebGrid/KB/All/5/#permalink=Create-a-custom-filter-on-WebGrid.

Hope this helps.

Regards,
Bernard

Hi Bernard,

Thank you very much for your sample, and I ran it ,it executed successfully, and I know, use DataSource control it can work fine. But my doubt is that I didn't use DataSource control to bind the grid,I just use WebGrid1_InitializeLayout and WebGrid1_PrepareDataBinding above,and set the CategoryID valueList in WebGrid1_PrepareDataBinding, just see the attachement in  previous topic, it cause error, so I wonder if it should use datasource control to bind the grid and valuelist,or it may cause error?  the following is my code,Thank you !

 protected void WebGrid1_InitializeDataSource(object sender, ISNet.WebUI.WebGrid.DataSourceEventArgs e)

        {

            e.DataSource = service.GetProducts();

        }

        protected void WebGrid1_PrepareDataBinding(object sender, ISNet.WebUI.WebGrid.DataSourceEventArgs e)

        {

            if (!IsPostBack)

            {

                WebGrid1.RetrieveStructure();

            }

            WebGrid1.RootTable.Columns.GetNamedItem("CategoryID").UseValueListForSorting = ValueListSorting.Yes;

            WebValueList v1 = WebGrid1.RootTable.Columns.GetNamedItem("CategoryID").ValueList;

            if (!v1.IsDataCached())

            {

                DataTable dt = service.GetCategories();

                v1.DataSource = dt;

            }

            //v1.DataMember = "Categories";

            v1.DataTextField = "CategoryName";

            v1.DataValueField = "CategoryID";

        }

        protected void WebGrid1_InitializeLayout(object sender, ISNet.WebUI.WebGrid.LayoutEventArgs e)

        {

            WebGrid1.RootTable.Columns.GetNamedItem("CategoryID").UseValueListForSorting = ValueListSorting.Yes;

            WebValueList v1 = WebGrid1.RootTable.Columns.GetNamedItem("CategoryID").ValueList;

            if (!v1.IsDataCached())

            {

                DataTable dt = service.GetCategories();

                v1.DataSource = dt;

            }

            //v1.DataMember = "Categories";

            v1.DataTextField = "CategoryName";

            v1.DataValueField = "CategoryID";

        }

        protected void WebGrid1_CustomFilter(object sender, FilterEventArgs e)

        {

            WebGridFilter filter;

            filter = e.FilterColumns.GetNamedItem("CategoryName");

            if (filter != null)

                e.FilterColumns.Remove(filter);

            WebGridFilter oldFilter;

            oldFilter = e.FilterColumns.GetNamedItem("CategoryID");

            if (oldFilter != null)

            {

                e.FilterColumns.Remove(oldFilter);

                filter = new WebGridFilter();

                filter.Table = oldFilter.Table;

                // remember to set column member field BEFORE FilterType and FilterText

                filter.ColumnMember = "CategoryName";

                filter.FilterType = oldFilter.FilterType;

                filter.FilterText = oldFilter.FilterText;

                e.FilterColumns.Add(filter);

            }

        }

Hi zxdluck,

I tried to replicate your issue in my local end. But unfortunately, I couldn't replicate the issue in my local end. I have made my sample to programmatically rendered. I attach the sample here. Could you check my sample and please let me know if there's any error in my sample. Look forward to hear any feedback from you so I can help you further.

Regards,
Bernard

Hi Bernard,

Thanks for your sample,and depending on your sample,I just know my error now,thank you very much!

Hi zxdluck,

Glad that you have solved your problem. If you have any further question, please don't hesitate to ask us.

Regards,
Bernard