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());
         }
     }
 }