can't update the primary key in a gridview

hertendreef · May 28th, 2006, 06:30 AM

Hi,

I defined a gridview with an UpdateCommand.
When i click on 'update' i can update all fields excepted the primary key.
Is there any way to make it possible?
(I use Access and when runing a update-query in Access, i can also update
the primary key).

Thanks

jbenson001 · May 28th, 2006, 03:42 PM

T he point of a primary key is to be unique. If it is changed then the related tables will have orphan data. The grid view will now allow you to do that.

hertendreef · May 29th, 2006, 03:44 AM

Thanks again,

but it must be possible to change a primary key, e.g. in case it's not an auto-generated key and it has no relationship with other tables ...

jbenson001 · May 29th, 2006, 10:31 PM

You can allow the update of the PK by setting the ReadOnly property to FALSE. Then you will have to change the UPDATE comand in the datasource. However, I don't recommend this. There is NO reason for a user, or ANYONE to change a primary key, and that is why the gridview by default will not allow it, even if there is no related data or it is not an autogenerate column

hertendreef · May 30th, 2006, 04:04 AM

Ok, thanks for replying