After I update the record I get this error:
Must declare the scalar variable "@original_PlayerID".

?????Help

Thanks in advance,

mshytech

I had the same error. I fooled around with the code and changed the end of line 51 from:

WHERE [PlayerID] = @original_PlayerID

to:

WHERE [PlayerID] = @PlayerID

...that seemed to do the trick. Hope that helps.

Thanks. It works. Have a great day!

i don't think this is the right way, if change the original_playerid become playerid, all the records will be changed.....

i think it should be:

added this line

<asp:ControlParameter Name="Original_PlayerID" Type="String" ControlID="GridView1" PropertyName="SelectedValue"></asp:ControlParameter>


after line 60 <UpdateParameters>

This is a bug in the auto-generated code! Somehow some old code has sneaked through. The first solution given here is indeed right, there is no @original_playerid, and so you can safely change it to @PlayerId. There is no need to add a ControlParameter. I believe Dave Sussman is at this moment reworking the chapter for the C# version and he will add some more to this thread (as well as making sure it's corrected in the code) about this matter.

Chris

Chris Ullman
Programmer/Technical Author
http://www.cuasp.co.uk