I'm working with VS 2008. I've got a data grid control, which I populate through a DropDownList that is data bound using a stored procedure. When the DDL changes it updates the contents in the DataView control. The DataView control is also data bound, and is populated using its own stored procedure and the code returned from the DDL once the user selects something. I've got another stored procedure assigned to the DeleteCommand of the SqlDataSource, which I intend to use is with a delete CommnadField of the DataView control. However, in this case I want to use the value from one of the fields in the selected row of the DataView as a parameter to the delete command (stored procedure), to delete the record from the relevant tables. I don't want to use the ID that comes from the DDL; that is inappropriate (and just plain wrong).
So, how do I do what I want to do? Walking through the wizard it doesn't give me a chance ...
Go to the complete details ...