I have a gridview on a page that contains a hidden id column, a name and description column. I want to update within the grid so my update statement says"

UpdateCommand="Update [prayer] set [name]=@name,[desc]=@desc where [id]=@id"

I get an error saying it doesn't know what id is. Is it because it is hidden?


Also, I tried to set these edit commands while setting up the datasource but the update and insert options were grayed out so I manually typed in the statements.

Thanks,
Rut