tailieunhanh - Pro .NET 2.0 Extreme Programming 2006 phần 9

Tham khảo tài liệu 'pro .net extreme programming 2006 phần 9', công nghệ thông tin, kỹ thuật lập trình phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | CHAPTER 15 SECOND ITERATION 253 OdbcCommand dataCommand new OdbcCommand dataConnection Build command string StringBuilder commandText new StringBuilder DELETE FROM Orders Details WHERE OrdersID orderID and ProductID productID int rows Make sure that the DELETE worked 1 rows Unexpected Orders Details row count gasp lineItem null catch Exception e Orders Details database error Listing 15-10. File region Using derectives using System using using using using using BusinessLayer endregion namespace DataLayer public class OrderDetailData public OrderDetailData 254 CHAPTER 15 SECOND ITERATION public static int InsertLineItem int orderID Lineitem lineitem int rows -1 try Product product OdbcConnection dataConnection new OdbcConnection OdbcCommand dataCommand new OdbcCommand dataConnection Build command string StringBuilder commandText new StringBuilder INSERT INTO Orders Details OrdersiD ProductID UnitPrice Quantity Discount VALUES orderID o rows catch Exception e CHAPTER 15 SECOND ITERATION 255 return rows Listing 15-11. File region Using directives using System using .