I have 2 dd lists and populate via a web service. And write the selected values to a SQL table. Which works fine.
The issue is when I read from the SQL table and want to populate the dd list with the corresponding text value. the SelectedValue of the dd list is not working in the page load.
I have unique values stored in the xml (which the web services uses) for the 2dn ddl and
store the integer on the table rather than the text which is displayed in 2nd ddlist.
Do I need to store both the dd list 1 and dd list values in sql and then create a web service function that will pre populate the the 2 dd lists based on my table values? Or am I on the wrong track?
I looked at the EE question/solutions but did not find any ideas. C# if possible but will take anything!