[Akhil_MenonParticipant]

Hello,

I figured it out. My jQuery selector was referencing the wrong grid.

Thanks

[Akhil_MenonParticipant]

PS: rowIndex functionality was tested by commenting the code of rowName. if the code for rowName is copied under rowIndex, then rowIndex works the way it should and then appears to ignore the rowName code

[Akhil_MenonParticipant]

Hello Peter,

I tried binding the grid in my AJAX function like so –

$(document).ready(function () {

            

            var dataViewer = $('#box2');
            

            $.ajax({
                type: "GET",
                dataType: "json",
                cache: false,
                async: true,
                url: 'GetSupportLogTableProxy.asmx/GetAllSupportLogTableRecordsProxy',
                success: function (data) {
                    // prepare the data
                    var source =
                    {
                        type: "GET",
                        datatype: "json",
                        datafields: [
                            { name: 'desc_counter' },
                            { name: 'Ticket_Id' },
                            { name: 'Date_of_entry' },
                            { name: 'Datetime' },
                            { name: 'Project_Id' },
                            { name: 'Source_of_entry' },
                            { name: 'Client_Name' },
                            { name: 'HandledBy' },
                            { name: 'Area_of_system' },
                            { name: 'Description_of_problem' },
                            { name: 'Resolution_of_problem' },
                            { name: 'Attachments' },
                            { name: 'Final_status' },
                            { name: 'Assisted_By' },
                            { name: 'DD_number' },
                            { name: 'Report_Date' },
                            { name: 'Assigned_To' },
                            { name: 'UpdatedDatetime' },
                            { name: 'Projected_date' },
                            { name: 'Sub_System' },
                            { name: 'Assigned_To_Rec' },
                            { name: 'HandledBy_Rec' },
                            { name: 'Assigned_ToUG' },
                            { name: 'Priority_Level' }
                        ],
                        id: 'desc_counter',
                        url: "GetSupportLogTableProxy.asmx/GetAllSupportLogTableRecordsProxy",
                        cache: false
                    };

                    var dataAdapter = new $.jqx.dataAdapter(source)

                    $("#grid").jqxGrid(
                        {
                            source: dataAdapter,
                            columnsresize: true,
                            localdata: data,
                            columns: [
                                { text: 'Description Counter', datafield: 'desc_counter' },
                                { text: 'Ticket ID', datafield: 'Ticket_Id' },
                                { text: 'Date of Entry', datafield: 'Date_of_entry' },
                                { text: 'Date Time', datafield: 'Datetime' },
                                { text: 'Project ID', datafield: 'Project_Id' },
                                { text: 'Source of Entry', datafield: 'Source_of_entry' },
                                { text: 'Client Name', datafield: 'Client_Name' },
                                { text: 'Handled By', datafield: 'HandledBy' },
                                { text: 'Area of System', datafield: 'Area_of_system' },
                                { text: 'Description of Problem', datafield: 'Description_of_problem' },
                                { text: 'Resolution of Problem', datafield: 'Resolution_of_problem' },
                                { text: 'Attachments', datafield: 'Attachments' },
                                { text: 'Final Status', datafield: 'Final_status' },
                                { text: 'Assisted By', datafield: 'Assisted_By' },
                                { text: 'DD Number', datafield: 'DD_number' },
                                { text: 'Report Date', datafield: 'Report_Date' },
                                { text: 'Assigned To', datafield: 'Assigned_To' },
                                { text: 'Updated DateTime', datafield: 'UpdatedDatetime' },
                                { text: 'Projected Date', datafield: 'Projected_date' },
                                { text: 'Sub System', datafield: 'Sub_System' },
                                { text: 'Assigned to Rec', datafield: 'Assigned_To_Rec' },
                                { text: 'Handled by Rec', datafield: 'HandledBy_Rec' },
                                { text: 'Assigned to UG', datafield: 'Assigned_ToUG' },
                                { text: 'Priority Level', datafield: 'Priority_Level' },
                            ]
                        });
                },
                error: function (error) {
                    dataViewer.html(JSON.stringify(error));
                }
            });
        });

The result is the JSON string from the Web Service. It didn’t bind to the columns of the grid. Could you please point out the corrections I need to make to the code? Could you also help me out with resources that I can use to test out the dataAdapter loadComplete and downloadComplete functionality?

Regards,
Akhil

[Author]

Posts