TableAdapter.Update() : One down, how many to go ?

See more:

C#

hi again,

here is my code :

int n = dsCfg.tblCfg.Columns.Count;

Object[] ao = new object[n];

ao[0] = "SETTINGS";
ao[1] = 0;
ao[2] = some value

dsCfg.tblCfg.LoadDataRow(ao,false);
taCfg.Update(dsCfg.tblCfg); // -> throws exception : cannot insert duplicate PRIMARY KEY

tblCfg has 6 columns : 0=nchar(10), 1=int, all others are type sqlvariant; 0 and 1 build PRIMARY KEY

so if it can't insert why doesn't it up ?
any help (except try this... (means i don't want to rewrite the project)) appreciated

thanks in advance