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";
}
