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;

                var drug = new User() { UserAcc = name, Role = gender, Password = address};
                DataBaseAllDataContext dataAll = new DataBaseAllDataContext();
                dataAll.Users.InsertOnSubmit(drug);
                dataAll.SubmitChanges();

                ViewState["state"] = "load";
                GridDrug.DataBind();
                TableAddDrug.Visible = false;
                GridDrug.Visible = true;
            }
        }
 partial void UpdateUser(User instance);
 partial void DeleteUser(User instance);
 partial void InsertUser(User instance);