protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { SqlDataReader DR = new InventoryDAO().getMedicineNames(); while (DR.Read()) { ddlName.Items.Add(DR[0].ToString()); } } }