Start Building Professional
Web Apps Today

Grid control evalution

Hello,

 

We have completed our evaluation for Tree control and it is able to support all of our requirement. We need to take the decision to either purchase single tree control or to go with complete suite as we are also interested in the grid control provided by DhtmlX. We have already started evaluating the grid control and if you can provide a simple example with the functionality mentioned below, that will expedite the process of purchasing the complete suite.

 

1.       Grid should be with big JSON data set(50,000 records, all data will come at once and no subsequent calls to server while paging or searching)

2.       Search by all fields with a single text box above the grid(Client side)

3.       Search boxes should be in Column headers(Client side)

4.       Paging(Client side)

5.       Need to call a function when clicking on row

 

All the searching and paging operations should be perform in client side.

 

*Note: We are very pleased with the support response time we got during tree evaluation for our questions.

 

Please let me know if any questions.

 

Thanks,

RamaRao R.

 

 

1. You can load grid from JSON format. Please find example here http://www.dhtmlx.com/docs/products/dhtmlxGrid/samples/12_initialization_loading/09_init_grid_json.html
and tutorials here http://dhtmlx.com/dhxdocs/doku.php?id=dhtmlxgrid:data_loading#loading_data_from_json
http://dhtmlx.com/dhxdocs/doku.php?id=dhtmlxgrid:syntax_templates#json_format_details
To increase loading performance you can use paging, dynamic or static smart rendering mode, distributed parsing:
http://dhtmlx.com/dhxdocs/doku.php?id=dhtmlxgrid:toc#big_datasets_loading
But loading of 50 000 rows at once is really time-consuming task. In such case better to use dynamic smart rendering mode. In such case only those row are loaded which should be rendered. Please find tutorial here http://dhtmlx.com/dhxdocs/doku.php?id=dhtmlxgrid:toc_dhtmlxgrid_step_by_step
2. dhtmlxGrid doesn't have such inbuilt functionality. But you can create any custom search rule as you need. Please find tutorial here http://dhtmlx.com/dhxdocs/doku.php?id=dhtmlxgrid:filtering
3. dhtmlxGrid has inbuilt filters which you can place to the header. Please find example here http://www.dhtmlx.com/docs/products/dhtmlxGrid/samples/08_filtering/05_pro_filter_srnd.html
4. To call function on row select you can use "onRowSelect" event:
 mygrid.attachEvent("onRowSelect", function(id,ind){
//any custom code here
});
You can find list of all available events here http://dhtmlx.com/dhxdocs/doku.php?id=dhtmlxgrid:events
http://dhtmlx.com/dhxdocs/doku.php?id=dhtmlxgrid:attaching_custom_code_to_events