[DavidSimmonsParticipant]

I one column with is an inventory item that may have 2000 items. I am trying to use it with the ComboBox so I can type in part of the value and then select the item. Is there a way to increase performance? When you click the cell that is going to contain the ComboBox, the is a huge delay. I really need this function, PLEASE HELP….

[DavidSimmonsParticipant]

Thanks..

[DavidSimmonsParticipant]

I have a grid that has data but the getrows returns ”

$(“#jqxgrid”).bind(“bindingcomplete”, function (event) {
rows = $(‘#jqxgrid’).jqxGrid(‘getrows’);
alert(rows);
});

Is there a different way to see if there is data?

[DavidSimmonsParticipant]

Sorry, my database value is float with greater than 3 place. If I make the value only 2 place it works correct.

[DavidSimmonsParticipant]

I have tried this many times and can not get height percentage to work. The width percentage works fine.

width: ‘99.9%’,
height: ‘80%’,

[DavidSimmonsParticipant]

I try to recreate my problem with your example here, but was unable to. In my application I have a large data set at the top of the grid the hover and cell select is correct, but as you go to the bottom of the grid the hover and cell select is off or below the actual cell. As you go down to the bottom of a large grid the difference that it is off is greater.

I think it has to do with my height: (WindowHeight-200) method, because if I replace it with a fixed number say height: 600 the problem goes away. I am using this because I wanted the the height to be a percentage of the screen, say 80% which the height method does not take. I would rather use a percentage for the height if there is a way…

Thanks for all you help…

$(document).ready(function () {
var theme = getTheme();
var WindowHeight = (window.outerHeight);

// prepare the data
var data = new Array();
var firstNames =
[
“Andrew”, “Nancy”, “Shelley”, “Regina”, “Yoshi”, “Antoni”, “Mayumi”, “Ian”, “Peter”, “Lars”, “Petra”, “Martin”, “Sven”, “Elio”, “Beate”, “Cheryl”, “Michael”, “Guylene”
];
var lastNames =
[
“Fuller”, “Davolio”, “Burke”, “Murphy”, “Nagase”, “Saavedra”, “Ohno”, “Devling”, “Wilson”, “Peterson”, “Winkler”, “Bein”, “Petersen”, “Rossi”, “Vileid”, “Saylor”, “Bjorn”, “Nodier”
];
var productNames =
[
“Black Tea”, “Green Tea”, “Caffe Espresso”, “Doubleshot Espresso”, “Caffe Latte”, “White Chocolate Mocha”, “Cramel Latte”, “Caffe Americano”, “Cappuccino”, “Espresso Truffle”, “Espresso con Panna”, “Peppermint Mocha Twist”
];
var priceValues =
[
“2.25”, “1.5”, “3.0”, “3.3”, “4.5”, “3.6”, “3.8”, “2.5”, “5.0”, “1.75”, “3.25”, “4.0”
];
for (var i = 0; i < 1000; i++) {
var row = {};
var productindex = Math.floor(Math.random() * productNames.length);
var price = parseFloat(priceValues[productindex]);
var quantity = 1 + Math.round(Math.random() * 10);
row["id"] = i;
row["firstname"] = firstNames[Math.floor(Math.random() * firstNames.length)];
row["lastname"] = lastNames[Math.floor(Math.random() * lastNames.length)];
row["productname"] = productNames[productindex];
row["price"] = price;
row["quantity"] = quantity;
row["total"] = price * quantity;
data[i] = row;
}

var source =
{
localdata: data,
totalrecords: 1000,
datatype: "array"
};

$("#jqxgrid").jqxGrid(
{
theme: theme,
width: '99.9%',
height: (WindowHeight-200),
source: source,
scrollbarsize: 10,
sortable: true,
sorttogglestates: 1,
altrows: true,
virtualmode: false,
pageable: false,
enablehover: true,
columnsresize: true,
editable: true,
selectionmode: "singlecell",
filterable: true,
showfilterrow: true,
statusbarheight: 26,
showstatusbar: true,
columns: [
{ text: 'Id', datafield: 'id', width: 50, pinned: true},
{ text: 'First Name', datafield: 'firstname', width: 100 },
{ text: 'Last Name', datafield: 'lastname', width: 100 },
{ text: 'Product', datafield: 'productname', width: 180 },
{ text: 'Quantity', datafield: 'quantity', width: 80, cellsalign: 'right' },
{ text: 'Unit Price', datafield: 'price', width: 80, cellsalign: 'right', cellsformat: 'c2' },
{ text: 'Total', datafield: 'total', width: 100, cellsalign: 'right', cellsformat: 'c2' },
{ text: '', dataField: '', width: '100%', editable: false, filterable: false }
]
});

$("#jqxgrid").bind('cellvaluechanged', function (event) {
var rowid = args.rowindex;
var column = args.datafield;
var value = args.newvalue;
var oldvalue = args.oldvalue;
var data = new Object();

var id = $('#jqxgrid').jqxGrid('getcellvalue', rowid, "ID");

data.update='true&';
data.id=id;
data.column=column;
data.value=value;

if(value !== oldvalue ){
//do something
}
});
$('#jqxgrid').bind('rowclick', function (event) {
var args = event.args;
var row = args.rowindex;
selectedID = $('#jqxgrid').jqxGrid('getcellvalue', row, "ID");
});
});

