private void LoadPlantcode1() { try { SqlDataReader dr = null; dr = Bllusers.LoadPlantcode1(cmpcode.ToString(), pcode); if (dr.HasRows) { while (dr.Read()) { ddl_Plantcode.Items.Add(dr["Plant_Code"].ToString()); ddl_Plantname.Items.Add(dr["Plant_Code"].ToString() + "_" + dr["Plant_Name"].ToString()); } } } catch (Exception ex) { WebMsgBox.Show(ex.ToString()); } }