Question about the "Try It Out" that starts on page 213 titled "Implementing Views and Stored Procedures in VB 2005"

The code I inputed doesn't seem to be working. The Projects & Groups pages work properly. I've transitioned the database/project to SQL Server as directed earlier in the chapter.

I think the problem occurs because by default there is no data in the GroupProjects Table in the database. When the code enters the "ActionAdd()" section after selecting a Group in the dropdown list and clicking the "add" button.....basically nothing happens.

Using Debugger, I've found that the code never enters the "For...Next" loop below and thus never adds the appropriate entry in the database.

For intIndex = 0 To objGroupProjectsDS.Tables( _
    "GroupProjects").Rows.Count - 1
.....
objData.Command.ExecuteNonQuery()
.....
Next

Is there an error in the code? Do I need to have some "sample" data in the database for the program to enter this For/Next loop?

Thanks for your help

This exercise adds new group projects to the database. If you feel that you have made an error in entering the code, please review your steps and as a last resort you can download the sample code for this chapter and verify it against your code.

Thearon

I found the problem....took about 6-7 checks of the code to finally catch it. I had the "DragDrop" event coded for "lblGroupProjects_DragDrop" and not "lstGroupProjects_DragDrop"....those two letters took me forever to find. Thank you debugger.

On a side note, I did download the sample code, however the version that you download from this website only has the final version of the code (and thus all the reworks from Chapter 10 on Business Logic that overwrite some of the code in Chapter 9).

Anyway, I found it and it works now. Thanks for your help.