[DavidSimmonsParticipant]

Using paging=false the vertical scrollBar works correctly with mouse scroll wheel or in my case the Apple mouse has touch area. But the Horizontal scrollBar does not work. Has anyone tested this. The iPad works correctly

[DavidSimmonsParticipant]

Sorry, did not mean to complain. I love jqwidgets, but just trying to figure out how to accomplish my work. I have most of what I need figured out. Looking at the same web page on the iPad I ran into some issues navigating. If the page is to large you can get to the page up and down or scroll bars. I will try to test for iPad and other mobile devices and resize the page for the correct device and the scroll bar size. They maybe all I need to do.

Thanks for your help…..

[DavidSimmonsParticipant]

In all your demos, you do not show the browser. I feel like there is a lot of documentation missing. I was very surprised that I can not find any youTube videos for any of your products…. Seems like this is a perfect case for some tutorials……

[DavidSimmonsParticipant]

I guess what I am asking using Apple touch pads and Apple mouse with the touch scroll and swipe how can I get this to work. Currently you have click the mouse button and use the mouse to swipe which is not really a swipe action to Apple devices.

[DavidSimmonsParticipant]

Is there any plan to expand the Theme Builder to address all the widget details. Also, have you considered allow the use to select a theme and then modify it with theme builder?

[DavidSimmonsParticipant]

Is there a way to have a customer editor, maybe ajax?

[DavidSimmonsParticipant]

Ok I need to setcellvalue of a alternate column when editing the current column I am editing?

{ text: ‘State’, dataField: ‘State’, width: 150, editable: true, columntype: ‘combobox’,
createeditor: function (row, column, editor) {
editor.jqxComboBox({selectedIndex: 0, source: stateDataAdapter, autoComplete: true, displayMember: “State”, valueMember: “ID”, promptText: “Please Choose:” });

*************************************************************
On select how can I update a different column?
This seem to be the code but does not work here. Is there a different way?
*************************************************************
editor.bind(‘select’, function (event) {
var stateIndex = event.args.index;

//$(“#jqxgrid”).jqxGrid(‘setcellvalue’, row, StateID”, stateIndex);

});

*************************************************************
Then is possible will it produce a cellvaluechanged event on the updated column StateID?
*************************************************************

},
initeditor: function (row, column, editor) {
editor.jqxComboBox(‘selectIndex’, 0);
},
cellvaluechanging: function (row, column, columntype, oldvalue, newvalue) {
if (newvalue == “”) return oldvalue;
}
},

[DavidSimmonsParticipant]

Here is a smale screen shot I hope. Never tried this before…

[DavidSimmonsParticipant]

Here are the jQuery Icons I would like to use with my buttons. Are they available and can they be added to a button in JQWidgets?

http://jquery-ui.googlecode.com/svn/tags/1.6rc5/tests/static/icons.html

[Author]

Posts