private void btnSelectAll_Click(object sender, EventArgs e)
        {
            DataTable dt = CLASSPRODUCT.SP_PRODECUTSELECT();

            //  dgvproduct.DataSource = dt;//not recommanded here
            dgvproduct.Rows.Clear();
            foreach (DataRow dr in dt.Rows)
            {
                dgvproduct.Rows.Add(dr[0], dr[1], dr[2], dr[3],
                                    dr[4], dr[5], dr[6], dr[7], dr[8], dr[9]);
            }
        }
 public FRM_Search(string _ch)
 {
     InitializeComponent();
     if (_ch == "Supplier")
     {
         //DataTable dt = ClassSupllier.SP_SUPPLIERSELECT();
         //dataGridView1.DataSource = dt;
         this.Text = "بيانات الموردين";
         dataGridView1.DataSource = ClassSupllier.SP_SUPPLIERSELECT();
     }
     else if (_ch == "Product")
     {
         //DataTable dt = ClassSupllier.SP_SUPPLIERSELECT();
         //dataGridView1.DataSource = dt;
         this.Text = "المنتجات";
         dataGridView1.DataSource = CLASSPRODUCT.SP_PRODECUTSELECT();
     }
     else if (_ch == "customer")
     {
         this.Text = "بيانات العملاء";
         dataGridView1.DataSource = CLASS_CUSTOMER.SP_CUSTOMER_DISPLAY();
     }
 }