ParamQuery grid support forum

General Category => ParamQuery Pro Evaluation Support => Topic started by: ashishg on November 14, 2019, 06:52:00 pm

Title: dropdownlist inside PQ Grid Pro
Post by: ashishg on November 14, 2019, 06:52:00 pm
Hi,

Trying to find a working example on the subject with:
ASPnetMVC --> loading ProductName dropdown list inside PQGrid Pro, displaying ProductName to the User and saving ProductId for DB layer using Ajax.

Thanks
Title: Re: dropdownlist inside PQ Grid Pro
Post by: ashishg on November 15, 2019, 11:26:03 am
Example not working for the Response :- "assign values to column.editor.options in $.ajax success callback"

https://paramquery.com/pro/demos/editing_custom2

Specially looking for Column "Shipping Via" which should be filled by Ajax call.

Title: Re: dropdownlist inside PQ Grid Pro
Post by: paramvir on November 15, 2019, 06:45:34 pm
Please ignore that demo and check this working demo:

https://paramquery.com/pro/demos/edit_select
Title: Re: dropdownlist inside PQ Grid Pro
Post by: ashishg on November 15, 2019, 08:45:36 pm
Thanks a lot ParamVir for the syntax help.

In my case ShipViaId is already part of feed to load the PQgrid itself.

i.e. suppose https://paramquery.com/content/invoice.json ...... Contains ShipViaId column value;

At server-side I am joining MasterShipVia to get "ShipVia" name in result-set to display text instead of Id.

Now I want to make this column as Drop-down-list so that User can select a different place.

Please suggest a way in this scenario.

Thanks,
Ashish
Title: Re: dropdownlist inside PQ Grid Pro
Post by: paramvir on November 18, 2019, 04:04:12 pm
Quote
In my case ShipViaId is already part of feed to load the PQgrid itself.

getData() method can be used to extract subset of data from main data in grid.

https://paramquery.com/pro/api#method-getData