Click here to Skip to main content
15,886,857 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I received the error:"Unable to cast object of type 'System.Data.DataRow' to type 'System.Data.DataRowView'. "

C#
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);
                }
            }
        }


Any help Most Appreciated
Thanks.
Posted

1 solution

foreach (DataRowView dr in dscrntProd.Rows)

You cannot cast a DataRow into DataRowView.
Try foreach (DataRow dr in dscrntProd.Rows) instead.
 
Share this answer
 
Comments
fjdiewornncalwe 3-Jan-13 13:13pm    
+5.
Abhinav S 3-Jan-13 22:00pm    
Thank you Marcus.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900