Adding a watch to a gridview update

[Dashley]

Is there anyway I can add a watch or somthing to the like to a Gridview update statement? The GV is bound to a data source but its not updating the data.

I've chopped the update staement down to basics.

UpdateCommand="UPDATE freightloads SET quantity = @quantity WHERE indx = 4">


 <UpdateParameters>                               <asp:Parameter Name="quantity" Type="Int32" />
</UpdateParameters>

If I use just:
UpdateCommand="UPDATE freightloads SET quantity = 4
The data updates
If I change the statement back to the first one above the data won't update.
I've tried it with/wo brackets, used a ? oinstead of @ and every way that I could think of with no luck.
I'm using Sql Server for the back end & VS 2005

 

[Dashley]

Disregard. I had another procedure fired from a page_load event repopulating the GV prior to the update. Duhhh.

 

[jbenson001]

Is there anyway I can add a watch or somthing to the like to a Gridview update statement? The GV is bound to a data source ...

This is why I always discourge the use of datasource controls. You CAN'T debug them.