dropdownlist inside PQ Grid Pro

[ashishg]

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

[ashishg]

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.

[paramvir]

Please ignore that demo and check this working demo:

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

[ashishg]

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

[paramvir]

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