On chapter 17 on page 576 it has a web site database program using SQL using ASP. The code is for the DataGridView try it out starting on page 575. I run the code from the book and get declare the scalar variable "@original_au_id" when I edit that works but when I hit the update button the error comes up. Everything else works and the same thing happens to the source code from the web site after making some modifications to the sql connection. Does anyone know what to do to correct this problem?

I found the answer to my own question. I looked at various web sites and found that you cannot use the WHERE au_id = @original_au_id as stated in the book. It will give you a Must Declare scalar variable. This is due to the fact that they used a beta version of VB2005. You must use WHERE au_id = @au_id and the update feature works.