Loading a Dropdown using a stored procedure

Hi,   I am trying populate a dropdown list on a webpage by using a store procedure. Basically …