Thực hiện một lưu ý của các vị trí cụ thể mà nó được đặt, như sản lượng . Bạn cũng có thể sử dụng n-chuyển sang làm một chạy khô. Tại thời điểm Khởi tạo một thể hiện mới của các thành phần logic kinh doanh sử dụng objGroups | Stored Procedures and Views for SQL Server and Oracle AS BEGIN DELETE FROM GroupProjects WHERE GroupID inGroupID END At this point you have all of the views and stored procedures needed to insert display and delete group projects in your Time Tracker application. All that is left to do is to modify your application to implement these views and stored procedures. In the next Try It Out you implement the code to select data from the vw_SelectGroupProjects view to display all projects for a specific group. You also implement the code to insert update and delete group projects in the GroupProjects table. In addition you implement drag-and-drop functionality into your application. A complete list of available projects will be displayed in one ListBox control from which you drag the projects and drop them into another ListBox to be added to a group. Try It Out Implementing Views and Stored Procedures in VB 2005 To implement this functionality 1. Open your Time Tracker project in Visual Studio 2005 and view the code for the Admin form. 2. Add the following variable declarations at the top of your form class Private blnLoading As Boolean Private objGroupsDS As DataSet Private objProjectsDS As DataSet Private objGroupProjectsDS As DataSet 3. Edit the ActionAdd procedure and add the following code to the Case Group Projects statement SQL Server and Oracle Case Group Projects Turn the loading flag on so no items are processed blnLoading True Delete any previous projects Call ActionDelete Turn the loading flag off blnLoading False Set the SQL string usp_InsertGroupProject Open the database connection Initialize the Command object For intIndex 0 To _ _ GroupProjects . - 1 213 Chapter 9 SQL Server Add the Parameters to the Parameters collection @GroupProjectID _ 16 _ @GroupID _ .
