private void button3_Click(object sender, EventArgs e) { FL_CLASSES.DATA_COLLECTION.SQL = "SELECT c_no AS 'رقم الزبون' ,c_name AS 'اسم الزبون', c_phone AS 'هاتف الزبون' FROM customers"; FL_CLASSES.DATA_COLLECTION.SQL_WHERE = "SELECT c_no AS 'رقم الزبون' ,c_name AS 'اسم الزبون', c_phone AS 'هاتف الزبون' FROM customers WHERE c_name + CONVERT(VARCHAR, c_no) + CONVERT(VARCHAR, c_phone) LIKE "; FRM_ITEMS frm = new FRM_ITEMS(); frm.ShowDialog(); txtNomber.Text = frm.dgvItems.CurrentRow.Cells[0].Value.ToString(); txtName.Text = frm.dgvItems.CurrentRow.Cells[1].Value.ToString(); txtPhone.Text = frm.dgvItems.CurrentRow.Cells[2].Value.ToString(); btn = "update"; }
private void button3_Click(object sender, EventArgs e) { FRM_ITEMS frm = new FRM_ITEMS(); FL_CLASSES.DATA_COLLECTION.SQL = "SELECT no_items as 'رقم صنف' , name_items as 'اسم صنف' , item_price as 'سعر صنف' FROM items"; FL_CLASSES.DATA_COLLECTION.SQL_WHERE = "select no_items as 'رقم صنف' , name_items as 'اسم صنف' , item_price as 'سعر صنف' FROM items WHERE name_items+CONVERT(VARCHAR, no_items) + CONVERT(VARCHAR, item_price) LIKE "; frm.ShowDialog(); txtNomber.Text = frm.dgvItems.CurrentRow.Cells[0].Value.ToString(); txtName.Text = frm.dgvItems.CurrentRow.Cells[1].Value.ToString(); txtPrice.Text = frm.dgvItems.CurrentRow.Cells[2].Value.ToString(); btn = "update"; }