Problem Using SqlDataSource to automatically Update Value of item in Gridview Row

  • Thread starter Vaughn Haybittle
  • Start date


Vaughn Haybittle


I have a Gridview that binds to a SQL Server 2000 Database Table.

I have configured the SelectCommand, UpdateCommand, InsertCommand and
DeleteCommand of the SQL DataSource. All of these commands work except the
Update Command. The SQL for the Update Command is as follows: "UPDATE
tblInductionVenues SET [email protected]_venue WHERE [email protected]_uid"

I have the following questions:
1) Do I need to manually configure the parameters in the Command and
Parameter Editor, or should the fact that they are named according the the
convention above be enough fo rthem just to work?
2) If I do need to manually configure the parameters then how do I get a
handle on the textbox that appears when the gridview is in edit mode (I know
how to specify the inv_uid by setting it to the selectedvalue of the
3) Why is it that my DELETE and SELECT Commands work perfectly but not my
UPDATE command
4) Is there any way to debug what is happening while the SqlDataSource is
executing my UpdateCommand SQL (I know that I can use the updating and
updated events just before and after the update, but I want to capture
exectly what happens during the update)

Any advice would be appreciated.




Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question