This is my controller code to populate the grid:

public virtual JsonResult GetJQGridJsonData(int page, int rows, string search, string sidx, string sord)
        {
            List<Product> jqData = new List<Product>();
            jqData = Repository.GetProducts();

            int pageSize = rows;
            int totalRecords = jqData.Count();

            int totalPages;
            if (totalRecords > 0)
                totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize);
            else
                totalPages = 0;

            // if for some reasons the requested page is greater than the total set the requested page to total page
            if (page > totalPages) page = totalPages;

            //total – Total number of Pages.
            //page – Current page Index.
            //records – Total number of records in the rows group.
            //rows – An array with the data plus an identifier.
            //id – The unique row identifier, needs to be an int from what I have found.
            //cell – An array of the data for the grid.
            var jsonData = new JqGridJsonData
            {

                total = totalPages,
                page = page,
                records = totalRecords,

                rows = jqData.Select(vm =>
                             new JQGridRowJson
                             {
                                 id = vm.ProductId.ToString(),
                                 cell = new[]{

                                                   vm.ProductId.ToString(),
                                                   vm.ProductNumber,
                                                   vm.Size,
                                                   vm.ReleaseDate.ToShortDateString(),
                                                   vm.Amount.ToString(),
                                                   vm.Description,
                                                                                                 
                                }
                             }).ToArray()

            };
            //<a href="http://www.pageresource.com/linkus.htm" /> </a>
            return Json(jsonData, JsonRequestBehavior.AllowGet);
        }

When I click on excel button in the pager, excel is opening but jqgrid data is not exported. I think I am missing something or I am not using this feature correctly.

Could someone help on how to do export to excel (if possible PDF as well).

Your help is greatly appreciated.

Thanks

Miki

 <table id="list2"></table>
<div id="pager2"></div>
<a href="#" id="a1">Get data from selected row</a>

<script type="text/javascript">

    jQuery("#list2").jqGrid({
        url: '/JsonProducts/GetJQGridJsonData/',
        datatype: "json",
        colNames: ['ProductId', 'ProductNumber', 'Size', 'ReleaseDate', 'Amount', 'Description','fileAttached'],
        colModel: [
     { name: 'ProductId', index: 'ProductId', width: 100, sortable: true, sorttype: "int" },
     { name: 'ProductNumber', index: 'ProductNumber', width: 100, sortable: true, sorttype: "text" },
     { name: 'Size', index: 'Size', width: 100, sortable: true, sorttype: "text" },
        { name: 'ReleaseDate', index: 'ReleaseDate', width: 100, datefmt: "mm/dd/yyyy", sorttype: "date", sortable: true },
        { name: 'Amount', index: 'Amount', width: 100, sortable: true, sorttype: "float" },
        {name: 'Description', hidden: true, index: 'Description', width: 100, sortable: false, editable: true, editrules: { edithidden: true} },
        {name: 'fileAttached', index: 'fileAttached', align: "center", width: 40 }
    ],
        rowNum: 20,
        rowList: [10, 20, 30],
        pager: '#pager2',
        sortname: 'ProductId',
        viewrecords: true,
        sortorder: "desc",
        caption: "Products List",
        multiselect: true,
        width: 800,
        height: 600,
       // toppager: true,
        loadonce: true, // to enable sorting on client side
        sortable: true //to enable sorting
    });
    jQuery("#list2").jqGrid('navGrid', '#pager2', { edit: false, add: false, del: false, view: true });
    jQuery("#list2").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: false });

    jQuery("#list2").jqGrid('navButtonAdd', '#pager2', {

        caption: "Export to Excel",

        onClickButton: function () {

            jQuery("#list2").jqGrid('excelExport', { url: '/Export/ExportExcel.xls' });

        }

    });
</script>