protected void Fetch_Click(object sender, EventArgs e) { string name = ddlName.SelectedValue.ToString(); DataSet D = new MedicineDAO().getMedicineInfo(name); tbID.Text = D.Tables[0].Rows[0]["ID"].ToString(); tbQuantity.Text = D.Tables[0].Rows[0]["Quantity"].ToString(); tbPrice.Text = D.Tables[0].Rows[0]["Price"].ToString(); tbSupplier.Text = D.Tables[0].Rows[0]["Supplier"].ToString(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { SqlDataReader DR = new MedicineDAO().getMedicineNames(); while (DR.Read()) { ddlName.Items.Add(DR[0].ToString()); } } }