In my datagrid I have a dropdownlist that appears when the user is editing an item. I populate this ddl with values from a table. When a user clicks on a value in this ddl, I need to use the value in a lookup for another table and return fields to populate another ddl on the grid.
An example would be like having one ddl populated with the names of states. When a user picks a state, I would execute a SQL statement like "select city where state='TX'" and use this dataset to populate a ddl right next to the one for the state.
Is this possible?
An example would be like having one ddl populated with the names of states. When a user picks a state, I would execute a SQL statement like "select city where state='TX'" and use this dataset to populate a ddl right next to the one for the state.
Is this possible?