I have a Combobox and grid in a widget. The grid needs to be filtered as the selection in the combobox changes. Currently when the selection changes, the grid reloads, but always displays the same data. Any ideas how to fix this? Or even debug it?
SelectCommand="select customer.plant.PlantID, customer.plant.PlantNo, customer.plant.PlantName, customer.plant.PlantID, cast(customer.plant.PlantID as varchar) + ' - ' + customer.plant.PlantName as PlantNameAndID from customer.plant where plant.CustID = 10 order by plant.PlantNo"></asp:SqlDataSource>