private void addToOrder(DataRowView drv) { DataRow dr = orderDataTable.NewRow(); dr["ProductID"] = drv["ProductID"]; dr["ProductBarcode"] = drv["ProductBarcode"]; dr["ProductName"] = drv["ProductName"]; dr["SalePrice"] = drv["SalePrice"]; dr["SoldQuantity"] = 1; dr["NotEditable"] = false; try { orderDataTable.Rows.Add(dr); } catch (ConstraintException) { DataRow dr1 = orderDataTable.Rows.Find(drv["ProductID"]); dr1["SoldQuantity"] = Convert.ToInt32(dr1["SoldQuantity"]) + 1; } } private void btnAddToOrder_Click(object sender, RoutedEventArgs e) { // add to order if(txtBarcodeAuto.Text.Length >0) { DataTable dscrntProd = prods.SelCrntProd4Sale(crntProdID);//get data from sql server database for product details(productID, ProductName,ProductPrice) foreach (DataRowView dr in dscrntProd.Rows) { addToOrder(dr); } } }
foreach (DataRowView dr in dscrntProd.Rows)
DataRow
DataRowView
foreach (DataRow dr in dscrntProd.Rows)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)