SharePoint - Enable Filtering for Multiple SPGridView Control on same page

Hello Everyone, I have seen people implementing the SPGridView in their project/Webpart. When we try to use this webpart multiple times on same page the filtering does not work on multiple Grids correctly.

Let’s see how we can fix this.

The most essential part is referring aspgridview.js file in your control.

This js file helps us to run the Filter functionality.

The file has all the java script function which helps us to display the filtering actions. The ASPGrid view has one bug, if you try to add two SPGridView control on same page. The control starts misbehaving on filtering front. This happens since client id is not passed correctly to java script.

To resolve this I searched on net and found lot of people talking about the root cause of the problem and solution. But no one has solution which is generalized and will work for your grid filter column.

All the examples have shown how to fix it for individual column only.

-----------------------------------------------------------------------------

Here is code snippet which you need to add in your Web Part and call this method in Pre_Render method of your web part after binding grid view.

ColIndex refer to the index of the Column header which helps to apply filter menu.

protected void overrideFilterMenus(SPGridView SPGridViewObject)         {             int colIndex = 0;             foreach (string strFilterColumn in SPGridViewObject.FilterDataFields.Split(','))             {                 if (!string.IsNullOrEmpty(strFilterColumn))                 {                     if (SPGridViewObject.HeaderRow.Controls[colIndex].Controls[0].GetType().Equals(typeof(Microsoft.SharePoint.WebControls.Menu)))                     {                         ((Microsoft.SharePoint.WebControls.Menu)SPGridViewObject.HeaderRow.Controls[colIndex].Controls[0]).ClientOnClickPreMenuOpen =                           "SPGridView_FilterPreMenuOpen('" +                           SPGridViewObject.ClientID + "','" + SPGridViewObject.ClientID +                           "_SPGridViewFilterMenuTemplate', '%MENUCLIENTID%', '" + strFilterColumn + "', event);" +                           " MMU_Open(byid('" + SPGridViewObject.ClientID + "_SPGridViewFilterMenuTemplate')," +                           " MMU_GetMenuFromClientId('%MENUCLIENTID%'),event,true,null,0); return;";                     }                 }                 colIndex++;             }         }

SharePoint 2010 Style Paging in SPGridview using SPGridViewPager

Hi,

We have seen lot of examples which explains how to implement paging for your SPGridView.

The implementation is pretty much simple. you need to set PagerTemplate  property to Null and rest Microsoft will do for you. The System automatically gives you the paging style of 1,2,3......... you need to write pagination events. But most of the time clients demands the same look and feel as of SharePoint where you need to show pagination in SharePoint OOTB Style.

Microsoft has provided SPGridViewPager control which allows us to display the paging as per the SharePoint OOTB Style. We just need to provide the GridView ID. This control added on the form where your SPGridView is added separately.

Note: If you are using SPGridViewPager control, then do not set PagerTemplate Property to Null which coding.

Rest if you like to change the look and feel of Pagination, you can easily extend your new class from SPGRidViewPager Class and use it.

Cool!!!!