How do I display a value that was selected in a dropdownlist to also appear in gridView?
I have an Indoo grid that is currently displaying all products stored in a SQL Server table. Above the grid, I have a dropdownlist that displays 3 choices: All, Commercial, Residential. When Commercial is selected from the dropdownlist, the grid is refreshed, displaying only commercial products. When Residential is selected, the grid is refreshed again, displaying only residential products.
I want the selected value (in the dropdownlist) to also appear as a column in the grid. How do I do that? When I select Commercial, from the dropdownlist, for example, how do I get this selected value to appear in the grid, along side of the other colums that are already appearing in the grid?
PS - I do not wish to add these values (commercial and residential) to the SQL Server table.