I’m having a horrible time trying to discover why I can’t update one side of a composite primary key in asp.net FormView control.
I have a table that uses a number field and a field called Alias that I need to update. I am able update the Alias field fine in my Access database that links the Oracle tables, but not in the FormView where I need it for my web application. I’m using the standard sqldatasource with update, insert, and delete commands. I don’t get an error – the update just doesn’t go in for Edit mode. No problem with inserting. Tried adding :original_alias in the where clause – had no effect. I have a short schedule for developing this web application. Please help!