Let' s say, there a mvc grid with a dropdown list inside it. The grid has three mode; view edit and add modes, in other words users are able to view, edit, and add records.
The data source of this dropdown list changes dynamically depending on the modes; for example,
if in view mode, the ddl lists item1, item2, item3 item4, and item5,
if in Add mode, the ddl lists item2, item3.
if in Edit mode, the ddl lists item2, item5,
That means the ddl source from different linq queries depending on grid modes.
Is it possible to achieve it? Thanks