Blank rows without data after 400 rows

[zack.wdParticipant]

My grid which has about 700 rows,shows blank rows after 400 rows of data .I have not paginated the grid and if i do paginate it,I get all the data and if i dont,it shows only blank rows after 400 rows.Why is that happening?

[Peter StoevKeymaster]

Hi zack.wd,

May be you have enabled virtual mode and the totalrecords number is wrong. If you provide a sample, may be we would be able to look at it.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[zack.wdParticipant]

This is my code :

var theme = getTheme();

            var source =
            {
                datatype: "json",
                datafields: [
                    { name: 'reelno' },
                    { name: 'width' },
                    { name: 'gsm'},
                    { name: 'type' },
                    { name: 'weight' }
                ],

                url: '<?php echo base_url()."index.php/inventory/reelgriddata/".$gino; ?>'
            };

            var dataAdapter = new $.jqx.dataAdapter(source, {
                downloadComplete: function (data, status, xhr) { },
                loadComplete: function (data) {
                            var sum=0;
                            var reelnos = new Array();
                            var widths = new Array();
                            var gsms = new Array();
                            var types = new Array();
                            var weights = new Array();

                            var rows2=$('#jqxgrid2').jqxGrid('getrows');
                             //This is to calculate the sum of weight column and show it in the total text box
                             for (var m2 = 0; m2 < rows2.length; m2++)
							 {

                            var weight = $('#jqxgrid').jqxGrid('getcellvalue', rows2[m2], "weight");
                            sum = parseFloat(sum) + parseFloat(weight);

                            //to store the data to the grid in the hidden textbox when the reelgrid is opened
                            var reelno = $('#jqxgrid').jqxGrid('getcellvalue', rows2[m2], "reelno");
							var width = $('#jqxgrid').jqxGrid('getcellvalue', rows2[m2], "width");
							var gsm = $('#jqxgrid').jqxGrid('getcellvalue', rows2[m2], "gsm");
							var type = $('#jqxgrid').jqxGrid('getcellvalue', rows2[m2], "type");
							var weight = $('#jqxgrid').jqxGrid('getcellvalue', rows2[m2], "weight");
							reelnos[reelnos.length] = reelno;
							widths[widths.length] = width;
							gsms[gsms.length] = gsm;
							types[types.length] = type;
							weights[weights.length] = weight;
                    }
                        $('#weighttotal').val(sum);
                        reelnos = JSON.stringify(reelnos);
						widths = JSON.stringify(widths);
						gsms=JSON.stringify(gsms);
						types=JSON.stringify(types);
						weights=JSON.stringify(weights);
						var gridrows = $('#jqxgrid2').jqxGrid('getrows');

						document.getElementById("reelno2").value=reelnos;
						document.getElementById("width2").value=widths;
						document.getElementById("gsm2").value=gsms;
						document.getElementById("type2").value=types;
						document.getElementById("weight2").value=weights;
						document.getElementById("count2").value=gridrows.length;

                                                },
                loadError: function (xhr, status, error) { }
            });

            // initialize jqxGrid
            $("#jqxgrid2").jqxGrid(
            {
                width:740,
                source:dataAdapter,
                theme: theme,
                height:30,
                autoheight: true,
                sortable: true,
                altrows: true,
               // pageable:true,
             //   enabletooltips: true,
               // editable: true,

                columns: [
                  { text: 'Reel no', datafield: 'reelno', width: 124 },
                  { text: 'Width', datafield: 'width', width: 128 },
                  { text: 'GSM', datafield: 'gsm', cellsalign: 'left', width: 128 },
                  { text: 'Type', datafield: 'type', cellsalign: 'left', width: 128 },
                  { text: 'Weight',  datafield: 'weight', width: 128, cellsalign: 'right' },
				  { text: '       ', columntype: 'button',value:'delete', datafield: 'delete', cellsrenderer: function () {

					 return "Delete";

					 }, buttonclick: function (row) {

                        var selectedrowindex = $("#jqxgrid2").jqxGrid('getselectedrowindex');
                        var newweight        = $('#jqxgrid2').jqxGrid('getcellvalue', selectedrowindex, "weight");
                        var wtot             =document.getElementById("weighttotal").value;
                        var newwtotal        =parseFloat(wtot)-parseFloat(newweight);
                        document.getElementById("weighttotal").value =newwtotal;
                        var selectedrowindex2 = $("#jqxgrid2").jqxGrid('getselectedrowindex');
                        var id2               = $("#jqxgrid2").jqxGrid('getrowid', selectedrowindex2);
                        $("#jqxgrid2").jqxGrid('deleterow', id2);
                        var reelnos           = new Array();
                        var widths            = new Array();
                        var gsms              = new Array();
                        var types             = new Array();
                        var weights           = new Array();
                        var rows2             =$('#jqxgrid2').jqxGrid('getrows');

                        for (var m2 = 0; m2 < rows2.length; m2++){
                            var reelno = $('#jqxgrid').jqxGrid('getcellvalue', rows2[m2], "reelno");
							var width = $('#jqxgrid').jqxGrid('getcellvalue', rows2[m2], "width");
							var gsm = $('#jqxgrid').jqxGrid('getcellvalue', rows2[m2], "gsm");
							var type = $('#jqxgrid').jqxGrid('getcellvalue', rows2[m2], "type");
							var weight = $('#jqxgrid').jqxGrid('getcellvalue', rows2[m2], "weight");
							reelnos[reelnos.length] = reelno;
							widths[widths.length] = width;
							gsms[gsms.length] = gsm;
							types[types.length] = type;
                            weights[weights.length] = weight;
						}

                        reelnos = JSON.stringify(reelnos);
						widths = JSON.stringify(widths);
						gsms=JSON.stringify(gsms);
						types=JSON.stringify(types);
						weights=JSON.stringify(weights);
						var gridrows = $('#jqxgrid2').jqxGrid('getrows');

						document.getElementById("reelno2").value=reelnos;
						document.getElementById("width2").value=widths;
						document.getElementById("gsm2").value=gsms;
						document.getElementById("type2").value=types;
						document.getElementById("weight2").value=weights;
						document.getElementById("count2").value=gridrows.length;

					}},
                ]
            });
        });

[Peter StoevKeymaster]

Hi zack.wd,

I would suggest you to check what your server returns as data. If it returns 700 rows, the Grid will display them, but it may also return 400 rows with 300 blank rows.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[zack.wdParticipant]

Hi Peter,
Server data is correct since all data is shown when i change the pageable to true for the grid.

[Author]

Posts