Hi, I want to remove the row then add the fresh new one, so I don't have to
decide to update or add.
I always add, because I delete any existing row.
However I'm stuck with the error below:
Violation of PRIMARY KEY constraint 'PK_dtotel'. Cannot insert duplicate
key in object 'dtOtel'.
dtOtelTA.Fill(dtOtelDT); //Load the data
try {
//Find the row then delete if exists
dtOtelRow = dtOtelDT.FindBykayitID(intAktifKayıtID);
dtOtelDT.RemovedtOtelRow(dtOtelRow); //Remove it
dtOtelTA.Update(dtOtelDT); }
catch (Exception ex) { };
//Now create a new one:
dtOtelRow = dtOtelDT.NewdtOtelRow();
dtOtelRow.kayitID = intAktifKayıtID; //Foreign key
dtOtelDT.AdddtotelRow(dtOtelRow); //Add row
dtOtelTA.Update(dtOtelDT); //Update the database
It looks like the row never has been not deleted.
Do I miss anything? Thanks...