Dynamically Loading Data on User Inputs

[prasminParticipant]

Hi Dear Peter,

I am new to jqxgrid, but looking at the simplicity I have learned how easy it is to implement. However, I am currently stuck on the problem and not able to get solution for it.

I am implemented a form where by there would be two select list and one button on the form along with the the grid. the functionality is as below:

1. A user selects a option from Select1 and then a option form Select2. After selecting option respective list, he clicks on the button.
2. Now on the basis of the options selected, I have to display the data in the grid.
For Eg if users Select Para1 and Cy1 in Select1 and Select2 and then clicks button I have to display the grid with data of query
“Select * from ” . Para1 . “Table where Cy=” . Cy1 . ” Order by Field1, Field2, Field3″;
3. Currently when a button is clicked nothing happens.
4. Every row and columns would be having a value and that would be hyper-link point to specific operation. (Something like Zoom view where by clicking of items of table would show particular data on basis of the clicked)

Can you please help me.

Regards.

Paso Meh.

[DimitarParticipant]

Hello Paso Meh,

You can find out more about binding jqxGrid to SQL in the documentation – Bind jqxGrid to SQL Database using ASP.NET MVC3.

To make the cell values hyperlinks, the following demo might be helpful: Custom Column.

Best Regards,
Dimitar

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

[prasminParticipant]

Dear Dimitar,

I am looking for the PHP Side solution with HTML. So please give me PHP Side solution.

Regards.

Paso Meh

[DimitarParticipant]

Hi Paso Meh,

In that case, please check out the documentation on this matter – Bind jQuery Grid to MySql Database using PHP and the subsequent entries in that section.

The demo Binding to JSON using PHP may also be of help.

Best Regards,
Dimitar

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

[prasminParticipant]

Thanks for your guidance. I have some query related to the grid that are as listed below:

1. How Can a particular Row back color be defined via scripting to highlight the Row.
2. How Can a particular Cell’s back color be defined via scripting to highlight the Row.
3. How Can a Keyboard key for viz. “Enter”, “Control + M”, “Alt + M”, “Shift + M”, “P” bound to grid like mouse double click.

I am very new to this grid, but I think the learning curse is very easy and the grid could be implemented. Now I am seeking for the functionality that I did implement in our other projects with different grids every time. I think if all this functionality is available in one grid that it would be best to master one grid only.

Regards.

Paso Meh.

[DimitarParticipant]

Hi Paso Meh,

1. and 2. Use cellsrenderer to give cells the look you want. Find out more about Grid Cells Rendering.

3. Custom keyboard navigation will be available in jQWidget’s upcoming version (2.5).

For a look at all the current features of jqxGrid, we recommend the online demos.

Best Regards,
Dimitar

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

[Author]

Posts