select columnA----columnB form Procedure to dropdownlist

  .cs:

ds = null;
ds = MFService.listAllCode("", "000092");
row = ds.Tables[0].NewRow();
row["CODEDESP"] = "Select";                
ds.Tables[0].Rows.InsertAt(row,0);
this.ddl_sourceCode.DataSource = ds;
this.ddl_sourceCode.DataValueField = "CODE";
this.ddl_sourceCode.DataTextField = "CODEDESP";
this.ddl_sourceCode.DataBind();

Procedure:

SELECT   
    code, 
    SUBSTR (cd_desc, 1, 40) cd_desc,
    code || '-----' || cd_desc codedesp
FROM 
    TBMF_CODE_MASTER