Click here to Skip to main content
12,951,710 members (70,964 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
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
Posted 14-Feb-13 3:14am
fheyn758
Updated 14-Feb-13 3:32am
v2
Comments
Richard MacCutchan 14-Feb-13 10:01am
   
I think that message is trying to tell you something.
richcb 14-Feb-13 10:15am
   
As Richard said, you cannot insert a duplicate primary key. That is your answer, you are attempting to do that and you cannot.

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

hi,

got it : TableAdapter's Fill-Methode was missing !

now works fine !
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,229
CHill60 3,490
Maciej Los 3,083
Jochen Arndt 1,975
ppolymorphe 1,880


Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 14 Feb 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100