private void btnDelete_Click(object sender, EventArgs e)
        {
            int i = CLASSACTIVEMATERIAL.SP_DELETEACTIVEMATERIAL(int.Parse(txtAMID.Text));

            MessageBox.Show("تم حذف المادة بنجاح");
            btnselectall_Click(null, null);
        }
        private void btnUpdate_Click(object sender, EventArgs e)
        {
            int i = CLASSACTIVEMATERIAL.SP_UPDATEACTIVEMATERIAL(int.Parse(txtAMID.Text), txtAMName.Text, txtAMDiscreption.Text);

            MessageBox.Show("تم تعديل البيانات بنجاح");
            btnselectall_Click(null, null);
        }
        private void btnAdd_Click(object sender, EventArgs e)
        {
            if (txtName.Text == string.Empty)
            {
                MessageBox.Show("يجب ادخال اسم المادة الفعالة");
                return;
            }
            int i = CLASSACTIVEMATERIAL.SP_ADDACTIVEMATERIAL(txtName.Text, txtDiscreption.Text);

            MessageBox.Show("تم اضافة عدد " + i + "من المواد الفعالة");
            txtName.Text = txtDiscreption.Text = string.Empty;
        }
        private void btnDisplay_Click(object sender, EventArgs e)
        {
            DataTable dt = CLASSACTIVEMATERIAL.SP_SELECTSEARCHACTIVEMATERIAL(txtsearch.Text);

            dgvActiveMaterial.DataSource = dt;
        }
        private void btnselectall_Click(object sender, EventArgs e)
        {
            DataTable dt = CLASSACTIVEMATERIAL.SP_SELECTALLACTIVEMATERIAL();

            dgvActiveMaterial.DataSource = dt;
        }