[supun151515Participant]

Hi Peter. Thank you very much for your answer. Now I got your point and it is working perfect. I really apologize for any inconvenience.

Thank you,
Supun Silva

[supun151515Participant]

Dear Mr.Peter,
I am still waiting to get answer. Hope you will reply me soon.
Thank you,
Supun Silva

[supun151515Participant]

You can see the example below and try pressing button for few times.
http://jsfiddle.net/74CTB/122/

[supun151515Participant]

Hi Mr.Peter,
Could you please explain me, how to unbind and bind the event again. I tried to put the event outside the function, but it didn’t work. result is same as before. it gives increase alert boxes for every functin call.

thank you.
Supun Silva

[supun151515Participant]

Hello MR.Peter,
Thank you for your reply. I understand what you said. But when I call GetData() function, its reloading the grid with data.

I want to get massage when the data loads to the grid. I used below code;

$('#grid').on('initialized', function () { alert("data loaded"); });

Above event works on one time, when I recall the function GetData() it doesn’t work.

$("#grid").on("bindingcomplete", function (event) { alert("data loaded"); });
Above event returns (+). it means. Whwn I recall the function, it returns the event two times. If I call the GetData() function again, it returns the event for three times.

Hope you understand my problem. I do want to get alert when data loads.

Thank You,
Supun Silva

[supun151515Participant]

Hi Dimitar,
I tried to understand your cell rendering example. But it is realy complecated because it has for loop only till 100. What will happan if grid has more than 100 records?
Could you please kindly explain me, how to insert cell rendering to below code;

var source =
{
datatype: “json”,
datafields:
[ { name: 'auto_no' , type: 'number'},
{ name: 'job_date', type: 'date' },
{ name: 'time_from', type: 'time' }
],
id: ‘id’,
url: data
};

jQuery(“#grid”).jqxGrid(
{
width: 635,
height: 250,
source: adapter,
theme: theme,
groupable: true,
filterable: true,
columnsresize: true,
sortable: true,
autoheight: false,
columnsreorder: true,
showfilterrow: true,
ready: function () {
},
autoshowfiltericon: true,
columns: [
{ text: 'Job No.', datafield: 'job_no', width: 50, cellsalign: 'center' },
{ text: 'Job Date', datafield: 'job_date', cellsformat: 'yyyy-MM-dd', width: 95, cellsalign: 'center' },
{ text: 'Time From', datafield: 'time_from', cellsformat: 'H:mm', width: 85, cellsalign: 'left' },
]

});

[supun151515Participant]

Hello Dimitar,
Sorry for disturbing you again. h:mm tt format works only on mysql date. but I use mysql time field.
My json data as below;
[{“0″:”454545″,”client_id”:”454545″,”1″:”28″,”auto_no”:”28″,”2″:”1″,”job_no”:”1″,”3″:”1\/S”,”emp_no”:”1\/S”,”4″:”2014-05-18″,”job_date”:”2014-05-18″,”5″:“14:25:00″,”time_from”:”14:25:00″,“6”:”17:00:00″
Thank you,
Supun Silva

[supun151515Participant]

Dear Dimitar,
Thanks for your quick reply. But still I get 24hrs. I need it in 12hrs(AM/PM).
Please note: in my MySql database column format is ”Time’.

Thank You,
Supun Silva

[supun151515Participant]

Thank you for your great and quick reply

[supun151515Participant]

Hi.. Thanks for your reply. I did not get any value. It is not receiving any value. only i get object Object. Kindly help me to get label, value for each item.

Thank you,
Supun Silva

[supun151515Participant]

Thanks for your quick reply. Is there anyway I can display 2 columns in one dropDownList while keeping one column as a ValueMember?

My other problem is,
I have tried to get $(“#combo_project_list_body”).jqxDropDownList(‘getItems’);
But it retrieved values [object Object],[object Object],[object Object]
I want to get Item count and values in a array.

Below is my code;

$(“#testbtn”).on(“click”, function(){
var project_list = $(“#combo_project_list_body”).jqxDropDownList(‘getItems’);
alert(project_list);

});

I have three records in database;
this is my jquery;

$(document).ready(function () {
var theme = “”;
var url = “../jquery/php/combo_project_list.php”;
// prepare the data
var source =
{
datatype: “json”,
datafields: [
{ name: ‘p_no’ },
{ name: ‘p_name’},
{ name: ‘client_id’},
{ name: ‘reg_date’},
{ name: ‘end_date’}

],
url: url,
async: false
};
var dataAdapter = new $.jqx.dataAdapter(source);
// Create a jqxDropDownList
$(“#combo_project_list_head”).jqxDropDownList({
selectedIndex: 0, source: dataAdapter, displayMember: “p_no”, valueMember: “p_no”, width: 100, height: 18, theme: theme
});
$(“#combo_project_list_head”).jqxDropDownList({ autoDropDownHeight: true });
});

and PHP as below;

[Author]

Posts