• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 30. Understanding Universal Data... > Exploring the AddOrder.adp Sample Pr...

Exploring the AddOrder.adp Sample Project

The AddOrders.adp sample project in the \Seua11\Chaptr30 folder of the accompanying CD-ROM demonstrates practical application for this chapter’s example of the programming of ADO objects, methods, and properties. The primary purpose of the AddOrders project is to add a large number of records to the Orders and Order Details tables of a copy of the NorthwindCS SQL Server database. Working with test tables having a large number of rows lets you debug online transaction processing (OLTP) applications with real-world data. The code uses random record numbers to specify the CustomerID for each added order and the ProductID for order line items.


The AddOrders project also lets you compare the performance difference between sending SQL statements to the server and using stored procedures to add, edit, and delete Orders and Order Details records. Code in the frmAddNorthwindOrders Class Module creates the required stored procedures.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint