Grouping in SPGridView

 spgv = new SPGridView();
            spgv.AutoGenerateColumns = false;
            spgv.RowEditing += new GridViewEditEventHandler(spgv_RowEditing);
            spgv.RowCancelingEdit += new GridViewCancelEditEventHandler(spgv_RowCancelingEdit);
            spgv.RowUpdating += new GridViewUpdateEventHandler(spgv_RowUpdating);
            spgv.RowUpdated += new GridViewUpdatedEventHandler(spgv_RowUpdated);
            spgv.AutoGenerateEditButton = true;
            spgv.AllowGrouping = true;
            spgv.AllowGroupCollapse = true;
            spgv.GroupField = "category";
            spgv.GroupDescriptionField = "category";
            spgv.GroupFieldDisplayName = "Category";

            this.Controls.Add(spgv);

SPGridView grouping not working with sorting or paging

After several tests, I found that if you disable the ViewState of the SPGridView the storing or paging  will work.

           

 gridViewResult = newSPGridView();

            gridViewResult.ID = "gridViewResult";

            gridViewResult.DataSourceID = dataSource.ID;

            gridViewResult.AutoGenerateColumns = false;

gridViewResult.EnableViewState = false;

//paging

            gridViewResult.AllowPaging = true;

            gridViewResult.PageSize = 3;

Cheers

 

 

How to display rowcount with Grouping SPGridview

 <script src="\_layouts\jquery-1.4.2.min.js" type="text/javascript"></script> 

<script type="text/javascript"> 

 $(document).ready(function() {

   $(".ms-gb").each(function()

   {

            var rowNums=$(this).nextUntil(".ms-gb").length;

     $(this).children(0).append("("+rowNums+")");

             $(this).children(0).children(0).trigger("onclick");

   });

 });

</script>