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