Hi,

 

I am using a gridview control, called DataTable, which is developed with JQuery which populate and provides sorting for ASP.NET gridview. When I export the gridview, I can't export the sorted columns and direction, since the JQuery does that functionality. From the c#, how can I detected the column click and sorted direction? Any help is appreciated.

 

 

        $(document).ready(function () {

            var oResultGrid = $("[id$='gvReportData']");
            if (fixEmptyDataRow(oResultGrid)) {
                var oTable = oResultGrid.dataTable({
                    "bRetrieve": true,
                    "bPaginate": false,
                    "bFilter": false,
                    "bInfo": false

                });
            }
            else {
                oResultGrid.dataTable({
                    "sPaginationType": "full_numbers",
                    "aaSorting": [[0, 'asc']],
                    "sDom": '<"top"lif<"clear">>rt<"bottom"lip<"clear">>',
                    "aoColumns": [
                            { "bSortable": true },
                            { "bSortable": true },
                            { "bSortable": true },
                            { "bSortable": true },
                            { "bSortable": true },
                            { "bSortable": true },
                            { "bSortable": true },
                            { "bSortable": true },
                            { "bSortable": true },
                            { "sType": "date-foia" },
                            { "sType": "date-foia" },
                            { "sType": "date-foia" }
                    ]
                });
            }

 

 

// so far, the following code does not pick up any column header clicks.
            $("#gvReportData th").click(function (event) {
                '<%=ColumnSelectedIndex%>' = 1;

                //alert($(this).index());
                //alert($(this).siblings("td:first").text());
            });

        });