protected void AddNewDrug_Click(object sender, EventArgs e)
        {
            if (IsValid)
            {
                TableAddDrug.Visible = false;
                String name = DrugName.Text;
                int gender = Convert.ToInt32(GenderDrop.SelectedValue);
                String address = Unit.Text;
                DateTime dob = DateTime.Parse(Price.Text);

                var drug = new Patient() { Name = name, Gender = gender, Address = address, DoB = dob};
                DataBaseAllDataContext dataAll = new DataBaseAllDataContext();
                dataAll.Patients.InsertOnSubmit(drug);
                dataAll.SubmitChanges();

                ViewState["state"] = "load";
                GridDrug.DataBind();
                TableAddDrug.Visible = false;
                GridDrug.Visible = true;
            }
        }
 partial void UpdatePatient(Patient instance);
 partial void DeletePatient(Patient instance);
 partial void InsertPatient(Patient instance);