| 
                                                                            
                                                                                joe@jmawebtechnologies.com
                                                                            - 
                                                                                8/8/2011 1:55:31 PM
                                                                            
                                                                         
                                                                        RE:get orderitem by orderid 
                                                                            Hi,
 Try this:
 
 DataSet dsQ = OrderItemInfoProvider.GetOrderItems(String.Format("OrderItemOrderID = '{0}'", order.OrderID), "OrderItemOrderID ASC", 1000, "OrderItemOrderID, OrderItemID, OrderItemSKUID, OrderItemUnitCount, OrderItemUnitPrice");
 
 DataRowCollection drC = dsQ.Tables[0].Rows;
 
 //Loop through each product
 foreach (DataRow d in drC)
 {
 SKUInfo sk = SKUInfoProvider.GetSKUInfo(int.Parse(d["OrderItemSKUID"].ToString()));
 //Custom Code
 }
 
                                                                            
                                                                         
 
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                         |