string custype = ConfigurationManager.AppSettings["ProducerType"].ToString();
string query = "SELECT CODE ,DESC_E Description FROM S_MASTER WHERE CMP_CODE='A0' and loc_code='01' and DESC_E like '%" + val + "%' and subs_f='" + custype + "' order by 1";