Tara
09-15-2009, 06:48 PM
Here's the UpdateCommand:
=UPDATE WorkPhoneStaff SET [PhoneID] = @PhoneID WHERE [EmpID] = @EmpID and [PhoneID]=@PhoneID"
If PhoneID is not declared a data key name (I've got an array of two - EmpID and PhoneID), then the error "must declare scalar variable phoneID" occurs. If I make PhoneID a data key name, no update occurs - the gridview field is not even editable (no text box appears in edit mode) - because its a key field and can't be edited?
I've a lot of time trying to resolve this and would appreciate any insight you can give.
=UPDATE WorkPhoneStaff SET [PhoneID] = @PhoneID WHERE [EmpID] = @EmpID and [PhoneID]=@PhoneID"
If PhoneID is not declared a data key name (I've got an array of two - EmpID and PhoneID), then the error "must declare scalar variable phoneID" occurs. If I make PhoneID a data key name, no update occurs - the gridview field is not even editable (no text box appears in edit mode) - because its a key field and can't be edited?
I've a lot of time trying to resolve this and would appreciate any insight you can give.